### Excel Magic Trick 1129

DESCRIPTION See how to create Ageing Accounts Receivable Reports using Slicer, Excel Table Feature and formulas: (00:09) Overview (01:05) Text Formula For Reporting Categories in Lookup Table (01:59) Days Late Formula. The correct formula for [Read More >>>]

### Excel 2013 PowerPivot Basics 03

DESCRIPTION See how to replace VLOOKUP with Excel 2013 Data Model and Relationships. See how to get two or more tables into a PivotTable Field List: (00:11) Get Two Tables into an Excel 2013 PivotTable [Read More >>>]

### 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 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

### Excel Magic Trick 1102

DESCRIPTION See how to string three VLOOKUPs and IFERROR together to do a lookup from three tables in order to rank movies. WORKBOOKS

### Highline Excel 2013 Class Video 40

DESCRIPTION Topics in this video: 1. Built-in Conditional Formatting. Conditional Formatting to cells: A logical test that comes out TRUE or FALSE. TRUE = get Formatting. FALSE = Not get Formatting. 2. Highlight Cell Rules: [Read More >>>]

### Highline Excel 2013 Class Video 35

DESCRIPTION Topics in this video: 1. 3 Reports with Formulas. 2. What is a PivotTable do? a. Summarise data b. “Calculation with criteria” c. Create Reports that contain calculations with conditions/criteria 3. Proper Data Set. [Read More >>>]

### Highline Excel 2013 Class Video 23

DESCRIPTION Topics in this video: VLOOKUP and IFNA for Commissions: VLOOKUP to look up an actual sales rep that has a contractual rate and then the IFNA to assign the flat commission rate when there [Read More >>>]

### Highline Excel 2013 Class Video 22

DESCRIPTION Topics in this video: CHOOSE function to lookup table for VLOOKUP. 3 Tables in VLOOKUP? WORKBOOKS

### Highline Excel 2013 Class Video 20

DESCRIPTION Topics in this video: (00:15) VLOOKUP to retrieve whole record change columns manually. (02:20) VLOOKUP to retrieve whole record column number in cell. (03:43) VLOOKUP & MATCH to retrieve whole record — more dynamic [Read More >>>]