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 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
Formulas: Relative & Absolute Addressing Total Running Time: 05:37 create formulas and functions, Microsoft Excel Formulas: Relative & Absolute Addressing
Loan Amortization Table Total Running Time: 08:22 finance, Loan Balance, payment, Principle Payment Loan Amortization Table
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
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
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
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