Essential Excel skills for Business Analysis and Financial Reporting

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.

  • Mar 16
    Mon, 9:00 AM - Mon, 5:00 PM Hotel Venue to be Advised
    • $428.00 incl. GST (7%)
    • PD hours: 7

Coming Soon

All Coming Soon >>

One-Connection-One-Fee

Our webinars operate on a 'one-connection-one-fee' basis so you can have your whole team participate for one cost effective price and claim CPD points.

Recordings

Like the topic but can’t make the time? Register for the Live Session and you’ll receive the Recording regardless! You can watch it as many times as you like for up to 6 months. You will also receive Supporting Documentation.