Conditional Formatting Total Running Time: 04:18 conditional and advanced formatting, Microsoft Excel
Cost-Volume-Profit Analysis: Breakeven Total Running Time: 14:53 Breakeven Point, sensitivity analysis, Target Operating Income
Cost-Volume-Profit Analysis: Target Operating Income Total Running Time: 12:02 Breakeven Point, sensitivity analysis, Target Operating Income
Data Analysis Add-In Total Running Time: 05:23 descriptive statistics, frequency distribution, histogram, Microsoft Excel
Excel Formulas in Financial Statements Total Running Time: 29:16 apply formulas, final statement, Microsoft Excel
Formulas: Relative & Absolute Addressing Total Running Time: 05:37 create formulas and functions, Microsoft Excel
Linear Programming III: Solving the Model Total Running Time: 32:14 equation, linear, POM, programming, resource, sensitivity analysis, solve, variable
Naming Cells: Meaningful Modeling Total Running Time: 04:52 decision models, Microsoft Excel, name, presentations
Sensitivity Analysis Total Running Time: 03:45 costs, CVP Analysis, Sale Price, Sales Mix, sensitivity analysis
Sensitivity, Scenario, & Break-even Total Running Time: 21:49 break even analysis, fixed cost, Sales Price, Scenario Analysis, sensitivity analysis
Simple Statistical Regression Total Running Time: 08:07 Linear Regression, Microsoft Excel, scatter chart
Sparklines Total Running Time: 03:27 how to format sparkline, Microsoft Excel, three types of sparkline
Valuing the firm using Pro Forma Financial Statements Total Running Time: 14:16 Enterprise Value, FCF, free cash flow, pro forma, sensitivity analysis, terminal value
What-If Analysis – Goal Seek Total Running Time: 05:44 decision analysis and modeling, Microsoft Excel
