Data Analytics

📊 Data Analysis using Microsoft Excel

A comprehensive Excel training program covering everything from spreadsheet basics to advanced data analysis, Power Query, PivotTables, and VBA automation.

9 Weeks Virtual Certificate

KES 6000 Program fee can be done in installments

or deposit 40% (KES 2400) to secure your spot

Beginner

2 Weeks

Intermediate

3 Weeks

Advanced

4 Weeks

Quiz

Learning Journey

Your path to mastery

3 structured levels — from foundations to expert mastery.

Level 1

Data Analysis using Microsoft Excel

2 Weeks 10 courses

What You'll Learn

1 Introduction to Excel: Interface, ribbons, workbooks, and worksheets

2 Navigating Excel: Selecting cells, ranges, rows, and columns

3 Data Entry & Formatting: Text, numbers, dates, and basic formatting

4 Cell Formatting: Fonts, colors, borders, and number formatting

5 Basic Excel Formulas: Arithmetic operators and cell references

6 Essential Excel Functions: SUM, AVERAGE, MIN, MAX, COUNT, and COUNTA

7 Using AutoFill & Flash Fill for faster data entry

8 Sorting and Filtering Data in Excel

9 Excel Print Setup: Page layout, headers, footers, and print area

10 Saving & Exporting Excel Files: XLSX, CSV, and PDF formats

KES 2500 / level

Certificate included

Level 2

Data Analysis using Microsoft Excel

3 Weeks 13 courses

What You'll Learn

1 Logical functions — IF, AND, OR, NOT, nested IF

2 Lookup functions — VLOOKUP, HLOOKUP, XLOOKUP, MATCH, INDEX

3 Text functions — CONCAT, LEFT, RIGHT, MID, TRIM, UPPER, LOWER, TEXT

4 Date and time functions — TODAY, NOW, DATEDIF, EOMONTH, NETWORKDAYS

5 Math functions — ROUND, INT, MOD, SUMIF, SUMIFS, COUNTIF, COUNTIFS

6 Named ranges and dynamic references

7 Data validation — dropdowns, input rules, error alerts

8 Conditional formatting — rules, color scales, data bars, icon sets

9 Excel Tables — structured references, auto-expand, slicers

10 Charts — column, bar, line, pie, combo; formatting and titles

11 PivotTables — building, grouping, filtering, and value summaries

12 PivotCharts and slicers

13 Protecting sheets and workbooks

KES 2500 / level

Certificate included

Level 3

Data Analysis using Microsoft Excel

4 Weeks 15 courses Sequential

What You'll Learn

1 Array formulas — legacy CSE arrays and dynamic arrays with SPILL

2 Dynamic array functions — FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY

3 Advanced lookup — INDIRECT, OFFSET, CHOOSE, and dynamic range building

4 Error handling — IFERROR, IFNA, ISERROR

5 Financial functions — PMT, PV, FV, NPV, IRR, RATE

6 Statistical functions — STDEV, VAR, CORREL, FORECAST, PERCENTILE, RANK

7 Power Query — importing, transforming, merging, and appending data

8 Power Pivot and Data Model — table relationships and DAX basics

9 DAX measures — calculated columns, CALCULATE, SUM, RELATED

10 Advanced PivotTables — calculated fields and show values as options

11 Macros and VBA — recording macros and the VBA editor

12 VBA intermediate — loops, conditionals, and user-defined functions

13 Form controls and ActiveX — buttons, combo boxes, interactive dashboards

14 Dashboard design — combining charts, slicers, and KPIs

15 Excel and external data — databases, web queries, and APIs via Power Query

KES 2500 / level

Certificate included

Complete Path

Master the Full Journey

All 3 levels — structured from foundations to expert mastery. Earn a verifiable certificate at each milestone.

🟢 Data Analysis using Microsoft Excel KES 2500 per level

🟡 Data Analysis using Microsoft Excel KES 2500 per level

🔴 Data Analysis using Microsoft Excel KES 2500 per level

Total Investment

KES 7500

KES 6000

vs buying levels individually Save 20%

🟢

🟡

🔴

3 certificates included

Program Overview

This program takes learners from zero Excel knowledge to professional-level proficiency. Starting with the Excel interface and basic data entry, participants progressively build skills in formulas, functions, data visualization, and reporting. The intermediate module covers lookup functions, conditional formatting, PivotTables, and structured tables. The advanced module dives into dynamic arrays, Power Query for ETL workflows, Power Pivot with DAX, and VBA/macro automation — culminating in full dashboard design and performance optimization for large datasets.

Who Is This For?

Business analysts and data professionals who work with Excel daily Finance, accounting, and operations staff needing reporting skills Students and graduates building employable spreadsheet skills Managers who need to build dashboards and summarize team data Anyone progressing from basic Excel use to advanced automation

Prerequisites

Basic computer literacy — ability to navigate Windows or macOS Familiarity with keyboard and mouse operations Microsoft Excel installed (2016, 2019, 2021, or Microsoft 365) Basic understanding of numbers and arithmetic No prior Excel experience required for the Beginner module Completion of Beginner module required before Intermediate Completion of Intermediate module required before Advanced Access to Laptop

Delivery Options

Virtual

Need a Custom Solution?

Group pricing, custom dates, or a tailored version for your team.

Talk to Us

UPON COMPLETION