Beatsy Solutions Beatsy Solutions
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.0
(0 ratings)
Category: LMS Training
Created by James Mwangi Last updated 10/2026 English / Swahili
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.
View Bundle Deals →

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.

2 Flexible Pathways
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 task
    36min
  • Work with multiple worksheets
    36min
  • Use structured tables
    36min
  • Sort and filter records
    36min
  • Freeze panes and print setup
    36min

  • Absolute Referencing and IF Conditional Statements
    30min

  • Relative and absolute references
    36min
  • Use SUM, AVERAGE, MIN, and MAX
    36min
  • COUNT, COUNTA, and COUNTBLANK
    36min
  • IF for simple decisions
    36min
  • Combine formulas safely
    36min

  • Dynamic Lookups with VLOOKUP and Modern XLOOKUP
    30min

  • AND and OR logic
    36min
  • SUMIF and SUMIFS
    36min
  • COUNTIF and COUNTIFS
    36min
  • AVERAGEIF and AVERAGEIFS
    36min
  • IFERROR and formula checks
    36min

  • Identify common data-quality problems
    36min
  • Remove duplicates carefully
    36min
  • Use data validation lists
    36min
  • Validate numbers, dates, and input ranges
    36min
  • Find and replace; text cleanup
    36min

  • Choose the right chart
    36min
  • Create and format charts
    36min
  • Use combo charts carefully
    36min
  • Conditional formatting
    36min
  • Sparklines and visual indicators
    36min

  • Build a summary sheet
    36min
  • Use named ranges and formula auditing
    36min
  • Comments, notes, and documentation
    36min
  • Protect worksheets and workbooks
    36min
  • Intermediate Excel practical project
    36min

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!

Chat with us on WhatsApp