Beatsy Solutions Beatsy Solutions
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.0
(0 ratings)
Category: LMS Training
Created by James Mwangi Last updated 10/2026 English / Swahili
Save up to 38% with a Bundle Deal!
This course is included in Office Essentials Professional Bundle at a bundled discount.
View Bundle Deals →

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.

2 Flexible Pathways
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 Worksheets
    27min
  • Cells, Rows, Columns and Ranges
    27min
  • Entering, Editing and Filling Data
    27min
  • Managing Worksheets and Workbooks
    27min
  • Saving, File Formats and Version Safety
    27min

  • Getting Started with the Excel Grid
    30min

  • Text, Numbers, Dates and Data Types
    27min
  • Column Widths, Row Heights and Alignment
    27min
  • Number Formats: Currency, Percentages and Dates
    27min
  • Borders, Fills and Conditional Emphasis
    27min
  • Format as Table and Consistent Data Layout
    27min

  • Automated Calculations with Formulas and Functions
    30min

  • Formula Basics and Arithmetic Operators
    27min
  • Relative, Absolute and Mixed References
    27min
  • SUM, AVERAGE and Basic Aggregation
    27min
  • COUNT, COUNTA, MIN and MAX
    27min
  • Order of Operations and Formula Auditing
    27min

  • Sorting Records Correctly
    27min
  • Filtering and Finding Records
    27min
  • Remove Duplicates and Clean Inconsistent Entries
    27min
  • Data Validation and Drop-Down Lists
    27min
  • Freeze Panes, Find and Replace
    27min

  • Choosing a Suitable Chart Type
    27min
  • Creating and Editing Charts
    27min
  • Labels, Legends and Readable Formatting
    27min
  • Conditional Formatting for Highlights
    27min
  • Summarizing Findings for an Audience
    27min

  • Page Layout, Print Areas and Scaling
    27min
  • Headers, Footers and Repeated Print Titles
    27min
  • Exporting and Sharing Spreadsheet Reports
    27min
  • Common Errors and Formula Troubleshooting
    27min
  • Protecting Data and Maintaining Backups
    27min

  • Project Planning and Data Structure
    27min
  • Building the Data Table
    27min
  • Calculations and Summary Metrics
    27min
  • Filtering, Charting and Quality Checks
    27min
  • Final Workbook and Report Submission
    27min

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!

Chat with us on WhatsApp