Excel Master Class for Professionals
Build a spreadsheet mindset and handle data efficiently in Excel. An online course for working professionals covering spreadsheet thinking, data quality control, essential Excel functions, Power Query, report visualisation and basic automation with macros.
Comfortable with Excel but still struggling at work?
This course suits people who use Excel regularly but run into one or more of the following.
Files without structure
Workbooks organised inconsistently, making them hard to update and check.
Time lost to repetition
Too much time spent cleaning, consolidating and formatting data, without using Power Query, PivotTables and macros.
Choosing the wrong functions
Not knowing which functions to use or how to combine them, and reports that are not clear enough to support decisions.
What you take away from the course
A systematic spreadsheet mindset
Setting up workbooks, organising files and building habits that make spreadsheets easy to use, check and update.
Efficient data handling
Using formatting tools, data validation and Power Query to clean, transform and consolidate data.
Essential Excel functions
Applying lookup, dynamic array, logical, date and selected financial functions to real situations.
Presentation and automation
Using charts, PivotTables, an introduction to Power BI and basic macros to improve analysis and handle repetitive tasks.
Course content (4 modules)
Hanh Tran, MA
Senior Finance Analyst, CFO Office, Challenger Group Limited
- Certified Master Anaplanner
- Microsoft Office Specialist Excel Expert
- CFA — Level I completed [designation to be confirmed]
- 10+ years of experience in strategy, a research centre, a consulting firm and investment management
Excel Master Class
Initial access fee covering the first two months.
Extension fee for the following four months. [To be clarified: whether renewal is automatic or opt-in; how to cancel; whether the 1-on-1 session and materials continue during an extension.]
Early bird offer. [to be confirmed: early bird closing date]