Preview unavailable

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.mp42

• 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.mp41

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