About the Course
This course consists of a two-day workshop on Modern Excel, incorporating formulas, automation tools such as Power Query, time-saving tricks, Excel’s built in AI features, PivotTables/dashboards for analytics, and much more to accelerate you into being more skilled and productive.
Course Objectives
By the end of this workshop, participants will be able to:
- Use Power Query and macros to automate data transformations
- Use modern functions: XLOOKUP, TEXTJOIN, SWITCH, IF, UNIQUE, VSTACK
- Understand why many older tools have now been replaced with more modern versions like VLOOKUP, CONCATENATE & PivotTables
- Clean up data with advanced copy/paste tricks, auto-highlights and data validation
- Analyse data using GROUPBY, PivotTables, charts and interactive dashboards
- Understand built in AI (Flash fill, auto-analyse data) vs the paid Copilot
- Build robust tables with the rarely used “Format as table” feature
- Use keyboard shortcuts and other time-saving tricks
Who is this course for?
This masterclass is aimed at people who use Excel for 3 or more hours per week and wish to incorporate modern Excel’s most powerful features into their regular work.
Full Course Details:
Take home materials and documentation
Post training website featuring all post course resources with:
1. Notes on key points covered
2. YouTube videos from the trainer’s 20,000+ subscriber tutorial channel
3. Slides from trainer’s course presentations
4. Full collection of completed exercise files
About trainer:
Certified Microsoft Excel Trainer | Chartered Accountant | Data Analytics Consultant
Originally from Gibraltar, our trainer has trained over 3,000 people in Excel globally and provides data and spreadsheet consulting services through his Cambodia-based company Xlconsulting. He is a Microsoft MVP, a prestigious title given to the top Excel people globally. His MVP bio shows a full list of his blogs, webinars, videos, and more. His LinkedIn has over 10k followers.
REGISTER HERE
Date: 27-28 October
Time: 9:00 AM – 5:00 PM each day
Location: TBC (Phnom Penh)
Early Bird Price:
$265 for Member | $315 for Non-Member
Deadline: 10 October 2025
Normal Price:
$280 for Member | $330 for Non-Member
Join us for an engaging and practical learning experience designed to give you the skills and knowledge you need to succeed. Seats are limited, so early registration is strongly encouraged. If registrations exceed available spots, additional participants will be grouped into a new class with a separate start date.
For more information contact Vannrithy VAN, Junior Training Academy Officer Email: market.analyst3@eurocham-cambodia.org Telegram +855 10 887 950
Our trainer also has a YouTube channel with over 9,000 subscribers where he releases weekly videos about tech, focusing on new features.
