What-if Analysis – Data Table

Basic Financial Calculation – pt.1

Total Running Time: 15:45

Internal Rate of Return (IRR), Microsoft Excel, Net Present Value (NPV)

Basic Financial Calculation – pt.1

Basic Financial Calculation – pt.2

Total Running Time: 12:53

interest, Internal Rate of Return (IRR), loan, Microsoft Excel, Net Present Value (NPV), payment

Basic Financial Calculation – pt.2

Calculating Expected Values in Excel

Total Running Time: 06:28

Microsoft Excel

Calculating Expected Values in Excel

Competitive Balance in Sports

Total Running Time: 11:13

Microsoft Excel

Competitive Balance in Sports

Cost-Volume-Profit Analysis: Breakeven

Total Running Time: 14:53

Break-Even Point (BEP), sensitivity analysis, Target Operating Income

Cost-Volume-Profit Analysis: Breakeven

Cost-Volume-Profit Analysis: Target Operating Income

Total Running Time: 12:02

Break-Even Point (BEP), sensitivity analysis, Target Operating Income

Cost-Volume-Profit Analysis: Target Operating Income

Data Analysis Add-In

Total Running Time: 05:23

histogram, Microsoft Excel

Data Analysis Add-In

Descriptive Statistics

Total Running Time: 03:44

Microsoft Excel

Descriptive Statistics

Excel Charts

Total Running Time: 07:58

Microsoft Excel, pie chart

Excel Charts

Excel Formulas in Financial Statements

Total Running Time: 29:16

Microsoft Excel

Excel Formulas in Financial Statements

Excel Proficiency – Introduction

Total Running Time: 03:08

Microsoft Excel

Excel Proficiency – Introduction

Excel Scenario Manager

Total Running Time: 08:58

Microsoft Excel

Excel Scenario Manager

Excel Solver Part 1

Total Running Time: 12:31

Microsoft Excel, spreadsheet

Excel Solver Part 1

Excel Solver Part 2

Total Running Time: 14:33

Microsoft Excel

Excel Solver Part 2

Excel Subtotals

Total Running Time: 04:16

Microsoft Excel

Excel Subtotals

Exponential Smoothing with Excel

Total Running Time: 16:23

Microsoft Excel

Exponential Smoothing with Excel

Formulas: Relative & Absolute Addressing

Total Running Time: 05:37

Microsoft Excel

Formulas: Relative & Absolute Addressing

Frequency Distribution

Total Running Time: 04:58

charts, Microsoft Excel

Frequency Distribution

Group and Outline

Total Running Time: 03:38

Microsoft Excel

Group and Outline

IF Functions

Total Running Time: 04:46

Microsoft Excel

IF Functions

Linear Programming Examples

Total Running Time: 05:50

Excel OM, Microsoft Excel

Linear Programming Examples

Linear Programming III: Solving the Model

Total Running Time: 32:14

equation, linear, resource, sensitivity analysis, solve, variable

Linear Programming III: Solving the Model

Moneyball and Excel

Total Running Time: 12:21

Microsoft Excel

Moneyball and Excel

Moving Averages in Excel

Total Running Time: 24:55

Microsoft Excel

Moving Averages in Excel

Multi Regression using Excel

Total Running Time: 13:46

forecasting, Microsoft Excel, statistics

Multi Regression using Excel

Naming Cells and Ranges

Total Running Time: 07:04

functions, Microsoft Excel, modeling, statistics

Naming Cells and Ranges

Naming Cells: Meaningful Modeling

Total Running Time: 04:52

Microsoft Excel, presentations

Naming Cells: Meaningful Modeling

Pivot Tables

Total Running Time: 08:20

Microsoft Excel

Pivot Tables

Scroll Bars – Sensitivity Analysis

Total Running Time: 09:39

sensitivity analysis

Scroll Bars – Sensitivity Analysis

Selecting Efficiently in Excel

Total Running Time: 02:42

Microsoft Excel

Selecting Efficiently in Excel

Sensitivity Analysis

Total Running Time: 03:45

costs, CVP Analysis, sensitivity analysis

Sensitivity Analysis

Sensitivity, Scenario, & Break-even

Total Running Time: 21:49

break even analysis, fixed cost, Sales Price, Scenario Analysis, sensitivity analysis

Sensitivity, Scenario, & Break-even

Simple Statistical Regression

Total Running Time: 08:07

Linear Regression, Microsoft Excel

Simple Statistical Regression

Sorting Data

Total Running Time: 03:20

Microsoft Excel

Sorting Data

Sparklines

Total Running Time: 03:27

Microsoft Excel

Sparklines

Text Manipulation

Total Running Time: 02:36

Microsoft Excel

Text Manipulation

Valuing the firm using Pro Forma Financial Statements

Total Running Time: 14:16

Enterprise Value, Free Cash Flow (FCF), pro forma, sensitivity analysis, terminal value

Valuing the firm using Pro Forma Financial Statements

VLookup Tables

Total Running Time: 07:09

Microsoft Excel

VLookup Tables

What-If Analysis – Goal Seek

Total Running Time: 05:44

Microsoft Excel

What-If Analysis – Goal Seek