Excel Is Fun

Excel Magic Trick 1137

Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP DESCRIPTION See how to (00:08) Intro. (01:21) Approximate Match with VLOOKUP. (02:20) Approximate Match with AGGREGATE (to simulate logic that is present in DAX formula). [Read More >>>]

Dueling Excel

Dueling Excel 029

Existing Customers In Prospect List? DESCRIPTION See Mr Excel and excelisfun compare a customer list and prospects list to see if customers are in the prospects list. Then remove the duplicates. See the MATCH, VLOOKUP [Read More >>>]

Excel Is Fun

Excel Magic Trick 1134

IF or VLOOKUP function for Assigning Categories w/ Excel Formula 8 Examples DESCRIPTION See how to assign product and sales categories using various methods: Overview (00:44) Overview (01:30) IF and Hard Coded Values: Violates Excel’s [Read More >>>]

Excel Is Fun

Excel Magic Trick 1133

Aging Accounts Receivable Reports: PivotTable & Unique Identifier DESCRIPTION See how to create Aging Accounts Receivable Reports On Multiple Sheets With PivotTable where or not there are duplicate records: (01:49) Days Late Helper Column Formula: [Read More >>>]

Dueling Excel

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 Is Fun

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

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

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 Is Fun

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 Is Fun

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