Skip to main content
Fox School of Business Video Vault

What-if Analysis Data Table

Related Videos

Auto Fill

06:15

Auto Filter

03:16

Conditional Formatting

04:18

Cost-Volume-Profit Analysis: Breakeven

14:53

Cost-Volume-Profit Analysis: Target Operating Income

12:02

Data Analysis Add-In

05:23

Descriptive Statistics

03:44

Excel Charts

07:58

Excel Formulas in Financial Statements

29:16

Excel Proficiency – Introduction

03:08

Excel Scenario Manager

08:58

Excel Solver Part 1

12:31

Excel Solver Part 2

14:33

Formulas: Relative & Absolute Addressing

05:37

Frequency Distribution

04:58

Group and Outline

03:38

IF Functions

04:46

Linear Programming III: Solving the Model

32:14

Lookup Tables

07:09

Naming Cells and Ranges

07:04

Naming Cells Meaningful Modeling

04:52

Pivot Tables

08:20

Scroll Bars Sensitivity analysis

09:39

Selecting Efficiently in Excel

02:42

Sensitivity Analysis

03:45

Sensitivity, Scenario, & Break-even

21:49

Simple Statistical Regression

08:07

Sorting Data

03:20

Sparklines

03:27

Subtotals

04:16

Text Manipulation

02:36

Valuing the firm using Pro Forma Financial Statements

14:16

What if Analysis Goal Seek

05:44