Back to Catalog

Course Detail

Excel for Data Analysis Bootcamp

Beginner Data Analytics 6 lessons 114 mins

Use Excel confidently for cleaning, analysis, and reporting workflows.

A practical Excel analytics journey for learners who want to move from raw data to decision-ready dashboards.

Excel for Data Analysis Bootcamp banner

Course Outline

1. Excel Core Workflow

Build strong spreadsheet fundamentals for analysis.

  1. Excel Foundations for Beginners (24 min)
  2. Preparing Datasets for Analysis (20 min)

2. Analytical Functions

Use formulas to summarize and investigate data.

  1. Aggregate Functions and Summaries (18 min)
  2. Lookup and Mapping Patterns (16 min)

3. Dashboards and Insights

Convert analysis into business-facing visuals.

  1. Pivot Tables for Executive Summaries (19 min)
  2. Decision-Ready Dashboard Design (17 min)