Excel Is Fun
Excel Magic Trick 1325
DESCRIPTION See how to create a report that require that we find the MIN and MAX Alphanumeric Academic Quarters for each Student ID. See eight different methods including: 1) VLOOKUP, 2) MIN & IF Array […]
VLOOKUP
Excel Is Fun
Excel Magic Trick 1316
DESCRIPTION See how to use VLOOKUP when there are multiple Lookup Tables with these methods: (00:15) Problem Set up (01:48) IF Function (05:57) IFS Function (Excel 2016 Insider Program) (Formula from XLarium at YouTube) (08:47) […]
Excel Is Fun
Excel Magic Trick 1306
DESCRIPTION Learn how to create a formula that simulates a relationship between two tables (like a VLOOKUP Helper Column) to create a Regional Report. See array formula where we see VLOOKUP function and Exact Match […]
Excel Is Fun
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: […]
Dueling Excel
Dueling Excel 143
DESCRIPTION See Mr Excel and excelisfun create two solutions for looking up and calculating a percentage commission that does not exceed the max amount for some of the products. See the functions: VLOOKUP, MIN, and […]
Excel Is Fun
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. […]
Dueling Excel
Dueling Excel 141
DESCRIPTION See Mr Excel and excelisfun in an epic back and forth duel (7 back and forths) try to figure out how to lookup three different items in three different tables and then multiply the […]
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 […]
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 […]