All courses
Intermediate
Microsoft Excel — Intermediate
Move beyond the basics with conditional logic, lookups, charts and pivot tables.
Duration
2 days (14 hours)
Fee
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.