Commercial Digital Literacy
General
Curriculum Needs_review
Microsoft Excel Essentials
Learn spreadsheet skills for work, study and small-business tasks. Create workbooks, enter and format data, use cell references and essential formulas, organize tables, sort and filter records, create...
(0 ratings)
Category: LMS Training
Save up to 38% with a Bundle Deal!
This course is included in Office Essentials Professional Bundle at a bundled discount.
What you'll learn
["Create and organize workbooks","enter and format reliable data","write formulas using cell references","use essential functions","sort, filter and validate data","create clear charts","troubleshoot common errors","prepare printable spreadsheet 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,000.00 | Option B: Assisted Learning Ksh 6,600.00 |
|---|---|---|
| All 9 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,000.00 | Enroll Assisted • Ksh 6,600.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
9 sections • 858 lessons • 17h total length
Expand all sections
-
Excel Interface, Workbooks and Worksheets27min
-
Cells, Rows, Columns and Ranges27min
-
Entering, Editing and Filling Data27min
-
Managing Worksheets and Workbooks27min
-
Saving, File Formats and Version Safety27min
-
Getting Started with the Excel Grid30min
-
Text, Numbers, Dates and Data Types27min
-
Column Widths, Row Heights and Alignment27min
-
Number Formats: Currency, Percentages and Dates27min
-
Borders, Fills and Conditional Emphasis27min
-
Format as Table and Consistent Data Layout27min
-
Automated Calculations with Formulas and Functions30min
-
Formula Basics and Arithmetic Operators27min
-
Relative, Absolute and Mixed References27min
-
SUM, AVERAGE and Basic Aggregation27min
-
COUNT, COUNTA, MIN and MAX27min
-
Order of Operations and Formula Auditing27min
-
Sorting Records Correctly27min
-
Filtering and Finding Records27min
-
Remove Duplicates and Clean Inconsistent Entries27min
-
Data Validation and Drop-Down Lists27min
-
Freeze Panes, Find and Replace27min
-
Choosing a Suitable Chart Type27min
-
Creating and Editing Charts27min
-
Labels, Legends and Readable Formatting27min
-
Conditional Formatting for Highlights27min
-
Summarizing Findings for an Audience27min
-
Page Layout, Print Areas and Scaling27min
-
Headers, Footers and Repeated Print Titles27min
-
Exporting and Sharing Spreadsheet Reports27min
-
Common Errors and Formula Troubleshooting27min
-
Protecting Data and Maintaining Backups27min
-
Project Planning and Data Structure27min
-
Building the Data Table27min
-
Calculations and Summary Metrics27min
-
Filtering, Charting and Quality Checks27min
-
Final Workbook and Report Submission27min
Description
Learn spreadsheet skills for work, study and small-business tasks. Create workbooks, enter and format data, use cell references and essential formulas, organize tables, sort and filter records, create charts, check accuracy and prepare printable reports using practical KES-based examples.
Recommended Learning Pathway
Prerequisites / Prior Knowledge:
Basic computer skills; no prior spreadsheet experience required.
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!