Microsoft Excel — Intermediate
Move beyond the basics with conditional logic, lookups, charts and pivot tables.
2 days (14 hours)
KES 15,500
per participant
About this course
Designed for users already comfortable with the basics, this course unlocks the productivity features that turn Excel into a real analysis tool. You'll combine functions, look up data across tables, visualise results and build your first PivotTables to summarise large datasets in seconds.
Class goals
- Build decision-making formulas using IF, AND and OR
- Look up and combine data with VLOOKUP, XLOOKUP and INDEX/MATCH
- Highlight insights with conditional formatting
- Summarise large datasets with PivotTables and PivotCharts
- Protect data quality with validation and named ranges
Course outline
- 1IF, AND, OR & nested functions
- 2VLOOKUP, XLOOKUP & INDEX/MATCH
- 3Conditional formatting
- 4PivotTables & PivotCharts
- 5Named ranges & data validation
Delivery
Live online
Interactive virtual classroom from anywhere.
In person
At our venue, or at your office for corporate groups.
Frequently asked questions
Related courses
More Microsoft & data training delivered in Nairobi and live online across Kenya.
- Beginner
Microsoft Excel — Basic
Build a confident foundation: navigate workbooks, format data and write your first formulas.
1 day (7 hours)KES 10,000 - Advanced
Excel Advanced — Power User
Power user techniques: dynamic arrays, LAMBDA, Solver, VBA automation and decision-ready dashboards.
2 days (16 hours)KES 22,500 Power BI
Turn raw data into interactive reports and dashboards stakeholders actually use.
2 days (14 hours)KES 32,500