Modern Excel: AI, Analytics & Formulas

Modern Excel: AI, Analytics & Formulas

This course consists of a two-day workshop on modern Excel, incorporating formulas, automation tools such as Power Query, time-saving techniques, Excel’s built-in AI features, PivotTables and dashboards for analytics, and more to help participants become more skilled and productive.

Outcomes

• Use Power Query and macros to automate data transformations

• Use modern functions such as XLOOKUP, TEXTJOIN, SWITCH, IF, UNIQUE, and VSTACK

• Understand why many older tools have been replaced with modern versions, such as VLOOKUP, CONCATENATE, and PivotTables

• Clean data using advanced copy-and-paste shortcuts, automated highlights, and data validation

• Analyse data using GROUPBY, PivotTables, charts, and interactive dashboards

• Understand built-in AI (Flash Fill, Auto-Analyse Data) versus the paid Copilot

• Build robust tables using the “Format as Table” feature

• Use keyboard shortcuts and other time-saving techniques

  
  

Who Should Participate?

This masterclass is designed for individuals who use Excel for 3 or more hours per week and wish to integrate modern Excel’s most powerful features into their regular work.

Post-Training Website Features

1. Notes on key concepts covered.

2. YouTube videos from the trainer’s 20,000+-subscriber tutorial channel.

3. Slides from the trainer’s course presentations.

4. Full set of completed exercise files.

   
   

About the Trainer

Certified Microsoft Excel Trainer, Chartered Accountant and Data Analytics Consultant. Originally from Gibraltar, the trainer has delivered Excel training to more than 3,000 people worldwide and provides data and spreadsheet consulting services through Xlconsulting, a Cambodia-based company.

He is a Microsoft MVP, a title awarded to top Excel experts globally. His MVP bio lists his blogs, webinars, and videos, and his LinkedIn profile has more than 10,000 followers.

Venue: TBC (central Phnom Penh)

Date: 24th and 25th November 2025

Time: 8.30 am to 5 pm, each day

Tickets: Early bird price (until 14 Nov) is USD $265 for members and $315 for non-members. The regular price is $280 for members and $330 for non-members.

Registration: https://www.eurocham-cambodia.org/event/1461/Modern-Excel-AI-Analytics-and-Formulas-Cohort-2

Join this engaging and practical training programme designed to strengthen your Excel capabilities. Seats are limited, so early registration is encouraged. If registrations exceed available seats, additional participants will be offered a new class with a separate start date.

For more information:

Vannrithy Van, Junior Training Academy Officer

Email: market.analyst3@eurocham-cambodia.org

Telegram: +855 (0) 10 887 950