Excel Is Fun

Excel Magic Trick 1397

DESCRIPTION See how to create formulas and a chart for Category Totals, Running Totals, and % Running Totals: (00:15) Introduction. Why you might use formula rather than a PivotTable. (02:00) Create formulas for Lower and [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 15

DESCRIPTION In this video learn about: (00:28) Define Charts. What do Charts do? (01:12) Effective Charts: No Chart Junk. Example of Chart Junk. (02:54) Types of Charts: 11 different chart types. (06:55) Terminology for Chart [Read More >>>]

Excel Is Fun

Excel Magic Trick 1378

DESCRIPTION See how to calculate Average of Customer Total Sales by Product using Excel Formulas, Excel Array Formulas and DAX Measures in Excel Power Pivot: (00:15) Introduction (01:08) 2 Step Solution with SUMIFS and AVERAGEIF [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 06

DESCRIPTION In this video learn about All the ways to make conditional Calculations with Formulas in Excel: Built-in Functions like SUMIFS, AND function, OR Function, IS Functions, Array Formulas, D Functions and more: (00:23) Introduction [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 05

DESCRIPTION In this video learn about: (00:04) Download Files (00:24) Aggregate vs. Array Calculations & Define Array (02:55) Define Array Formulas (05:49) Example of non-array formula. Standard Formula: Formulas that calculate a single answer. Goal: [Read More >>>]

Excel Is Fun

Excel Magic Trick 1318

DESCRIPTION See how to use calculate Distinct Count with 1 Condition to create report and Chart for How Many Unique Visitors To Site Each Day with Two Methods: (00:13) Introduction (01:01) Excel 2016 Data Model [Read More >>>]

Dueling Excel

Dueling Excel 015

DESCRIPTION See Mr Excel use a Pivot Table with Grouping and a Count function to create a Frequency Distribution. See excel is fun use the FREQUENCY function (upper limit is included in count) to create [Read More >>>]

Excel Is Fun

Excel Magic Trick 1190

Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1153

Unique Count For Name & Date: Array Formula, 2013 PivotTable, More… DESCRIPTION See how to: (00:08) Problem Set Up (00:55) Excel 2013 PivotTable and “Add to Data Model” to get Distinct Count Formula (02:38) Remove [Read More >>>]