Unit 1 |
Why Art Science with Excel |
Unit 2 |
Historical Perspectives Art Science |
Unit 3 |
Art and Science of Excel Modelling in 9 Steps |
Unit 4 |
Step 1 Defining the Problem |
Unit 5 |
Step 2 Analyzing the Problem |
Unit 6 |
Step 3 Knowing Your Stakeholder |
Unit 7 |
Step 4 Understanding Your Role |
Unit 8 |
Step 5 Planning Your Model |
Unit 9 |
Step 6 Building Your Model |
Unit 10 |
Step 7 Testing Your Model |
Unit 11 |
Step 8 Delivering Your Model |
Unit 12 |
Step 9 Maintaining Your Model |
Unit 13 |
The 9 Steps Recap |
Unit 1 |
Introduction to Thinking Like Excel |
Unit 2 |
Why Think Like Excel |
Unit 3 |
Cell Referencing Is Everything |
Unit 4 |
Relative Cell Referencing DEMO |
Unit 5 |
Mixed Cell Referencing DEMO |
Unit 6 |
Absolute Cell Referencing DEMO |
Unit 7 |
Multiplication Matrix Example |
Unit 8 |
R1C1 Mode DEMO |
Unit 9 |
Notation Styles |
Unit 10 |
Cell Notation Styles Compared |
Unit 11 |
Excel and Chess |
Unit 1 |
Introduction To Advanced Excel Formula Mastery |
Unit 2 |
Looking Things Up |
Unit 3 |
VLookup DEMO |
Unit 4 |
Match DEMO |
Unit 5 |
VLookup With Match DEMO |
Unit 6 |
VLookup With Error Trapping DEMO |
Unit 7 |
VLookup Approximate Match DEMO |
Unit 8 |
Vlookup To The Left DEMO |
Unit 9 |
Index DEMO |
Unit 10 |
Offset |
Unit 11 |
Offset DEMO |
Unit 12 |
Conditional Calculations |
Unit 13 |
Sumifs DEMO |
Unit 14 |
Averageifs DEMO |
Unit 15 |
Array Formulas DEMO |
Unit 16 |
Countifs DEMO |
Unit 17 |
Countifs For Uniques DEMO |
Unit 1 |
Anatomy of an Excel Model – Introduction |
Unit 2 |
Create Names to Store Global Assumptions – DEMO |
Unit 3 |
Static vs Dynamic Named Ranges – DEMO |
Unit 4 |
Replace a Range Address with a Dynamic Range Name – DEMO |
Unit 5 |
Create Names to Retrieve Intersections – DEMO |
Unit 6 |
Create a Simple Custom Function Without VBA – DEMO |
Unit 7 |
Variables vs Scenarios – Goal Seek DEMO |
Unit 8 |
Variables vs Scenarios – Scenario Manager DEMO |
Unit 9 |
Workshop Introduction – Rolling Forecast Planner |
Unit 10 |
Workshop Rolling Forecast Planner – DEMO |
Unit 11 |
Workshop Retail Order Processing Model LABNTRO |
Unit 1 |
Introduction: Upgrading to the Modern Excel Table |
Unit 2 |
What is a Modern Excel Table? |
Unit 3 |
3 Ways to Create an Excel Table |
Unit 4 |
Excel Tables - Essential Techniques DEMO |
Unit 5 |
Excel Tables – Slicers & Graphs DEMO |
Unit 6 |
Dynamic Charts With Tables – DEMO |
Unit 7 |
Excel Tables Advanced Formulas – DEMO |
Unit 8 |
Excel Tables and Data Models |
Unit 9 |
Intro to Data Models – DEMO |
Unit 10 |
Modern Excel Tables – RECAP |
Unit 1 |
Introduction – Next Level Excel Database Systems |
Unit 2 |
Excel vs Database Debate |
Unit 3 |
Demos Overview |
Unit 4 |
Demo 1 – SQL |
Unit 5 |
Demo 1 – Access Database Backend |
Unit 6 |
Demo 1 – The Excel Front End |
Unit 7 |
Demo 1 – Specify The Connection on the Excel Front End |
Unit 8 |
Demo 2 – Introduction |
Unit 9 |
Demo 2 – Process Automation |