Interested in attending? Have a suggestion about running this course near you?
Register your interest now
Description
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.