Data Analysis with Excel
Turn raw data into insights — advanced formulas, PivotTables, charts and dashboards that impress employers.
- Registration FeeOne-time, non-refundable
- UGX 180,000
- Training Fee3 months of training
- UGX 400,000
Total Investment
UGX 580,000
Not ready for the full programme? Unlock single lessons below from UGX 5,000.
Physical or online
Attend at our Kampala centre or learn online — your choice.
Certificate included
Issued by the school when you complete the course.
Real support
Stuck? Message our trainers on WhatsApp.
What you'll learn
- Excel for analysis — the workflow
- Cleaning & formatting messy data
- Essential functions: SUMIF, COUNTIF, IF
- VLOOKUP, XLOOKUP & INDEX/MATCH
- Sorting, filtering & tables
- PivotTables from scratch
- Charts that tell a story
- Conditional formatting & data bars
Lessons unlock from UGX 5,000 to UGX 15,000 via Mobile Money — pay for just the lesson you need, or the whole course. Tick lessons as you finish, and use the quiz to test yourself before your assessment.
Video lessons
- Coming soon
Excel for analysis — the workflow
30 min
- Coming soon
Cleaning & formatting messy data
45 min
- Coming soon
Essential functions: SUMIF, COUNTIF, IF
50 min
- Coming soon
VLOOKUP, XLOOKUP & INDEX/MATCH
50 min
- Coming soon
Sorting, filtering & tables
35 min
- Coming soon
PivotTables from scratch
50 min
- Coming soon
Charts that tell a story
45 min
- Coming soon
Conditional formatting & data bars
35 min
- Coming soon
Building an interactive dashboard
60 min
- Coming soon
Intro to Power Query
45 min
- Coming soon
Presenting your findings
30 min
📚 Course notes (5 units)
Read the full written notes online — unlocked with your course code.
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…