Excel VBA Business Simulation: From Beginner To Professional
- Buy now
- Learn more
Prologue

Prologue Final.mp4
Lesson 1: Course Purpose, Structure And The Learning Journal

Learning Journal.xlsm
Explainer Videos Download File.xlsm
Start Here - Course Introduction.mp4
Lesson 2: The Basic Simulation Mechanism In Excel

E1 Build A Probability Table.mp4
E2 Random Numbers And The Simulation Mechanism.mp4
E3 VLOOKUP To Extract Output From Table.mp4
E4 Validate Simulated Data.mp4
Lesson 3: Introduction To Excel VBA For Business Simulations

E5 Excel VBA Intro.mp4
E6 Calculation In Excel.mp4
E7 Record A Macro.mp4
E8 Organic Code To Update Randoms.mp4
Lesson 4: Data Analysis Formulae For Excel VBA Business Simulations

E9 COUNTIF COUNTIFS.mp4
E10 SUMIF SUMIFS.mp4
E11 FREQUENCY.mp4
Lesson 5: Introduction To The Normal Distribution In Excel

E12 Introduction To Normal Distribution.mp4
E13 Sampling The Normal Distribution In Excel.mp4
Lesson 6: Foundational Concepts In Excel VBA For Business Simulations

E14 With End With.mp4
E15 Variable Types.mp4
E16 Named Ranges.mp4
Lesson 7: Excel VBA Loops For Business Simulations

E17 Random Numbers With VBA.mp4
E18 For Each Loop.mp4
E19 Do Until Loop.mp4
Lesson 8: Excel Conditional Statements For Business Simulations

E20 IF.mp4
E21 Conditional Statements in VBA.mp4
Lesson 9: Advanced Excel VBA: Harnessing Application.WorksheetFunction For Business Simulations

E22 Application Dot WS Function Match Example.mp4
E23 Application Dot WS Function VLookup.mp4
Lesson 10: Power Programming For Business Simulations With Excel VBA

E24 Dot Cells Technique.mp4
E25 Range Range Range.mp4
Simulation Model Build Walkthrough 1

Simulation Model Build Walkthrough 1.mp4
Simulation Model Build Walkthrough 2

Simulation Model Build Walkthrough 2.mp4
Simulation Model Build Walkthrough 3

Simulation Model Build Walkthrough 3.mp4
Simulation Model Build Walkthrough 4

Simulation Model Build Walkthrough 4.mp4
Simulation Model Build Walkthrough 5

Simulation Model Build Walkthrough 5.mp4
Simulation Model Build Walkthrough 6

Simulation Model Build Walkthrough 6.mp4
Simulation Model Build Walkthrough 7

Simulation Model Build Walkthrough 7.mp4
Simulation Model Build Walkthrough 8

Simulation Model Build Walkthrough 8.mp4
Simulation Model Build Walkthrough 9

Simulation Model Build Walkthrough 9.mp4
Simulation Model Build Walkthrough 10.mp4
Simulation Model Build Walkthrough 10

Simulation Model Build Walkthrough 11.mp4
Bonus Content

Monty Hall Simulation Model Build.mp4
Interview With Industry Professional.mp4
Monty Hall Simulation Model.xlsm
Industry Expert Interview Notes.xlsm
Epilogue

Epilogue Final.mp4

Lesson 2: The Basic Simulation Mechanism In Excel

In lesson 2, I introduce you to the basic simulation mechanism in Excel. Most Excel simulations are driven by the same basic mechanism - so let's learn it immediately! The mechanism consists of a probability table, VLOOKUP formula and random number. We also learn how to validate the mechanism to ensure the outputs conform to the desired probability distribution. Here you go, your first Excel simulation!

4 Lessons