Excel Is Fun

Highline Excel 2016 Class 22

DESCRIPTION In this video learn about: (00:16) Introduction to Entire Project, including what type of start files we have and what the final report looks like. (03:36) What is Data Modelling? Steps to creating a [Read More >>>]

Excel Is Fun

Excel Magic Trick 1398

DESCRIPTION See how to: (00:15) Introduction (02:45) Look at Data Model in Download file. This is the Data Model that we start with at beginning of video. (04:55) Add Upper & Lower Limit “Regular Increment” [Read More >>>]

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

Excel Magic Trick 1390

DESCRIPTION See how to calculate Average Number of Days Between Dates in a Single Column: 1. Introduction 2. Helper Column and AVERAGE Function 3. AVERAGE Function Array Formula. Requires Ctrl + Shift + Enter 4. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1382

DESCRIPTION See how to: (00:15) Introduction to Contains Criteria (Partial Text Criteria) in an OR Logical Test, when search for records with Multiple Contains Criteria. (02:00) #1 Filter & Helper Column with Formula that uses [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

Excel Magic Trick 1371

DESCRIPTION See how to Create Excel Formula To Add Last Five Values in an Excel Table using INDEX function to create a Dynamic Range inside the SUM Function. Topics: (00:14) Introduction to add Last 5 [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 03

DESCRIPTION In this video learn about the fundamentals of Data Analysis and Business Intelligence in Excel 2016: Sort, Filter, PivotTables, Power Query, Power Pivot Data Model: (00:00:05) Introduction (00:01:39) Sort (00:03:02) Sorting one column (00:03:23) [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 02

DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text and Number Formulas for counting numbers above [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 01

DESCRIPTION In this video learn about these Excel Fundamentals for Excel Highline Excel 2016 Class: (00:33) Prerequisites for class (01:04) Excel Professional 2016 (01:50) Install Com Add-in Power Pivot (02:54) Examples of Effective and Efficient [Read More >>>]