Data Analysis with Excel
Turn raw data into insights — advanced formulas, PivotTables, charts and dashboards that impress employers.
The first lesson is free. Other lessons unlock from UGX 1,000 to UGX 5,000 via Mobile Money. Tick lessons as you finish to track your progress, then take the quiz for your certificate.
Video lessons
Excel for analysis — the workflowFree
14 min
Cleaning & formatting messy data
22 min
Essential functions: SUMIF, COUNTIF, IF
24 min
VLOOKUP, XLOOKUP & INDEX/MATCH
26 min
Sorting, filtering & tables
18 min
PivotTables from scratch
26 min
Charts that tell a story
22 min
Conditional formatting & data bars
18 min
Building an interactive dashboard
30 min
Intro to Power Query
22 min
Presenting your findings
16 min
Quiz
Score 60% or higher to earn your certificate.
1. A PivotTable is used to…
2. Which looks up a value in a table?
3. IF() lets you…
4. A chart is best for…
5. Before analysis you should first…
6. Conditional formatting is used to…