Advanced Excel for Business Analytics2 Sections14 Lessons2 Days
Curriculum
- 2 Sections
- 14 Lessons
- 2 Days
Expand all sectionsCollapse all sections
- Day 1: Advanced formulas and dynamic analysis7 Items
- 1.1Advanced formulas and dynamic analysis.
- 1.2Use lookup, logical and dynamic-array functions where supported
- 1.3Data cleaning and transformation.
- 1.4Normalize data and create repeatable preparation steps
- 1.5Pivot analysis and modeling.
- 1.6Build pivot summaries and define comparable measures
- 1.7Practical workshop: Complete linked exercises: solve a multi-condition analysis task; clean a inconsistent transaction extract.
- Day 2: Scenario and sensitivity analysis and Dashboard desig7 Items
- 2.1Scenario and sensitivity analysis.
- 2.2Model assumptions and sensitivity without overwriting inputs
- 2.3Dashboard design.
- 2.4Design readable charts, controls and summary views
- 2.5Productivity and automation techniques.
- 2.6Reduce repetitive steps with reusable templates and approved automation
- 2.7Practical workshop: Complete linked exercises: compare business scenarios; create an executive worksheet.

