Data Modeling in Excel Course Page – Excel TV Members
Share The LOVE

# Data Modeling in Excel Course Page

Module 1 Desicion Modelling with Excel
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
Module 2 Thinking Like Excel
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
Module 3 Advanced Excel Formula Mastery
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
Module 4 Anatomy Of An Excel Model
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
Module 5 Upgrading to the Modern Excel Table
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
Module 6 Next Level Excel + Database Solutions
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