Interested in attending? Have a suggestion about running this course near you?
Register your interest now


This hands-on workshop aims to equip participants with the competency and confidence to apply the essential excel functions for business analysis and financial reporting. Participants will also learn the fundamentals of transforming static formula to interactive formula in order to produce sustainable reports.

Programme Outline

  • Absolute versus relative referencing
  • Understanding Range names and how to apply them
  • Working with Text functions
  • Working with Date functions
  • Lookup and reference formulas
  • vlookup, index and match, choose and match
  • Logical functions - if
  • Mathematical formula - sumif, sumifs
  • Form controls

This is a 1-day programme where participants will get to apply their knowledge with hands-on exercises, guided by the Trainer.
Participants are required to bring along their laptops, equipped with Microsoft Excel.

Target Audience

Accounting and Finance Professionals and Business Executives who would like to develop their skills in complex spreadsheet systems in business analysis and financial reporting. Participants without prior knowledge and experience in EXCEL will also find this workshop valuable in applying their acquired skills swiftly in the workplace.

Expert Speaker

Wong Suet Yin

Suet Yin graduated from the National University of Singapore with an accounting degree and is a member of the Institute of Singapore Chartered Accountants (ISCA). She has more than 20 years of working experience in the areas of accounting, tax, project management and training, and has held several management positions with large MNCs.

Suet Yin is very passionate in training and is always ready to share her knowledge with others. She also customises her training to suit individuals’ and their corporations’ requirements. She adopts a pragmatic real world approach during training and believes in making her training fun and enjoyable.

Coming Soon

All Coming Soon >>


Our webinars operate on a 'one-connection-one-fee' basis, so you can have your whole team participate together in a boardroom setting for one cost effective price, using one registered log-in connection. The registered attendee will receive a CPD certificate.


Like the topic but can’t make the time? Register for the Live Session and you’ll receive the Recording regardless! Recordings are provided for webinars with a duration of 3 hours and less.