Intermediate Excel Training builds on foundational skills to introduce powerful tools for data analysis, lookups, and reporting. Learners gain confidence in managing larger datasets, applying advanced formulas, and creating insightful summaries with PivotTables.
English
Last updated
Sun, 07-Jun-2026
This Intermediate Excel course is designed for learners who already understand the basics and want to take their skills to the next level. Over 12–16 hours of structured lessons, participants will explore:
Working with named ranges and structured tables
Applying advanced formulas such as SUMIF, SUMIFS, COUNTIFS, and text/date functions
Using lookup functions (VLOOKUP, XLOOKUP, INDEX+MATCH) for dynamic data retrieval
Building logical formulas with nested IF and IFS
Designing PivotTables and PivotCharts for quick analysis
Enhancing reports with conditional formatting and data validation
Creating intermediate-level charts and visualizations
Cleaning and preparing data for analysis
By the end of this program, learners will be able to confidently analyze datasets, automate repetitive tasks with formulas, and present professional reports. This level is ideal for professionals in finance, operations, HR, and students preparing for data-driven roles.
