Commercial Digital Literacy
General
Curriculum Needs_review
Microsoft Excel Advanced
Develop advanced spreadsheet analysis skills using lookup and logic functions, PivotTables, data modelling, What-If Analysis, and automation concepts....
(0 ratings)
Category: LMS Training
Save up to 40% with a Bundle Deal!
This course is included in Complete Microsoft Excel Learning Path (Beginner to Advanced) at a bundled discount.
What you'll learn
["Build robust analysis workbooks, interactive summaries, dashboards, and repeatable data-cleaning workflows."]
Learning Tracks & Pricing Options
Designed for self-paced independent study, with optional 1-on-1 instructor support when needed.
| Curriculum & Support Feature | Option A: Self-Study Ksh 5,500.00 | Option B: Assisted Learning Ksh 12,100.00 |
|---|---|---|
| All 10 Structured Modules | ||
| Downloadable PDF Manuals & Starter Code | ||
| Hands-on Practical Exercises & Capstone Labs | ||
| Verified Certificate of Completion | ||
| Dedicated 1-on-1 Instructor Mentorship | Add on demand | Included |
| Live Debugging & Screen-Share Support | Add on demand | Included |
| Milestone Portfolio Code Reviews | Add on demand | Included |
| Enroll Self-Study • Ksh 5,500.00 | Enroll Assisted • Ksh 12,100.00 |
Self-Study Flexibility: If you choose Self-Study, you can request instructor assistance for any specific module whenever you need help without altering your self-study access.
Course Content
10 sections • 972 lessons • 29h total length
Expand all sections
-
Build and test complex formulas42min
-
Nested IF and IFS42min
-
XLOOKUP for flexible lookups42min
-
INDEX and MATCH42min
-
Dynamic array functions42min
-
Constructing Enterprise Pivot Tables and Summaries30min
-
Text extraction and combination42min
-
Date calculations and workdays42min
-
Rounding and precision42min
-
Rank, percentile, and distribution42min
-
Formula troubleshooting42min
-
Designing Interactive Executive Dashboards in Excel30min
-
Import data from files42min
-
Transform and clean with Power Query42min
-
Split, merge, and reshape columns42min
-
Append and merge queries42min
-
Refresh and validate a data pipeline42min
-
Prepare source data for analysis42min
-
Create and configure PivotTables42min
-
Group dates and numeric values42min
-
Calculated fields, slicers, and timelines42min
-
PivotCharts and refresh practices42min
-
Goal Seek42min
-
Scenario Manager42min
-
One- and two-variable data tables42min
-
Solver concepts and constraints42min
-
Forecasting and trend analysis42min
-
Define KPIs and dashboard questions42min
-
Build KPI cards and summaries42min
-
Interactive dashboard controls42min
-
Design for clarity and accessibility42min
-
Dashboard quality assurance42min
-
Record and inspect macros42min
-
VBA fundamentals and safe use42min
-
Automate repetitive reporting42min
-
Workbook performance and maintainability42min
-
Security, compatibility, and handover42min
-
Define requirements and data model42min
-
Clean and combine source data42min
-
Build analysis formulas and PivotTables42min
-
Create a decision-ready dashboard42min
-
Validate, document, and present findings42min
Description
Develop advanced spreadsheet analysis skills using lookup and logic functions, PivotTables, data modelling, What-If Analysis, and automation concepts.
Recommended Learning Pathway
Prerequisites / Prior Knowledge:
Microsoft Excel Intermediate or equivalent
Recommended Next Step After Completion:
Student Reviews & Feedback
Verified ratings from students enrolled in this course.
No reviews yet for this course. Be the first enrolled student to share feedback!