Faculty: Isaac Gottlieb Tags: Break-Even Point (BEP)Microsoft Excelone and two way data tablessensitivity analysis
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
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 descriptive statistics, frequency distribution, histogram, Microsoft Excel Data Analysis Add-In
Descriptive Statistics Total Running Time: 03:44 Microsoft Excel, statistical functions Descriptive Statistics
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 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
Linear Programming Examples Total Running Time: 05:50 Excel OM, Excel Solver, Microsoft Excel, sensitivity report Linear Programming Examples
Linear Programming III: Solving the Model Total Running Time: 32:14 equation, linear, POM, programming, resource, sensitivity analysis, solve, variable Linear Programming III: Solving the Model
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
Multi Regression using Excel Total Running Time: 13:46 Data Analysis Tool Pak, forecasting, Microsoft Excel, Multi Regression, 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 decision models, Microsoft Excel, presentations Naming Cells: Meaningful Modeling
Pivot Tables Using Excel Total Running Time: 12:43 Business Insight, Data Analysis, Microsoft Excel, Pivot Tables Pivot Tables Using Excel
Scroll Bars – Sensitivity Analysis Total Running Time: 09:39 Scroll Bars, sensitivity analysis Scroll Bars – Sensitivity Analysis
Selecting Efficiently in Excel Total Running Time: 02:42 data range, Microsoft Excel, shortcuts Selecting Efficiently in Excel
Sensitivity Analysis Total Running Time: 03:45 costs, CVP Analysis, Sale Price, Sales Mix, 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
Sentiment Analysis Using Excel Total Running Time: 08:59 Automatic Sentiment Analysis, Manual Sentiment Analysis, Microsoft Excel, Sentiment Analysis Sentiment Analysis Using Excel
Simple Statistical Regression Total Running Time: 08:07 Linear Regression, Microsoft Excel, scatter chart Simple Statistical Regression
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
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 exact match, Microsoft Excel, Range Lookup, Vlookup function VLookup Tables
What-If Analysis – Goal Seek Total Running Time: 05:44 decision analysis and modeling, Microsoft Excel What-If Analysis – Goal Seek