Beatsy Solutions Beatsy Solutions
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.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

["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.

2 Flexible Pathways
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 formulas
    42min
  • Nested IF and IFS
    42min
  • XLOOKUP for flexible lookups
    42min
  • INDEX and MATCH
    42min
  • Dynamic array functions
    42min

  • Constructing Enterprise Pivot Tables and Summaries
    30min

  • Text extraction and combination
    42min
  • Date calculations and workdays
    42min
  • Rounding and precision
    42min
  • Rank, percentile, and distribution
    42min
  • Formula troubleshooting
    42min

  • Designing Interactive Executive Dashboards in Excel
    30min

  • Import data from files
    42min
  • Transform and clean with Power Query
    42min
  • Split, merge, and reshape columns
    42min
  • Append and merge queries
    42min
  • Refresh and validate a data pipeline
    42min

  • Prepare source data for analysis
    42min
  • Create and configure PivotTables
    42min
  • Group dates and numeric values
    42min
  • Calculated fields, slicers, and timelines
    42min
  • PivotCharts and refresh practices
    42min

  • Goal Seek
    42min
  • Scenario Manager
    42min
  • One- and two-variable data tables
    42min
  • Solver concepts and constraints
    42min
  • Forecasting and trend analysis
    42min

  • Define KPIs and dashboard questions
    42min
  • Build KPI cards and summaries
    42min
  • Interactive dashboard controls
    42min
  • Design for clarity and accessibility
    42min
  • Dashboard quality assurance
    42min

  • Record and inspect macros
    42min
  • VBA fundamentals and safe use
    42min
  • Automate repetitive reporting
    42min
  • Workbook performance and maintainability
    42min
  • Security, compatibility, and handover
    42min

  • Define requirements and data model
    42min
  • Clean and combine source data
    42min
  • Build analysis formulas and PivotTables
    42min
  • Create a decision-ready dashboard
    42min
  • Validate, document, and present findings
    42min

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!

Chat with us on WhatsApp