Data Analytics with Excel & AI
Turn M-Pesa statements and shop records into clear business decisions — Excel, PivotTables and AI-assisted analysis.
6 hours12 lessonsBeginnerPDF certificate
What you'll be able to do
- Clean and structure messy real-world data
- Master formulas, lookups and PivotTables
- Build dashboards with charts and slicers
- Use AI to interpret data and draft insights
Curriculum
4 modules · 12 lessons · 3h 42m total
Module 1Excel Foundations
3 lessons
Excel Foundations
- Cells, sheets and data entry discipline10 min
- Essential formulas: SUM, IF, COUNTIF, VLOOKUP/XLOOKUP18 min
- Cleaning messy data: trimming, splitting, deduping14 min
Module 2Real Business Data
3 lessons
Real Business Data
- Importing and structuring M-Pesa statements15 min
- Tracking stock and sales in one workbook14 min
- PivotTables: summarizing thousands of rows fast16 min
Module 3Dashboards & Visuals
3 lessons
Dashboards & Visuals
- Charts that actually communicate14 min
- Slicers and interactive dashboard layout13 min
- Weekly and monthly reporting templates12 min
Module 4AI-Assisted Analysis
3 lessons
AI-Assisted Analysis
- Asking AI to explain formulas and errors11 min
- Turning analysis into a written business memo13 min
- Selling data skills to SMEs and NGOs12 min
About this course
Data is everywhere in Kenyan business — M-Pesa logs, stock books, sales sheets. This course teaches you to clean, analyze and visualize that data in Excel, then use AI to interpret results and write reports that managers and clients respect.