Excel Is Fun

Excel Magic Trick 1268

February 6, 2017 0

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

Excel Is Fun

Highline Excel 2016 Class 04

January 24, 2017 0

WReferences: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Table… DESCRIPTION In this video learn about: (00:04) Download Files (00:30) Introduction to types of References (01:38) Example 1: Not Copying Formula. Goal: Calculate Net Income. (02:09) Example […]

Excel Is Fun

Excel Magic Trick 1260

January 9, 2017 0

DESCRIPTION VLOOKUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes. Learn how to prevent VLOOKUP from returning a zero when it sees an empty cell in the lookup table: (00:12) Problem setup. (00:49) […]

Excel Is Fun

Excel Magic Trick 1259

January 5, 2017 0

DESCRIPTION Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula? Learn how to use two lookup values to lookup an item in a table: (00:11) Problem Introduction and discussion of default behavior for VLOOKUP […]

Excel Is Fun

Excel Magic Trick 1253

December 5, 2016 0

DESCRIPTION Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH! Learn how to get VLOOKUP to use Column Headers for the col_index-num argument by using the MATCH function. See how to lookup […]

Excel Is Fun

Excel Magic Trick 1249

November 21, 2016 0

DESCRIPTION Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail **Note; The word “Database” is used loosely in this video. We use it just to mean we have a dynamic table […]

Dueling Excel

Dueling Excel 115

October 21, 2016 0

Plot Chart, Show Only Selected Employee Name Is Axis DESCRIPTION See Mr Excel and excelisfun use two methods to plot all the sales for all the employees, but show only the employee name of selected […]

Dueling Excel

Dueling Excel 113

October 14, 2016 0

Excel Truel: VLOOKUP Fun With Excelisfunner (Isaac 6 Years Old) DESCRIPTION See Excelisfunner, Mr Excel and excelisfun do VLOOKUP and Data Validation List to select a kids name and pull up the bike they ride: […]

Dueling Excel

Dueling Excel 110

October 5, 2016 0

3 VLOOKUPS Calculate Cost Based on Product, Packaging, Discount DESCRIPTION See Mr Excel and excelisfun use two methods to calculate the total costs when there are three factors that go into calculating costs: Product Name, […]

Excel Is Fun

Excel Magic Trick 1235

October 3, 2016 0

DESCRIPTION 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP Learn how to do a two way lookup to retrieve the conversion rate for currencies: (00:11) Two-Way Lookup for Currency Conversion Problem […]