Excel Is Fun

Excel Magic Trick 1233

September 26, 2016 0

DESCRIPTION VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function Learn how to do a VLOOKUP to 36 Different Dynamic Tables (will have records added and removed over time) using the Excel Table […]

Excel Is Fun

Excel Magic Trick 1232

September 22, 2016 0

DESCRIPTION VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1 Learn how to use Power Query transform 36 Lookup Tables Into 1 Lookup Table for VLOOKUP Formula. (00:10) Introduction to problem we […]

Excel Is Fun

Excel Magic Trick 1231

September 19, 2016 0

DESCRIPTION VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function? Learn how to: (00:12) Introduction to problem we want to solve. (01:52) CHOOSE Function Solution, with VLOOKUP and MATCH functions and the asterisk wild […]

Dueling Excel

Dueling Excel 103

September 16, 2016 0

Find Missing Numbers In A Series DESCRIPTION See Mr Excel and excelisfun use two formula methods to Find Missing Numbers In A Series: See Mr Excel use the functions IF, ISNA, VLOOKUP, ROW, and SMALL […]

Dueling Excel

Dueling Excel 100

September 7, 2016 0

Two Way Lookup Formula and Conditional Formatting! DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Mr Excel creates formula to do Two Way Lookup using INDEX and 2 MATCH functions 2. Excelisfun […]

Excel Is Fun

Excel Magic Trick 1220

August 11, 2016 0

How To Put Double Quotes In Text Formula: Extra Double Quotes Or VLOOKUP DESCRIPTION Learn how to either use IF function and Extra Double Quotes or VLOOKUP to put the text 5’6” or 6’ into […]

Excel Is Fun

Highline Excel 2016 Class 02

July 24, 2016 0

Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text […]

Dueling Excel

Dueling Excel 86

July 13, 2016 0

MODE or MEDIAN From Frequency Table Formula or VBA? DESCRIPTION See Mr Excel and excelisfun use two methods calculate MODE or MEDIAN From Frequency Table – Formula or VBA. See the functions, AND, COUNTIF, MAX, […]

Dueling Excel

Dueling Excel 81

June 8, 2016 0

Extract Multiple Records Based on Two Criteria VBA or Formula DESCRIPTION See Mr Excel and excelisfun Extract Multiple Records Based on Two Criteria using VBA and formula. See the functions AND, SUM, VLOOKUP, ROWS, COLUMNS […]

Dueling Excel

Dueling Excel 75

April 27, 2016 0

Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX? DESCRIPTION See Mr Excel and excelisfun create Dynamic Range For VLOOKUP and Data Validation using the OFFSET and INDEX functions. WORKBOOKS