Commercial Digital Literacy
General
Curriculum Needs_review
Microsoft Excel Intermediate
Build practical Excel skills for managing lists, using common formulas, summarising information, and presenting clear business reports....
(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
["Create well-structured workbooks with reliable formulas, clean datasets, validation, charts, and summary reports."]
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 3,500.00 | Option B: Assisted Learning Ksh 7,700.00 |
|---|---|---|
| All 8 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 3,500.00 | Enroll Assisted • Ksh 7,700.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
8 sections • 744 lessons • 19h total length
Expand all sections
-
Plan a workbook for a real task36min
-
Work with multiple worksheets36min
-
Use structured tables36min
-
Sort and filter records36min
-
Freeze panes and print setup36min
-
Absolute Referencing and IF Conditional Statements30min
-
Relative and absolute references36min
-
Use SUM, AVERAGE, MIN, and MAX36min
-
COUNT, COUNTA, and COUNTBLANK36min
-
IF for simple decisions36min
-
Combine formulas safely36min
-
Dynamic Lookups with VLOOKUP and Modern XLOOKUP30min
-
AND and OR logic36min
-
SUMIF and SUMIFS36min
-
COUNTIF and COUNTIFS36min
-
AVERAGEIF and AVERAGEIFS36min
-
IFERROR and formula checks36min
-
Identify common data-quality problems36min
-
Remove duplicates carefully36min
-
Use data validation lists36min
-
Validate numbers, dates, and input ranges36min
-
Find and replace; text cleanup36min
-
Choose the right chart36min
-
Create and format charts36min
-
Use combo charts carefully36min
-
Conditional formatting36min
-
Sparklines and visual indicators36min
-
Build a summary sheet36min
-
Use named ranges and formula auditing36min
-
Comments, notes, and documentation36min
-
Protect worksheets and workbooks36min
-
Intermediate Excel practical project36min
Description
Build practical Excel skills for managing lists, using common formulas, summarising information, and presenting clear business reports.
Recommended Learning Pathway
Prerequisites / Prior Knowledge:
Microsoft Excel Essentials or equivalent
Recommended Before Taking This Course:
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!