### Dueling Excel 024

VLOOKUP, MAX, Boolean, IF, Which is Best? DESCRIPTION See Mr Excel and excelisfun throw out 5 different methods for calculating a bonus using VLOOKUP, MAX, Boolean, and 2 IF formulas. Which one do you like? [Read More >>>]

### Excel 2013 Power Query 02

DESCRIPTION See how to: (00:32) Explain Data and how we will transform it (01:35) Import Excel Table (01:58) Remove unwanted columns (02:10) Split Columns to remove unwanted Product ID data (02:54) Remove column after split [Read More >>>]

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

### Excel Magic Trick 1085

DESCRIPTION What if you are not allowed to have a helper columns to lookup Price and Region with VLOOKUP? And you need to calculate Total Revenue by Region? This video shows how to create a [Read More >>>]