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
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
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
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
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