Excel Is Fun

Excel Magic Trick 1294

May 8, 2017 0

DESCRIPTION If you do not have a Proper Data Set Lookup Table, but rather a Rectangular Improper Lookup Table, learn how to create a single cell formula to Score Myers-Briggs Assessment (Test). This amazing formula […]

Excel Is Fun

Highline Excel 2013 Class Video 34

May 5, 2017 0

DESCRIPTION Topics in this video: 1. Subtotals. 2. Alternatives to Subtotal: SUMIFS Formulas and PivotTables. 3. Sort First!!!!!!!!!!!!!!! 4. Add Subtotals based on One Column (Field). 5. Outline. 6. Copy and Paste Subtotal Report Trouble. […]

Excel Is Fun

Excel Magic Trick 1293

May 4, 2017 0

DESCRIPTION Learn how to Score Myers-Briggs Assessment (Test) with a single cell lookup array formula that uses the LOOKUP and SUMPRODUCT functions and points to a proper data set. WORKBOOKS

Dueling Excel

Dueling Excel 140

May 3, 2017 0

DESCRIPTION One cell has a security name, ticker symbol, then price. The complicated part is that the security name might have 3, 4, or 5 words. How can you extract the last 2 words into […]

Excel Is Fun

Excel Magic Trick 1292

May 1, 2017 0

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

Excel Is Fun

Highline Excel 2013 Class Video 33

April 28, 2017 0

DESCRIPTION Topics in this video: 1. Most sorting is done on a Proper Data Set. 2. Click in single cell and use Sort Button. 3. Whole data set is sorted, not just selected column. 4. […]

Excel Is Fun

Excel Magic Trick 1291

April 27, 2017 0

DESCRIPTION Learn how to Score Myers-Briggs Assessment (Test) in Excel with Two Formulas: (00:13) Problem Introduction (01:50) Formula 1: Lookup correct letter for each answer. An array Operation, COLUMN function, SUMPRODUCT function and INDEX Function. […]

Dueling Excel

Dueling Excel 139

April 26, 2017 0

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

April 24, 2017 0

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

Excel Is Fun

Highline Excel 2013 Class Video 32

April 21, 2017 0

DESCRIPTION Topics in this video: 1. Essential definition of array formula: operation on an array of items rather than single items. 2. Example of operation on single items: subtracting 2 cells. 3. Example of operation […]