### Excel 2013 PowerPivot Basics 01

DESCRIPTION Basics of PowerPivot: Why PowerPivot?, Add to Data Model, Relationships, Calculated Column, Calculated Field, Build report with PivotTable based on Data Model: (00:22) Smartest People with PowerPivot (01:31) Which Versions of Excel 2013 contain [Read More >>>]

### Excel Magic Trick 1115

DESCRIPTION PivotTable to Count How Many of Each Item There Are In a Column WORKBOOKS

### Excel Magic Trick 1114

DESCRIPTION See how to create formula for Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 1, 18443 2, 18444 2, 18445 2, 18446 3…. See formula that uses the functions ROWS, INT and the [Read More >>>]

### Excel Magic Trick 1113

DESCRIPTION 1. Text To Columns using Fixed Width, One Time Event 2. Formula that will update when data changes. Formula uses MID and COLUMNS functions and Mixed Cell References. WORKBOOKS

### Excel Magic Trick 1112

DESCRIPTION (01:06) Group By Date In PivotTable Error (Cannot group that selection error) (01:42) Text To Columns To Convert Text Dates To Dates (02:53) Text To Columns Fatal Error (Microsoft Excel has stopped working error) [Read More >>>]

### Excel Magic Trick 1111

DESCRIPTION See how to extract items in List 2 that are also in List 1 using a great array formula from Exceli Adam at YouTube that uses the functions IF, INDEX, MATCH and AGGREGATE. MATCH [Read More >>>]

### Excel Magic Trick 1110

DESCRIPTION See how to compare two lists and extract records with an array formula that uses these functions: MATCH, ISNA, ISNUMBER, IF, ROWS, ROW, INDEX, AGGREGATE and a number of array operations. WORKBOOKS

### Excel Magic Trick 1109

DESCRIPTION See how to Compare Two Lists and Extract Records with Excel Advanced Filter: 1. Extract items in list 2 that are NOT in List 1 using Advanced Filter and Logical Formula in Criteria Area [Read More >>>]

### Excel Magic Trick 1108

DESCRIPTION See how to Compare Two Lists and Extract Records: 1. ISNA and MATCH function with Filter to extract items in list 2 that are NOT in List 1. 2. ISNUMBER and MATCH function with [Read More >>>]

### Excel Magic Trick 1107

DESCRIPTION See how to do a VLOOKUP to a different Sheet using: 1. Sheet References 2. Defined Names 3. Table Formula Nomenclature (Structured References) WORKBOOKS