Data Modelling in Excel

Excel Courses - The Excel.TV Academy
Data Modelling in Excel

ONLY FOR MEMBERS

Intermediate

Video/Text

Data Wrangling

71 Lessons

0% Not started

Ready?

Data Modelling in Excel

Download The Files

1 Lesson

ONLY FOR MEMBERS

Download the Files

Decision Modelling with Excel

13 Lessons

ONLY FOR MEMBERS

Why Art and Science with Excel

ONLY FOR MEMBERS

Historical Perspectives: Art-Science

ONLY FOR MEMBERS

Art & Science of Excel Modelling in 9 Steps

ONLY FOR MEMBERS

Step 1: Defining the Problem

ONLY FOR MEMBERS

Step 2: Analyzing the Problem

ONLY FOR MEMBERS

Step 3: Knowing Your Stakeholder

ONLY FOR MEMBERS

Step 4: Understanding Your Role

ONLY FOR MEMBERS

Step 5: Planning Your Model

ONLY FOR MEMBERS

Step 6: Building Your Model

ONLY FOR MEMBERS

Step 7: Testing Your Model

ONLY FOR MEMBERS

Step 8: Delivering Your Model

ONLY FOR MEMBERS

Step 9: Maintaining Your Model

ONLY FOR MEMBERS

The 9 Steps Recap

Thinking Like Excel

11 Lessons

ONLY FOR MEMBERS

Introduction to Thinking Like Excel

ONLY FOR MEMBERS

Why Think Like Excel

ONLY FOR MEMBERS

Cell Referencing is Everything

ONLY FOR MEMBERS

Relative Cell Referencing DEMO

ONLY FOR MEMBERS

Mixed Cell Referencing DEMO

ONLY FOR MEMBERS

Absolute Cell Referencing DEMO

ONLY FOR MEMBERS

Multiplication Matrix Example

ONLY FOR MEMBERS

R1C1 Mode DEMO

ONLY FOR MEMBERS

Notation Styles

ONLY FOR MEMBERS

Cell Notation Styles Compared

ONLY FOR MEMBERS

Excel and Chess

Advanced Excel Formula Mastery

16 Lessons

ONLY FOR MEMBERS

Introduction to Advanced Excel Formula Mastery

ONLY FOR MEMBERS

Looking Things Up

ONLY FOR MEMBERS

VLookup DEMO

ONLY FOR MEMBERS

Match DEMO

ONLY FOR MEMBERS

VLookup with Match DEMO

ONLY FOR MEMBERS

VLookup with Error Trapping DEMO

ONLY FOR MEMBERS

VLookup Approximate Match DEMO

ONLY FOR MEMBERS

VLookup to the Left DEMO

ONLY FOR MEMBERS

Index DEMO

ONLY FOR MEMBERS

Offset

ONLY FOR MEMBERS

Offset DEMO

ONLY FOR MEMBERS

Conditional Calculations

ONLY FOR MEMBERS

SumIfs DEMO

ONLY FOR MEMBERS

Averageifs DEMO

ONLY FOR MEMBERS

Array Formulas DEMO

ONLY FOR MEMBERS

Countifs for Uniques DEMO

Anatomy of an Excel Model

11 Lessons

ONLY FOR MEMBERS

Anatomy of an Excel Model Introduction

ONLY FOR MEMBERS

Create Names to Store Global Assumptions DEMO

ONLY FOR MEMBERS

Named Ranges Static vs Dynamic DEMO

ONLY FOR MEMBERS

Replace a Range Address with a Dynamic Range Name DEMO

ONLY FOR MEMBERS

Create Names to Retrieve Intersections

ONLY FOR MEMBERS

Create a Simple Custom Function Without VBA DEMO

ONLY FOR MEMBERS

Variables vs Scenarios Goal Seek Demo

ONLY FOR MEMBERS

Variables vs Scenarios - Scenario Manager DEMO

ONLY FOR MEMBERS

Workshop Introduction Rolling Forecast Planner

ONLY FOR MEMBERS

Workshop Rolling Forecast Planner DEMO

ONLY FOR MEMBERS

Workshop Retail Order Processing Model LAB INTRO

Upgrading to the Modern Excel Table

10 Lessons

ONLY FOR MEMBERS

Introduction to Upgrading to the Modern Excel Table

ONLY FOR MEMBERS

What is a Modern Excel Table

ONLY FOR MEMBERS

3 Ways to Create an Excel Table

ONLY FOR MEMBERS

Excel Tables Essential Techniques DEMO

ONLY FOR MEMBERS

Excel Tables Slicers and Graphs DEMO

ONLY FOR MEMBERS

Dynamic Charts with Tables DEMO

ONLY FOR MEMBERS

Excel Tables Advanced Formulas

ONLY FOR MEMBERS

Excel Tables and Data Models

ONLY FOR MEMBERS

Intro to Data Models DEMO

ONLY FOR MEMBERS

Modern Excel Tables RECAP

Next Level Excel + Database Solutions

9 Lessons

ONLY FOR MEMBERS

Introduction to Next Level Excel Database Systems

ONLY FOR MEMBERS

Excel vs Database Debate

ONLY FOR MEMBERS

Demos Overview

ONLY FOR MEMBERS

DEMO 1 - SQL

ONLY FOR MEMBERS

DEMO 1 - Access Database Backend

ONLY FOR MEMBERS

DEMO 1 - The Excel Front End

ONLY FOR MEMBERS

DEMO 1 - Specify the Connection on the Excel Front End

ONLY FOR MEMBERS

DEMO 2 - Introduction

ONLY FOR MEMBERS

DEMO 2 - Process Automation

Follow

About the teacher

Szilvia Juhasz

No Author Description