Excel Proficiency – Introduction

Auto Filter

Total Running Time: 04:18

Excel, Microsoft Excel

Auto Filter

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

Data Analysis Add-In

Total Running Time: 05:23

histogram, Microsoft Excel

Data Analysis Add-In

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

Group and Outline

Total Running Time: 08:25

Excel, Microsoft Excel

Group and Outline

Linear Programming Examples

Total Running Time: 05:50

Excel OM, Microsoft Excel

Linear Programming Examples

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

Selecting Efficiently in Excel

Total Running Time: 04:59

Excel, Microsoft Excel

Selecting Efficiently in Excel

What-if Analysis – Data Table

Total Running Time: 09:42

Break-Even Point (BEP), Microsoft Excel, sensitivity analysis

What-if Analysis – Data Table