Overview:
For months, we’ve been building something special—an Excel Mastery Workshop designed for everyone. Whether you're a student, business owner, or working professional, Excel is one skill that always comes in handy.
With AI and automation changing the game, one thing remains true: you still need to know your numbers. Even AI relies on clean, structured data—and that’s where Excel comes in.
This 3-month hands-on workshop will take you from zero to Excel pro, covering everything from basic formulas to advanced dashboards and automation.
Objective
This workshop is designed to equip anyone—regardless of background—with practical Excel skills that are essential in today’s data-driven world.
With AI and automation reshaping industries, understanding Excel is more important than ever. From small business owners managing finances to corporate professionals handling data, Excel remains a must-have skill.
By the end of this 3-month hands-on workshop, you'll be able to analyze data, build dashboards, automate tasks, and work smarter—not harder.
Course Outline
Day | Date | Objective | Delivery |
|
|
|
|
Basic Excel |
Day 1 Monday | 1/09/2025 | Onboarding – Course outline Introduction to Excel Interface Navigating the Excel ribbon, tabs, and menus. Understanding worksheets, rows, columns, and cells. Saving, opening, and creating workbooks.
| Online (Live session) |
Day 2 Wednesday | 03/09/2025 | Data entry and Basic Formatting Overview of types of data Entering, editing, and deleting data. Formatting cells Adjusting row heights and column widths.
| Online (Live session) |
Day 3 Monday | 08/09/2025 | Basic Formulas and Functions
| Online (Live session) |
Day 4 Wednesday | 10/09/2025 | Working with Rows, Columns, and Sheets Inserting, deleting, and moving rows/columns. Renaming, adding, and deleting sheets. Using freeze panes and split view.
| Online (Live session) |
Day 5 Monday | 15/0/2025 | Basic Sorting and Filtering Sorting data (ascending/descending). Applying filters to view specific data. Clearing sorting and filters.
| Online (Live session) |
Day 6 Wednesday | 17/09/2025 | Introduction to Charts Creating basic charts: Bar, Line, and Pie charts. Customizing chart elements (titles, axes, legends). Printing and exporting charts.
| Online (Live session) |
Day 7 Monday | 22/09/2025 | Basic Data Validation | Online (Live session) |
Day 8 Wednesday | 24/09/2025 | Printing and Sharing Workbooks Setting print areas and adjusting page layout. Using print preview and scaling options. Sharing workbooks via email or cloud storage.
| Online (Live session) |
Intermediate excel |
Day 9 Monday | 01/10/2025 | Advanced Formatting Conditional formatting basics. Using cell styles and themes. Custom number formatting.
| Online (Live session) |
Day 10 Wednesday | 06/10/2025 | Intermediate Formulas and Functions Logical functions: Text functions Lookup functions
| Online (Live session) |
Day 11 Monday | 08/10/2025 | Working with Tables Creating and formatting Excel tables. Using structured references in formulas. Sorting and filtering data in tables.
| Online (Live session) |
Day 12 Wednesday | 13/10/2025 | Data Visualization with Charts
| Online (Live session) |
Day 13 Monday | 15/10/2025 | Pivot Tables Basics Creating and customizing pivot tables. Adding calculated fields and values. Grouping data within pivot tables.
| Online (Live session) |
Day 14 Wednesday | 20/10/2025 | Data Validation and Protection Advanced data validation rules. Protecting sheets and locking cells. Understanding workbook security options.
| Online (Live session) |
Day 15 Monday | 22/10/2025 | Using Templates and Macros Creating and saving templates. Recording and running simple macros. Assigning macros to buttons.
| Online (Live session) |
Day 16 Wednesday | 27/10/2025 | Introduction to Collaboration Sharing workbooks for collaboration. Using comments and notes. Tracking changes in shared workbooks.
| Online (Live session) |
Advanced Excel |
Day 17 Monday | 03/11/2025 | Advanced Functions and Nested Formulas
| Online (Live session) |
Day 18 Wednesday | 05/11/2025 | Power Query Basics Importing data from external sources. Cleaning and transforming data in Power Query. Merging and appending queries.
| Online (Live session) |
Day 19 Monday | 10/11/2025 | Advanced Pivot Tables and Pivot Charts | Online (Live session) |
Day 20 Wednesday | 12/11/2025 | Data Analysis Tools Using the Analysis ToolPak. Running what-if scenarios and sensitivity analysis. Data tables, goal seek, and solver.
| Online (Live session) |
Day 21 Monday | 17/11/2025 | Advanced Charting Techniques Dynamic charts with named ranges. Waterfall and thermometer charts. Creating custom chart types.
| Online (Live session) |
Day 22 Wednesday | 19/11/2025 | Macros and VBA Introduction Editing macros in the VBA editor. Writing simple VBA scripts. Automating tasks with VBA.
| Online (Live session) |
Day 23 Monday | 24/11/2025 | Power BI and Power Pivot Connecting Excel to Power BI. Using Power Pivot for data modeling. Creating relationships between tables.
| Online (Live session) |
Day 24 Wednesday | 26/11/2025 | Automation and Dashboard Creation Building dynamic dashboards. Using form controls and slicers. Automating dashboard updates with VBA.
| Online (Live session) |
Capstone Project: Sales Performance and Forecasting Dashboard |
|
|
|
|
Meet Our Trainers
Ezra Muinde
Ezra Muinde is a passionate data scientist with extensive experience in data analysis, business analytics, and decision science. With over seven years of professional experience — including four years as a data professional — Ezra combines technical expertise with a deep understanding of data storytelling and insights generation.
In addition to his data science background, Ezra is an experienced Excel trainer, skilled in guiding learners across basic, intermediate, and advanced Excel concepts. His teaching approach emphasizes practical application, empowering individuals to leverage Excel for data analysis, reporting, and informed decision-making.
Ezra's dedication to knowledge sharing has led him to mentor aspiring data professionals, helping them build impactful projects and grow their skills. Whether you're starting with Excel fundamentals or exploring advanced data techniques, Ezra's engaging style and real-world insights make learning both accessible and impactful.
Mulei Mutava
Mulei Mutava is an applied economist with expertise in trade, capital markets, and regional integration. He holds a research fellowship at the New South Institute. His academic background includes undergraduate studies at Kenyatta University in Kenya and a master's degree from the University of Cape Town in South Africa. Mulei demonstrates a strong passion for data, having engaged extensively in data-intensive projects at the Capital Markets Authority of Kenya and COMESA. Recently, he has published research on migration trends in Africa with the New South Institute. His research interests encompass the role of finance in economic integration, and he is also committed to mentoring emerging data analysts, bridging the gap between academia and practical applications of data science.
