About the Course
This intensive two-day course is specifically designed for intermediate users who want to accelerate their daily productivity and transition into professional data handlers. Instead of overwhelming you with complex coding or database modelling, this course sharpens your day-to-day execution. You will learn the top shortcuts used by experts, master crucial logical and lookup functions, ensure spotless data quality using built-in validation tools, and dive into automated data cleaning with
Power Query. The course concludes with building clean, dynamic PivotTable dashboards using real-world business case studies in Sales, HR, and Finance.
Course Benefits & Deliverables
- Practical Learning: Built entirely on real case studies developed for modern business environments.
- Post-Class Assets: Video tutorial support provided after the class to ensure you can replicate everything at your job.
- Immediate Impact: Designed to immediately reduce manual work effort from hours to minutes
2-Day Training Schedule & Breakdown
Day 1: Workflow Efficiency, Intermediate Formulas & Data Quality
Morning Session (8:30 AM – 12:00 PM)
Module 1: Excel Architecture & Power Shortcuts
▪ Navigating the Excel environment efficiently and setting key Excel options.
▪ Discovering 20 “Super User” shortcuts to instantly double your working speed.
▪ Converting raw ranges into Excel Tables for dynamic, automated formatting and sorting
Module 2: Essential Intermediate Formulas
▪ Conditional math: SUMIFS, AVERAGEIFS, and COUNTIFS.
▪ Practical lookups for daily tasks: Master VLOOKUP and the modern XLOOKUP.
▪ Text and Date manipulation functions to clean messy names or dates.
Afternoon Session (1:00 PM – 5:00 PM)
Module 3: Data Quality Management & Validation
▪ Preventing user errors: Setting up basic, dynamic, and dependent Data Validation drop-down lists.
▪ Custom number and date formatting rules.
▪ Using Dynamic Conditional Formatting to automatically highlight key performance metrics
Module 4: Security & Error Troubleshooting
▪ Protecting specific work cells, entire worksheets, or locking down workbooks.
▪ Understanding and quickly fixing common Excel formula errors (#VALUE!, #N/A, #REF!).
Day 2: Automated Cleaning, PivotTables & Dynamic Dashboards
Morning Session (8:30 AM – 12:00 PM)
Module 5: Modern Data Cleaning with Power Query
▪ Introduction to Power Query: A tool tailored for clean workflow transformation without complex code.
▪ Importing data from external sources like Text/CSV files or combining multiple sheets.
▪ Cleaning data with a single click: Text-to-columns, removing duplicates, and reshaping/unpivoting data
Module 6: Intermediate PivotTables & Analytics
▪ Summarising massive data tables effortlessly using PivotTables.
▪ Grouping data by month/year and adding calculated fields.
Afternoon Session (1:00 PM – 5:00 PM)
Module 7: Interactive Pivot Charts & Dashboard Planning
▪ The core rules of clean data visualisation and choosing the right chart.
▪ Creating interactive visual elements using Slicers and Timelines to filter data seamlessly.
Module 8: Capstone Case Study (Hands-on Lab)
▪ The 2-Day Project: Taking a raw, messy business dataset, clean it via Power Query, analysing it with a PivotTable, and building a fully operational, interactive sales/HR dashboard from scratch.
The Trainer
The trainer is a dedicated technology lecturer based in Phnom Penh, Cambodia, and a dynamic professional with over seven years of diverse experience across financial analytics, HR analytics, project management, marketing, and executive leadership.
Currently serving as a Data Analyst at Comin Asia, he specialises in finance transformation and business intelligence. He designs and manages data-driven dashboards that support strategic decision-making across multiple countries, including Cambodia, Laos, Myanmar, Thailand, and Australia. His work focuses on enabling organisations to become more data-driven, enhancing financial visibility, operational efficiency, and strategic planning capabilities.
As a certified Power BI and Professional Excel trainer, he has led impactful digital initiatives, including the development of financial dashboards, HR scorecards, and recruitment analytics systems. His ability to translate complex data into actionable insights has empowered senior management and executives to make informed, data-driven decisions. He is widely recognised for his practical, business-oriented approach to analytics and his commitment to knowledge sharing.
Course Language:
The course will be conducted in English (and Khmer when necessary)
Course Details
Early bird price: $265 for member | $315 for non-member (Deadline: 23 September 2026)
Standard: $280 for member | $330 for non-member
Date: 1-2 October
Time: 8:30 AM – 5:00 PM
Location: Phnom Penh (TBC)
For more information: +855 10 887 950 market.analyst@eurocham-cambodia.org
