Excel Is Fun

Excel Magic Trick 1133

June 11, 2015 0

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: […]

Dueling Excel

Dueling Excel 024

May 24, 2015 0

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? […]

Excel Is Fun

Excel Magic Trick 1129

April 29, 2015 0

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 […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 03

April 3, 2015 0

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 […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 01

April 1, 2015 0

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 […]

Dueling Excel

Dueling Excel 019

March 19, 2015 0

DESCRIPTION See Mr Excel and excel is fun try to use VLOOKUP to the left. Mr Excel shows how to use INDEX & MATCH to solve this problem. Excelisfun will use the LOOKUP function to […]

Dueling Excel

Dueling Excel 018

March 18, 2015 0

DESCRIPTION See Mr Excel and excelisfun use the functions: IF, FIND, SEARCH, AND, OR, ISNUMBER, ISERROR, REPLCE and VLOOKUP. See Mr Excel and excel is fun create an IF function formula that use the functions […]

Excel Is Fun

Excel Magic Trick 1107

March 5, 2015 0

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

February 28, 2015 1

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