Art & Science of Excel Modeling
Module 01A - Step By Step Approach to Decision Modeling with Excel (Why "Art Science" when it comes to Excel?)
Module 01B - Step By Step Approach to Decision Modeling with Excel (Art Science of Excel Modeling in 9 Steps)
Module 02A - Thinking Like Excel (Cell Referencing Essentials)
Module 02B - Thinking Like Excel (Notation Styles)
Module 03A - Advanced Formula Mastery (VLOOKUP)
Module 03B - Advanced Formula Mastery (INDEX and MATCH)
Module 04 - The Anatomy of an Excel Model
Module 05A - Upgrading to the Modern Excel Table (Essential Techniques)
Module 05B - Upgrading to the Modern Excel Table (Excel Table and Data Models)
Module 05C - Upgrading to the Modern Excel Table (Review)
Module 06A - Next Level Excel and Database Systems (Overview)
Module 06B - Next Level Excel and Database Systems (Talking to Databases)
Module 06C - Next Level Excel and Database Systems (Automating with Databases)
Module 01A - Step By Step Approach to Decision Modeling with Excel (Why "Art Science" when it comes to Excel?)
Module 01B - Step By Step Approach to Decision Modeling with Excel (Art Science of Excel Modeling in 9 Steps)
Module 02A - Thinking Like Excel (Cell Referencing Essentials)
Module 02B - Thinking Like Excel (Notation Styles)
Module 03A - Advanced Formula Mastery (VLOOKUP)
Module 03B - Advanced Formula Mastery (INDEX and MATCH)
Module 04 - The Anatomy of an Excel Model
Module 05A - Upgrading to the Modern Excel Table (Essential Techniques)
Module 05B - Upgrading to the Modern Excel Table (Excel Table and Data Models)
Module 05C - Upgrading to the Modern Excel Table (Review)
Module 06A - Next Level Excel and Database Systems (Overview)
Module 06B - Next Level Excel and Database Systems (Talking to Databases)
Module 06C - Next Level Excel and Database Systems (Automating with Databases)