Course Overview
- Watch this before you start
- DOWNLOAD WORK FILE HERE
- How to join my email list
- Excel Learning Road Map and What's covered
- Get started with Excel
Excel formula hack
- Simple Calculations
- Relative and Absolute Reference
- Autofill
- 3X your productivity using 3 shortcuts + 1 useful tip
- Basic Excel Formulas
- When to use which function and how to learn
Excel Functions Hack
- Basic Formatting-From Basic to Best Sequence
- Group & Freeze Panes - From Basic to Fancy way to use it
- Format as Table Basic and Why Use it
- Filter in table and in range, Pros&Cons
- Conditional Formatting - From Basic to Fancy
- Format Painter- the Right Way
- Comment- Best Practice
- Data Validation - Creative Way for Data Entry
- Check in with you
8 Formulas Analysts must MASTER
- Analyst most favorite: IF formula
- SUMIF(s) This is more important than you think
- COUNTIF(s)
- How to add labels based on conditions: LOOKUP
- Upgrade from LOOKUP: VLOOKUP
- How to make a Dynamic Table in 2 min
- HLOOKUP to the rescue
- Upgrade from VLOOKUP: INDEX&MATCH
- How to stop making mistakes in Excel
Mysterious Pivot Table
- Pivot Table mystery revealed
- Subtotal in Pivot Table
- Calculated Column Part 1
- Calculated Column Part 2
- Slicer and Timeline
- Dashboard Design Principals
- Dashboard using Pivot Table
BONUS: Data Analysis Series
- Sensitivity Analysis
- How to interpret sensitivity analysis
- Sensitivity Analysis Table
- Scenario Analysis
- Goal Seek
- Closing Remarks
