Excel Is Fun

Excel Magic Trick 1292

DESCRIPTION Learn how to Score Myers-Briggs Assessment (Test) in Excel with Two Formulas based on a proper lookup table created with Power Query (Excel 2016 Get and Transform): (00:12) Problem Introduction (00:50) Use Power Query [Read More >>>]

Dueling Excel

Dueling Excel 139

DESCRIPTION Tom would like to do a VLOOKUP to pull all employees for a given department. While VLOOKUP can not return multiple results, Bill and Mike come up with formulas to simulate the request. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1290

DESCRIPTION Learn how to create dynamic ranges using OFFSET or INDEX functions for an unusual multiple lookup table situation where the multiple tables are in a single table and the source data from a database [Read More >>>]

Excel Is Fun

Excel Magic Trick 1287

DESCRIPTION SWITCH Function: How to Lookup Formulas, References, or Anything Else Learn how to: (00:11) Intro to Exact Match lookup SWITCH Function, including a default value. SWITCH in a New Excel 2016 function. (01:13) SWITCH [Read More >>>]

Excel Is Fun

Excel Magic Trick 1286

DESCRIPTION Excel 2016 IFS Functions (9 Examples: Compare & Contrast IF & IFS Functions) Learn all about the new Excel 2016 IFS Function for situations where you have three or more items to put in [Read More >>>]

Dueling Excel

Dueling Excel 136

DESCRIPTION Variable Rent Calculation Based On Days: VBA, IF or VLOOKUP? See Mr Excel and excelisfun use two methods to calculate the total rent for a container based on a sliding scale: 1. VBA with [Read More >>>]

Dueling Excel

Dueling Excel 131

DESCRIPTION See Mr Excel and excelisfun use two methods to Prevent VLOOKUP from Returning a Zero: 1. Alter the lookup table so there are not empty cells 2. Custom Number Formatting 3. IF and VLOOKUP [Read More >>>]

Excel Is Fun

Excel Magic Trick 1274

DESCRIPTION Learn how to avoid long formula with multiple IF Functions by using the lookup functions: VLOOKUP or LOOKUP. Also see a “Partial Text Lookup” Situation where we have to lookup just part of a [Read More >>>]

Excel Is Fun

Excel Magic Trick 1269

DESCRIPTION Without Power Pivot: DAX Measures, Relationships & Data Model Using Excel 2016, learn how to access the Data Model, build Relationships between tables and create DAX Measures (Formulas in Pivot Tables) without having PowerPivot [Read More >>>]

Excel Is Fun

Excel Magic Trick 1268

DESCRIPTION Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List Learn how to build a PivotTable report from two tables without using VLOOKUP. Learn that in Excel 2016 when you add two tables [Read More >>>]