Congratulations!
Data Analysis in Excel
Nick Edwards
Analyst at Mynd
Chapter 1: Exploring data with PivotTables
- You performed exploratory data analysis with PivotTables
- Created Calculated Columns
- Used grouping features to organize and segment data
- Added data and timeline slicers to filter data
Chapter 2: Intermediate logical functions
- Used logical functions like
SWITCH()
, IF()
, IFS()
and CONCAT()
- Created nested statements and customer segments
- Used logical aggregate functions like
SUMIF()
and SUMIFS()
- Created sales summaries for various customer groups
- Made comparisons and found insights into customer groups
Chapter 3: What if analysis
- Learned about the importance of asking what if
- Created scenarios for projected sales
- Used the Goal Seek, Scenario Manager and Data Table tools
Chapter 4: Forecasting
- Used 5 different forecasting techniques:
- Simple moving average
- Weighted moving average
- Trendlines
FORECAST.ETS()
and FORECAST.ETS.CONFINT()
- Learned about the importance of confidence intervals and bias
Best of luck!
Data Analysis in Excel
Preparing Video For Download...