Excel Essentials for Data Analytics: Data Modeling, Power Tools & Analytical Thinking for Business Professionals
Venue: Sarova Stanley Hotel, Nairobi-Kenya
Date: 1st - 6th June 2026
Cost: Kshs. 86,000 / USD 850
CPD points: 10
Overview
Build a strong foundation in Excel for data analytics with this program covering data modeling, power tools, and analytical thinking. Participants will learn to clean and transform data, build logical models, and use Excel's advanced features (Power Query, Power Pivot) to analyze business data effectively. The curriculum emphasizes practical application, with exercises based on real business scenarios. Through hands‑on learning, attendees will develop the skills to turn raw data into actionable insights. This program is ideal for business professionals, analysts, and managers who want to enhance their Excel analytical capabilities.
Objectives
- Clean and prepare raw data for analysis using Excel functions and Power Query
- Build data models with relationships and calculated columns
- Use PivotTables and PivotCharts for interactive analysis
- Apply logical and lookup functions to solve business problems
- Create dynamic dashboards with slicers and timelines
- Perform what‑if analysis with scenarios and data tables
- Understand foundational statistical concepts (mean, median, standard deviation)
- Develop analytical thinking to frame questions and interpret results
- Automate repetitive tasks with macros (introductory)
Target Audience
- Business analysts and data analysts
- Finance and accounting professionals
- Marketing and sales analysts
- Operations and supply chain staff
- Managers seeking data‑driven decision skills
- Anyone wanting to improve their Excel data analysis skills
Methodology
- Hands‑on Excel workshops with progressively challenging exercises
- Real‑world business case studies
- Power Query and Power Pivot demonstrations
- Group problem‑solving sessions
- Peer feedback on dashboard designs
- Resources for continued learning
- Action planning for applying skills to participants' work
