Microsoft Excel | Advanced

Duration: ~ 8 hours | Fee: PROMO🔥

Training Objective:

This hands-on Advanced Excel course helps participants automate, analyse, and visualise data using advanced functions, Power Query, PivotTables, and basic VBA macros for real-world reporting and productivity.

Training Outcome:

By the end of this training, participants will: 

✔️ Extract, clean, and consolidate data quickly.

✔️ Apply advanced formulas and lookups for analysis.

✔️ Build interactive PivotTables and charts.

✔️ Automate repetitive tasks using VBA with ChatGPT support.

Program Delivery:

All sessions are conducted online via Microsoft Teams in a one-on-one format, ensuring personalized attention and flexibility.

Module 1

Mastering Data Extraction & Consolidation 

1.1 Excel Tables: The Smarter Way to Manage Data 

1.2 Split and Clean Data Instantly with Text to Columns

1.3 The Basic Power Query in Action

Module 2

Let’s Master the Powerful Functions 

2.1 IFS, IFERROR, IFNA

2.2 SUMIFS, COUNTIFS

2.3 Logic Functions: OR, AND

2.4 VLOOKUP, XLOOKUP (advanced)

Module 3

PivotTable Mastery 

3.1 Build PivotTables That Work for You

3.2 Make Reports Interactive with Slicers

3.3 Analyze What Matters: Sum, Average, Max, Min

3.4 Create Basic Pivot Charts in Seconds

Module 4

Basic VBA Macro – Made Easy with ChatGPT (No Coding Skills Needed)  

4.1 Enabling the Developer Tab

4.2 Inserting a Module in the VBA Editor

4.3 Generating VBA Code with ChatGPT

4.4 Pasting and Saving the VBA Code

4.5 Assigning the Macro to a Button