Excel

Auto Filter

Total Running Time: 03:16

Microsoft Excel, numbers text filters by color

AutoFill

Total Running Time: 06:15

custom list, Microsoft Excel

Conditional Formatting

Total Running Time: 04:18

conditional and advanced formatting, Microsoft Excel

Data Analysis Add-In

Total Running Time: 05:23

descriptive statistics, frequency distribution, histogram, Microsoft Excel

Data Mining

Total Running Time: 15:39

data mining, marketing, Pivot Tables

Descriptive Statistics

Total Running Time: 03:44

Microsoft Excel, statistical functions

Excel Charts

Total Running Time: 07:58

Microsoft Excel, pie chart, quick instant charts

Excel Proficiency – Introduction

Total Running Time: 03:08

course overview, Microsoft Excel

Excel Subtotals

Total Running Time: 04:16

copy grouped data, Microsoft Excel, multiple categories

Formulas: Relative & Absolute Addressing

Total Running Time: 05:37

create formulas and functions, Microsoft Excel

Frequency Distribution

Total Running Time: 04:58

charts, Microsoft Excel

Group and Outline

Total Running Time: 03:38

Microsoft Excel, multi level formulas

IF Functions

Total Running Time: 04:46

Microsoft Excel

Loan Amortization Table

Total Running Time: 08:22

finance, Loan Balance, payment, Principle Payment

Logistics Case Study

Total Running Time: 14:13

logistics, Scroll Bars in Excel

Lookup Tables

Total Running Time: 07:09

exact match, Microsoft Excel, Range Lookup, Vlookup function

Multi Regression using Excel

Total Running Time: 13:46

Data Analysis Tool Pak, Excel, forecasting, Multi Regression, statistics

Naming Cells and Ranges

Total Running Time: 07:04

functions, Microsoft Excel, modeling, statistics

Naming Cells: Meaningful Modeling

Total Running Time: 04:52

decision models, Microsoft Excel, name, presentations

Pivot Tables

Total Running Time: 08:20

manipulations, Microsoft Excel

Scroll Bars – Sensitivity Analysis

Total Running Time: 09:39

Scroll Bars, sensitivity analysis

Selecting Efficiently in Excel

Total Running Time: 02:42

data range, Microsoft Excel, shortcuts

Simple Statistical Regression

Total Running Time: 08:07

Linear Regression, Microsoft Excel, scatter chart

Sorting Data

Total Running Time: 03:20

Microsoft Excel, single and multiple parameters

Sparklines

Total Running Time: 03:27

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

Surface charts

Total Running Time: 03:48

Surface Charts

Text Manipulation

Total Running Time: 02:36

Microsoft Excel, transfer Text File Formats

What-if Analysis – Data Table

Total Running Time: 09:42

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

What-If Analysis – Goal Seek

Total Running Time: 05:44

decision analysis and modeling, Microsoft Excel