Next cohorts · Spreadsheet Fundamentals: Part 1 · Jan 11

Business Analysis

Use spreadsheets to answer more complex business questions through multi-step analysis.

Who it’s forIntermediate spreadsheet users

What you’ll learn.

Build speed and competency in spreadsheet analysis: summarize data, clean inconsistent data, apply multi-step analysis, and create presentation-ready outputs. Four live, 90-minute classes include 1:1 office hours, video recordings, and practice exercises.

Curriculum

Session 01

Summarizing data

Participants will build speed and competency using core data summary formulas, including for trend-based analysis.

  • No-mouse navigation & keyboard shortcuts
  • Summarize data with sumifs, countifs
  • Remove duplicates, unique
  • Looking up information with xlookup, index match
  • Date-based (monthly) summaries, eomonth formula
Session 02

Working with messy data

Participants will learn strategies for identifying and cleaning inconsistent data to enable accurate analysis.

  • Text manipulation techniques including left, right, mid, len, search, concatenation, text to columns, trim, flatten
  • Build a key and use a lookup to quickly relabel data
  • Dynamic filtering and sorting, creation of dropdowns
  • Pivot tables
Session 03

Advanced multi-step analysis

Participants will apply the techniques learned in earlier classes to more complex business analysis.

  • Customer cohort analysis
  • Efficient comparison of multiple data sets
  • Advanced date-time considerations
Session 04

Scenarios & outputs

Participants will be introduced to multi scenario analysis and will gain comfort creating presentation-ready analysis.

  • Creation of summaries from separate tabs of data
  • Formatting best-practices
  • Intro to scenario analysis (base/upside/downside case)
  • Intro to data tables