Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Skillshare Build Excel Models using Advanced Formulas, VBA, Power Query

Video Introducing this tutorial

Introduction to the Course Build Advanced Excel Models
Minimum Requirements for the Course
Prepayments In a Business - An Introduction
Prepaid Expenses (Prepayments) Accounting Definition
Prepaid Expense Example (How Accounting works for Prepayments)
Advantages and Disadvantages of Prepaid Expenses
An Intro to PRO Excel Models and Formulas
Basics of Date Function
Basics of EOMONTH Function
Basics of DATEVALUE function
Basics of IF Function
Basics of IFS Function (Excel 2019 and Office 365 Only)
Basics of VLOOKUP Function
Basics of MATCH Function
Basics of INDIRECT Function
Basics of NAMED Ranges (Name Manager)
Advanced Version of VLOOKUP Function (All other formulas combined)
Introduction to Model and Control Panel Tab (Important Sheet Tab)
Formula Based Prepaid Expenses Model Deep Dive (Part 1)
Formula Based Prepaid Expenses Model Deep Dive (Part 2)
Formula Based Prepaid Expenses Model Deep Dive (Part 3)
IFS Function Month End date Prepayment calculation
Prepaid Expenses Closing Balance Summary Tab (Formula Based Summary)
Protecting Formulas Cells and Fields in the Model
Exact Date Prepaid Amorisation calculation Intro
Formulas update for Exact Prepaid Exps Calculation
Formulas Update for Exact Date Amortisation 1
Formulas Update for Exact Date Amortisation 2
Formulas Update for Exact Date Amortisation 3
Formulas Update for Exact Date Amortisation 4
IFS Function Exact Date Prepayments Amortisation
Data Validation Controls
Bonus Prepayment Model Opening Balances1
Bonus Prepayment Model Opening Balances2
Power Query and Pivot Table Prepayment Summary Table Intro
Power Query and Pivot Table Summary Deep Dive (Part 1)
Power Query and Pivot Table Summary Deep Dive (Part 2)
Power Query and Pivot Table Summary Deep Dive (Part 3)
Power Query and Pivot Table Summary Deep Dive (Part 4)
Using Array Formulas to Add Formula Protection
Bonus Allocation Intro 1
Bonus Allocation Walk 2
New Version Power Query and PT Model
Complete Walkthrough Advanced VBA Prepaid Expenses Amortisation Model
Bonus New Version Excel VBA Model
Dynamic Dashboard Overview
Importing Profit and Loss Statements
Creating Dynamic Data Validation
Creating Named Ranges for Dynamic Table
Dynamic Date Column Headings
Dynamic Month and YTD Dashboard tables headings (PRO TIP)
Dynamic VLOOKUP Formula First section of the Dashboard
Creating Rolling Dashboard with Dynamic VLOOKUP Function
IMPORTANT Error Checking (PRO TIP)
Data Prep for AREA Charts (#NA Function)
Visualization AREA Charts for Month
Visualization DONUT Charts Revenue, GP, NP 1
Visualization DONUT Charts Revenue, GP, NP 2
Introduction Formulaless Dashboard
Understanding the data files
Consolidation with Power Query
Dynamic File Path Trick in Power Query
Conditional Cumulative totals
Conditional Cumulative totals with M Code
Dashboard Creation Pivot Table
Dashboard Creation Donuts Charts
Dashboard Creation Line Charts
Update Dashboard with New Data
Thank you for going through this Journey