Excel Course
Beginner-to-advanced Microsoft Excel training: formulas, data cleaning, pivot tables, charts and dashboards.
View course →Excel Skills for Jobs
A role-by-role view of Excel skills, from everyday to advanced.
| Level | Skills | Learn it |
|---|---|---|
| Everyday | Tables, filtering, SUM/IF, charts, formatting | Excel course |
| Intermediate | XLOOKUP, SUMIFS/COUNTIFS, pivots, data validation | Excel course |
| Advanced | Dynamic arrays, Power Query, Power Pivot, automation | Advanced Excel |
| Analytical | Profiling, variance analysis, dashboards | Data analysis, dashboards |
By function
- Finance and accounts: reconciliations, lookups, variance, pivots
- MIS: recurring reports, Power Query, dashboards
- Sales and operations: SUMIFS, pivots, forecasting basics
- HR: headcount and attrition summaries
Advanced Excel roles
Listings that say “advanced Excel” often mean lookups, pivots, Power Query and sometimes macros. Read each listing for specifics, then match them with the Advanced Excel course topics.
Next level: add Power BI. No course guarantees a job.
Related courses
Advanced Excel Course
XLOOKUP, dynamic arrays, advanced pivots, Power Query, Power Pivot and automation for people who already use Excel daily.
View course →Excel Data Analysis Course
The analytical process in Excel: frame the question, clean and profile data, analyse with pivots and statistics, and present findings.
View course →Talk to a CharterPeak counsellor
Tell us your background and goal, and we will suggest the right starting point - Excel, Power BI or the full Excel + Power BI program.