Multi Regression using Excel

Basic Financial Calculation – pt.1

Total Running Time: 15:45

fixed cash flows, 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, payment schedule, Principal

Basic Financial Calculation – pt.2

Calculating Expected Values in Excel

Total Running Time: 06:28

Expected Values, Microsoft Excel, SUMPRODUCT

Calculating Expected Values in Excel

Competitive Balance in Sports

Total Running Time: 11:13

home field advantage, Microsoft Excel, uncertain of outcome hypotheses

Competitive Balance in Sports

Data Analysis Add-In

Total Running Time: 05:23

descriptive statistics, frequency distribution, histogram, Microsoft Excel

Data Analysis Add-In

Demand Management Forecasting Part 1

Total Running Time: 07:14

Demand Management, Forecast Bias, Forecast Error, forecasting, Independent Demand

Demand Management Forecasting Part 1

Demand Management Forecasting Part 2

Total Running Time: 14:19

Demand Management, Forecast Bias, Forecast Error, forecasting, Independent Demand

Demand Management Forecasting Part 2

Descriptive Statistics

Total Running Time: 03:44

Microsoft Excel, statistical functions

Descriptive Statistics

Economics – The Law of Supply and Demand

Total Running Time: 08:24

financing, forecasting, pricing, supply and demand in CapSim

Economics – The Law of Supply and Demand

Excel Charts

Total Running Time: 07:58

Microsoft Excel, pie chart, quick instant charts

Excel Charts

Excel Formulas in Financial Statements

Total Running Time: 29:16

apply formulas, final statement, 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

copy grouped data, Microsoft Excel, multiple categories

Excel Subtotals

Exponential Smoothing with Excel

Total Running Time: 16:23

Exponential Smoothing Forecast, MAD, Microsoft Excel, MPE, Smoothing Constant

Exponential Smoothing with Excel

Formulas: Relative & Absolute Addressing

Total Running Time: 05:37

create formulas and functions, Microsoft Excel

Formulas: Relative & Absolute Addressing

Frequency Distribution

Total Running Time: 04:58

charts, Microsoft Excel

Frequency Distribution

FSA Pro Forma Construction

Total Running Time: 09:04

forecasting, Pro Forma Balance Sheet, Pro Forma Income statement

FSA Pro Forma Construction

Group and Outline

Total Running Time: 03:38

Microsoft Excel, multi level formulas

Group and Outline

IF Functions

Total Running Time: 04:46

Microsoft Excel

IF Functions

Intro to Sport Analytics

Total Running Time: 06:39

big data, forecasting, Models and Theories, prediction, probability, risk

Intro to Sport Analytics

Introduction to Tax

Total Running Time: 32:42

calculate, decision, federal, forecasting, investment, local, personal, political, state, system, tax rate structure

Introduction to Tax

Linear Programming Examples

Total Running Time: 05:50

Excel OM, Excel Solver, Microsoft Excel, sensitivity report

Linear Programming Examples

Marketing – What is Consumer Behavior in a B2B Market

Total Running Time: 09:11

Business Buyer, Buyer Power, Buying Patterns, forecasting, Promotions

Marketing – What is Consumer Behavior in a B2B Market

Moneyball and Excel

Total Running Time: 12:21

applications of regressions, Microsoft Excel, multiple regressions, regressions, simple regressions

Moneyball and Excel

Moving Averages in Excel

Total Running Time: 24:55

Mean Absolute Deviation, Mean Percentage Error, Microsoft Excel, Moving Average

Moving Averages in 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

decision models, Microsoft Excel, presentations

Naming Cells: Meaningful Modeling

Pivot Tables

Total Running Time: 08:20

manipulations, Microsoft Excel

Pivot Tables

Pro Forma Financial Statement Modeling

Total Running Time: 14:41

Balance Sheet (BS), financial statements, forecasting, Income statement assumptions, pro forma, the "plug"

Pro Forma Financial Statement Modeling

Selecting Efficiently in Excel

Total Running Time: 02:42

data range, Microsoft Excel, shortcuts

Selecting Efficiently in Excel

Simple Statistical Regression

Total Running Time: 08:07

Linear Regression, Microsoft Excel, scatter chart

Simple Statistical Regression

Sorting Data

Total Running Time: 03:20

Microsoft Excel, single and multiple parameters

Sorting Data

Sparklines

Total Running Time: 03:27

how to format sparkline, Microsoft Excel, three types of sparkline

Sparklines

Text Manipulation

Total Running Time: 02:36

Microsoft Excel, transfer Text File Formats

Text Manipulation

VLookup Tables

Total Running Time: 07:09

exact match, Microsoft Excel, Range Lookup, Vlookup function

VLookup Tables

What-if Analysis – Data Table

Total Running Time: 09:42

Break-Even Point (BEP), Microsoft Excel, one and two way data tables, sensitivity analysis

What-if Analysis – Data Table

What-If Analysis – Goal Seek

Total Running Time: 05:44

decision analysis and modeling, Microsoft Excel

What-If Analysis – Goal Seek