Excel & Office Productivity
excel Essentials
A practical, beginner-friendly introduction to spreadsheet fundamentals, covering data entry, formatting, core formulas,...
4 Weeks Beginner Certificate
Self-paced
Beginner
Excel Dashboards & Data Analysis
A comprehensive course on designing interactive business dashboards, performing advanced data analysis, and building automated visual reporting systems directly within Microsoft Excel.
6 Weeks Verified certificate
What you'll learn
- Executive Dashboard Architecture: Design intuitive, visually striking dashboard layouts using grid alignment, user-centered design, card KPI metrics, and effective color palettes.
- Data Preparation with Power Query: Automate the extraction, cleaning, and transformation of raw multi-source data directly into your dashboard data model.
- Interactive Controls & Slicers: Connect dynamic Slicers, Timelines, Form Controls (checkboxes, dropdowns, radio buttons), and Form Control macros to give users real-time visual control over metrics.
- Advanced PivotCharts & Dynamic Visuals: Build custom dynamic charts, heatmaps, conditional KPI badges, and linked visual components that adjust based on user interaction.
- Automated Reporting Workflows: Construct self-updating reporting files that seamlessly update all summary tables, metrics, and visuals whenever new data is added.
Course content
The full curriculum is being finalised. Contact us for the syllabus.
About this course
Transform dense, complex datasets into sleek, interactive executive dashboards using Microsoft Excel. This course covers the end-to-end dashboard design lifecycle: from raw data structuring and Power Query data modeling to visual UX layout principles and interactive controls. You will learn how to connect dynamic slicers, timeline controls, form control buttons, and PivotCharts to construct real-time reporting interfaces. By the end of this course, you will be able to build dynamic, automated dashboards that allow stakeholders to inspect metrics, identify trends, and make data-driven decisions effortlessly.
Tools you'll use
Microsoft Excel (365 / 2021+)Power QueryForm ControlsPivotTables & PivotChartsOffice 365
Learn anywhere
Phone, tablet or laptop. Pick up exactly where you left off.
Hands-on practice
Quizzes, coding exercises and projects marked by instructors.
Verified certificate
Each certificate has a code employers can verify online.
You might also like
Excel & Office Productivity
Excel Intermediate
A practical course designed to elevate spreadsheet skills by mastering advanced lookup functions, conditional logic, Piv...
Beginner Certificate
Excel & Office Productivity
Excel Advanced Formulas & Functions
An advanced, formula-driven course mastering modern dynamic arrays, financial and statistical functions, nested computat...
4 Weeks Beginner Certificate
From
KES 3,000