Microsoft Excel | Intermediate

Duration: ~ 8 hours | Fee: PROMO🔥

Training Objective:

This one-day hands-on training helps participants master essential intermediate Excel skills to work faster, cleaner, and smarter. The session focuses on practical tools and formulas that improve data accuracy, automate routine tasks, and generate quick insights using Tables and PivotTables.

Training Outcome:

By the end of this training, participants will: 

✔️ Apply key Excel tools to manage and organise data efficiently.

✔️ Build and troubleshoot logical and lookup formulas.

✔️ Control and validate data entries for accuracy.

✔️ Structure data using Tables and quick-clean methods.

✔️ Summarise information effectively with PivotTables.

Program Delivery:

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

Module 1

Work Smarter in Excel — The Core Productivity Toolkit

1.1 Mastering Filtering & Sorting

1.2 Paste Special Secrets: Save Time & Work Smarter!

1.3 Split, Freeze & Find: Navigating and Editing Like a Pro

1.4 Absolute vs. Relative References

Module 2

Excel Formulas Unlocked — Build Logic and Insights

2.1 IF, AND, OR

2.2 TRIM, CLEAN & TEXT Functions

2.3 SUMIF, COUNT, COUNTA, COUNTIF

2.4 VLOOKUP & XLOOKUP Made Easy

Module 3

Control Data Entry — The Power of Data Validation

3.1 Basic Data Validation Types

3.2 List-Based Validation

3.3 Input Message & Error Alert

3.4 Managing and Troubleshooting

Module 4

Smart Tables & Basic PivotTables for Instant Analysis  

4.1 Excel Tables: The Smarter Way to Manage Data 

4.2 Clean Data Instantly with Text to Columns

4.3 Build Basic PivotTables That Work for You