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.
3 modules
1 quiz
9 Weeks
★ 5.0 (1)
1 learner enrolled
Virtual
Certificate
🟢
Beginner
🟡
Intermediate
🔴
Advanced
3-level learning path
9 Weeks
After completing this program, you'll be able to
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
About This Program
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.
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
Meet Your Trainer
Brian Obuya
Lead TrainerSenior Technical Lecturer
123 cohorts trained
5,002 students
Experience
Trained learners in Excel, Power BI, ICDL, animation, and multimedia content creation across college, corporate, and youth programs. My sessions combine MIS experience, e-learning development, and practical workplace examples to help learners build confidence in data analysis, reporting, dashboards, and productivity tools.
Education
Degree in Film Production and Animation, specialized in Animation. ICDL Certified Trainer with professional experience in digital skills, multimedia production, e-learning development, Excel, and Power BI training.
First 3 topics per level are open for preview. Enroll to unlock all notes & materials.
Log in
🟢
Data Analysis using Microsoft Excel
0 items
* Introduction to Excel: Interface, ribbons, workbooks, and worksheets
* Navigating Excel: Selecting cells, ranges, rows, and columns
* Data Entry & Formatting: Text, numbers, dates, and basic formatting
* Cell Formatting: Fonts, colors, borders, and number formatting
Log in
* Basic Excel Formulas: Arithmetic operators and cell references
Log in
* Essential Excel Functions: SUM, AVERAGE, MIN, MAX, COUNT, and COUNTA
Log in
* Using AutoFill & Flash Fill for faster data entry
Log in
* Sorting and Filtering Data in Excel
Log in
* Excel Print Setup: Page layout, headers, footers, and print area
Log in
* Saving & Exporting Excel Files: XLSX, CSV, and PDF formats
Log in
🟡
Data Analysis using Microsoft Excel
0 items
Logical functions — IF, AND, OR, NOT, nested IF
Lookup functions — VLOOKUP, HLOOKUP, XLOOKUP, MATCH, INDEX
Text functions — CONCAT, LEFT, RIGHT, MID, TRIM, UPPER, LOWER, TEXT
Date and time functions — TODAY, NOW, DATEDIF, EOMONTH, NETWORKDAYS
Log in
Math functions — ROUND, INT, MOD, SUMIF, SUMIFS, COUNTIF, COUNTIFS
Log in
Named ranges and dynamic references
Log in
Data validation — dropdowns, input rules, error alerts
Log in
Conditional formatting — rules, color scales, data bars, icon sets
Log in
Excel Tables — structured references, auto-expand, slicers
Log in
Charts — column, bar, line, pie, combo; formatting and titles
Log in
PivotTables — building, grouping, filtering, and value summaries
Log in
PivotCharts and slicers
Log in
Protecting sheets and workbooks
Log in
🔴
Data Analysis using Microsoft Excel
0 items
Array formulas — legacy CSE arrays and dynamic arrays with SPILL
Dynamic array functions — FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY
Advanced lookup — INDIRECT, OFFSET, CHOOSE, and dynamic range building
Error handling — IFERROR, IFNA, ISERROR
Log in
Financial functions — PMT, PV, FV, NPV, IRR, RATE
Log in
Statistical functions — STDEV, VAR, CORREL, FORECAST, PERCENTILE, RANK
Log in
Power Query — importing, transforming, merging, and appending data
Log in
Power Pivot and Data Model — table relationships and DAX basics
Log in
DAX measures — calculated columns, CALCULATE, SUM, RELATED
Log in
Advanced PivotTables — calculated fields and show values as options
Log in
Macros and VBA — recording macros and the VBA editor
Log in
VBA intermediate — loops, conditionals, and user-defined functions
Log in
Form controls and ActiveX — buttons, combo boxes, interactive dashboards
Log in
Dashboard design — combining charts, slicers, and KPIs
Log in
Excel and external data — databases, web queries, and APIs via Power Query
Log in
Enroll to unlock all topics and materials
Student Reviews
5.0★ · 1
Mike Cheruiyot
May 2026
Frequently Asked Questions
Yes. You can secure your spot with a 40% deposit (KES 2,400) and pay the balance as you progress through the program.
Payments go through our secure Paystack checkout, which supports M-Pesa and card. Your enrollment is confirmed automatically as soon as payment completes — no waiting.
New intake dates are announced regularly — enroll to reserve your place in the next one.
Yes — graduates receive a verifiable completion certificate and a shareable digital badge you can add to LinkedIn and your CV.
You get lifetime access to all program materials, including any updates added after you enroll.
Yes — the first topics in each level are open for free preview. Browse the curriculum above and open any unlocked topic to sample the notes.
Still have questions? Talk to us — we're happy to help.
Community Discussion
Loading discussion…
Join the discussion —
Sign in
and enroll to ask questions and connect with other learners.
UPON COMPLETION
What You'll Earn
Graduates receive a verifiable certificate and shareable digital badge — ready for LinkedIn and beyond.
🎓
Data Analysis using Microsoft Excel
BX--XXXXXX
BidaXP Academy
Verified
Blockchain Verified
Lifetime Access
SHARE YOUR CERTIFICATE
Add to LinkedIn
Post
WhatsApp
🏅
Digital Badge
NFT-backed
📊
Data Analysis using Microsoft Excel
BidaXP Academy
Data Analytics
Portable
Shareable
SHARE YOUR BADGE
LinkedIn
X
WhatsApp
Copy
Verified Online
Anyone can verify
LinkedIn Ready
1-click to your profile
Lifetime Access
Never expires
Multi-platform
Share anywhere
