• Are you a MS Excel heavy user?
  • Do you wish your overwhelming data give you insight with MS Excel?
  • Do you wish to bring your boring data to life with interactive data tables?
  • Do you wish to build a dancing chart using MS Excel?
  • Do you wish to overcome formula error issues?
  • Do you wish to know if you can have your data and charts on MOBILE APP?

If you have more than 2 YES’, we have GOOD NEWS for you, our 2-hour Smart Excel workshop can make your wishes come TRUE.

Watch our video for the 2-hour Smart Excel workshop

For more information and registration, please download the flyer.

(to be uploaded)

Bring along your own laptop (with mouse) installed with Excel 2010, 2013, 2016, 2019 or MS 365.

Upcoming events

2 Hours Workshop

Date    : (to be advised)
Time   : 9.00am - 11.30am
Venue : (to be advised)
88300 Kota Kinabalu, Sabah

• Your investment :  RM328/pax  RM38/pax
• Limited seats : 25 pax
• Closing date: (to be advised)

Register NOW!

Download flyer
(to be uploaded)

Terms & Conditions - 2 hours Workshop
1. Full payment is required on or before the closing date of the event. Upon full payment, participant is considered successfully registered for the event, subject to seat availability.
2. Transfer is allowed upon written notification.
3. Cancellation or no show by the participant is non refundable.
4. The organizer has the right to change the venue.

“Build dancing chart and dynamic data table."

Further to the 2-hour workshop......

  • Do you wish you can have visual highlights and alerts in your regular reports (in MS Excel) that give you actionable information?
  • Do you wish to have multiple comparison of graphs to spot trends and patterns of your business?
  • Do you wish to have interactive commentaries using MS Excel that allows you to answer questions on the spot?
  • Do you wish to be able to update your regular reports accurately at the fraction of your usual time?
  • Do you wish to be able to present your dynamic report in MS Excel, instead of PowerPoint?
  • Do you wish to be able to put your Excel data and charts on MOBILE APP?
If you have more than 2 YES’, we have GREAT NEWS for you, our 2-day Smart Excel workshop can make all your wishes come TRUE.

Watch our video for the 2 days Smart Excel training

 
 
During the training, you will learn.....
  • Build sustainable and dynamic business reports with dancing chart and interactive data table.
  • Create business reports that gives insightful information for monitoring and further actions.
  • Build structure so that report updating can be made easy.
  • Develop a simple MOBILE APP to have data and charts at your fingertips
  • ....and many more.

For more information and registration, please download the brochure. (to be uploaded)

Bring along your own laptop (with mouse) installed with Excel 2010, 2013, 2016, 2019 or MS Office 365.

Terms and conditions

Terms & Conditions for the public training between 2 to 5 days, please click on the link below.

https://www.smartexcel.net/terms-conditions/

 

If you have any inquiry, feel free to get in touch with us at 016-830-4005

2 Days Training

Date    : (to be advised)
Time   : 8.30am - 5.00pm
Venue : (to be advised) Kota Kinabalu

• Your investment :  RM2,300 / pax
• Limited seats : 15 pax only
• Closing date: (to be advised)

Register NOW

Download registration form

(to be uploaded)

Payment methods

• Cheque made payable to SMART EXCEL
• Transfer online
Name : Smart Excel
Bank : Public Bank
Account No : 320 811 4010

 

Terms & Conditions for the public training between 2 to 5 days, please click on the link below.

https://www.smartexcel.net/terms-conditions/

If you have issues on the registration, get in touch with us thru Whatsapp at 016-830-4005 and we will assist you.

Free in-house course preview can be arranged.

How OUR COURSE helps you...

Create interactive and dynamic report using MS Excel

What Smart Excel is

Smart Excel is an innovative yet structured approach in using spreadsheet to build business models based on sustainable principles. With the right combination of simple formula and functions, you can create your own Business Intelligent-like reports and Dashboards by just using MS Excel. The best part is you can update these regular reports and Dashboards at a fraction of your usual lead time.

Above all, it transforms your usual dump data reports into dynamic analysis with charts. Thus, your audience will appreciate meaningful insights with interactive commentaries, key performance indicators and metrics.

Smart Excel
During the first 2 days of training, you would build dynamic reports and interactive charts and commentaries.

Check it out.

On Day 3, you would build Budget and Investment simulations with buttons that make your decision making faster and easier.

On Day 4 & 5, you will learn how to create effective dashboards that speak volume.

“A new level of mindset on how to communicate your findings and stories in data visualization."

“Build business models based on sustainable principles."

Free in house course preview can be arranged.

Excel’s potential are woefully underutilized by the majority of users. This course will help you discover how to simplify your approach to problem solving by using Excel, particularly those powerful functions that are rarely known to many. We impart to you how to be quick, accurate, flexible, and creative.

During the course, we will also help you to elevate to a new level of mindset on how to communicate your findings and stories in visual analytics by harnessing Excel’s strengths as a simple-yet-effective tool.

“Bring your boring data to LIFE !"

Participants Reviews

caret-down caret-up caret-left caret-right
Mesi Power Contract Management

".......Angela is very professional and very helpful...Though class was very intensive but we enjoyed throughout the class as we solved a lot of exercises together .... the functions and formula I learned is very useful to my work...."

Edward Finance Department

"......Previously my summary was quite long and big.... When I need to printout, I had to squeeze all the tables together. With the functions and technics that I learned, I can now simplify my summary even more. In fact I can put in more new data which is useful for management in decision making.... With interact tables and charts, it would ease our management to view different period.... "

Jaffar Regulatory Economics & Management Division

"....It is very interesting and many unexpected technics....I've learnt a lot and I know I can achieve more from now on....It's a must for everyone who works with EXCEL."

Merryana Delivery Division

"......By learning this Smart Excel actually help me in my daily task in handling large data. I now know I can simplify and make my data presentation more meaningful...."

Clientele

Our Course

OBJECTIVES

This programme seeks to enable participants to:

  • Build reliable models based on sustainable principles
  • Technics to clean raw data and to construct data empire
  • Create integrated reports with interactive commentaries
  • Build impactful presentation with dynamic tables and charts
  • Create what-if scenarios (ie Budget and Investment) for planning, appraisal and better decision making.
  • Design and develop dashboards enabling effective communication and insightful analysis for business strategies.

LEARNING OUTCOMES

Upon completion of this program, participants should be able to compile and produce insightful periodic reports and create simulations and dashboards.

*Important: Participants are required to bring their own laptop (with mouse) installed with MS Excel 2010 or 2013 or 2016 or 2019. (Computer / laptop will not be provided.)

C

METHODOLOGY

  • Face to face training with more than 50 hands-on exercises.
  • Discussion and brain-storming sessions.
  • Pre-Learning materials: It will be emailed to participants two weeks earlier for practice and in preparation for the intensive course.
  • Post-Course work: To reinforce learning, participants are encouraged to submit coursework within a month after the course. Participants can seek guidance for FREE during the period.
  • Small ratio class for effective learning. Maximum number of participant is 15 pax.

 

Our Program

Day 1

  • Are you getting insights from your current data analysis?
  • Why should we use MS Excel?
  • What is “©Smart Excel”?
  • Golden rules of building sustainable business modelling.
  • Techniques on how to clean raw data and construct data empire that can be audited.
  • Build purposeful worksheet for data summarization and manipulation.
  • Create basic interactive reports and charts with buttons by pulling from the selected data.

Day 2

  • Create integrated reports using data from different sources of information.
  • Create interactive reports with alert indicators and highlights.
  • How to overcome error results and linkage issues.
  • Build comparison graphs and charts that give insights with multiple selections.
  • Build impactful presentation with interactive commentaries.
  • Develop a simple MOBILE APP to have data & charts at your fingertips.
  • Illustration of some useful formulas and functions that are rarely being explored.

Day 3

  • Develop what-if scenario with intelligent simulations for sales budget.
  • Create human resource working sheet that computes HR cost which changes according to the recruitment month, division and level of position.
  • Create fixed assets (or Capex) working sheet that computes cashflow and depreciation cost which changes according to the approved assets, asset category and purchased period.
  • Built-in semi-variable costs working sheet that changes the value according to the change of revenue.
  • Create flexible cash flow working sheet that changes according to terms of payment (ie cash terms or credit terms).
  • Build dynamic simulation for investment to generate result for Net Present Value (NPV), Interest Rate of Returns (IRR) and payback period based on various factors namely investment value, net cash flow (including product selling price, profit margin and sales volume), asset life span, among others.
  • Illustration of some good functions for simulations that are rarely being used.

Day 4

  • What is data visualisation?
  • Type of colour and text format that are reader friendly and that give maximum impact to audience.
  • Highlight common mistakes in charts and graphs.
  • Type of suitable graphs for different scenario.
  • Construct more than 10 effective charts and graphs that give insights.
  • Explore various chart tools and chart elements that are rarely being explored.

Day 5

  • Construct an interactive business dashboard with effective charts and tables.
  • Presentation techniques with storytelling to bring out your findings and messages to your audience.
  • Brainstorming session and group presentation of a business dashboard based on a real case study.
  • Illustration of some good functions for business dashboard that are rarely being explored

Upcoming

Time   : 8.30am - 5.00pm
Venue : (Venue to be advised)
               Kota Kinabalu, Sabah

Day 1 & 2 : RM2,300/pax (Date to be advised)
Day 3        : RM1,200/pax (Date to be advised)

Day 4 & 5 : RM2,300/pax (Date to be advised)

For more information and registration, please download the brochure. (To be uploaded)

Limited seats : 15 Pax

Payment methods

• Cheque made payable to SMART EXCEL
• Transfer online
Name : Smart Excel
Bank : Public Bank
Account No : 320 811 4010

 

Terms & Conditions for the public training between 2 to 5 days, please click on the link below.

https://www.smartexcel.net/terms-conditions/

If you have issues with the register, get in touch with us thru Whatsapp at 016-830-4005 and we will assist you.

“Develop multiple What-if scenarios"

"Build effective charts that speak volume."

"Business Dashboard based on real case study."

Who Should Attend?

Suitable for professionals in

  • Finance
  • Human Resource
  • Business Development
  • Consulting
  • Marketing
  • Production
  • Engineering
  • Especially for those wanting to move up to lead future analytics and reporting

Pre-requisite

Participant should be

  • a regular user of MS Excel for at least one (1) year
  • possess at least MS Excel Level 1 (Basic) skills
  • familiar with navigating around the software

Public training

Public training will be organised from time to time.
Get in touch with us if you are interested so that we can keep you posted.

In House Training

In house training can be arranged at your time and place. We can tailor our courses to meet your needs and train your whole department to become the agent for change in your organisation.


 

"We can hold FREE in-house course PREVIEW. Call us now!"

 

About YEN SIZ MEE (Angela)

Course Developer | Master Trainer | Consultant

(Registered with HRDF No: TTT / 17452)

Angela has a diverse career experience that spans from corporate consultancy to audit and managing companies. This includes a seven-year tenure with one of the “Big 4” as a Senior Consultant. She handled feasibility studies and corporate restructuring such as IPO, reverse takeover, corporatisation, privatization and corporate debts restructuring for various industries namely palm oil, shipping, timber, construction & property related, tourism, financial brokerage, government-link companies, among others.

Later whilst with a KLSE-listed group, she was responsible for preparing the budgets, projections as well as business models and simulations for potential business proposals. Her knack for preparing appropriate SOPs had contributed additional million-ringgits in revenue.

Her current passion is in business analytics and data visualisation. Angela alleviates her clients to the next level of interpreting their data with interactive business reports and effective chart presentation couple with storytelling, thus enabling them to make informed data driven decisions faster and easier.

A UK-graduate, Angela is known for her realistic, methodical and practical orientated delivery that take her participants to think out of the box and how to bring boring data reports to LIFE.

Currently, she is also a business coach with Vistage, an international organisation of 23,000 members who are CEOs and business owners.

 

Angela - Course developer and course trainer

"Realistic, methodical and practical orientated delivery."

GET IN TOUCH...

To join a training or arrange for consultation, send us a message or call us.

Smart Excel

Contact person : Angela Yen
Mobile: +6016-8304005
Email: angela@smartexcel.net

Address: Unit D-2-5, Tanjung Aru Plaza
Kota Kinabalu, Sabah Malaysia
(By appointment only.)

Fields marked with * are required

Let’s discover how to use simple spreadsheet functions MS Excel to create interactive reports, dynamic charts and automated commentary. This course meets your unique business challenges at a fraction of the time taken compared to your usual standard practice and process. It enables you to present concise information to management quickly and with maximum data integrity.

Free in-house course preview can be arranged.

Call us now for more information.

Privacy Policy

The information provided is solely for the use of the company in order to serve our clients better. We strive to use commercially acceptable means to protect our clients' personal information but we cannot guarantee its absolute security.

Scroll to top