Excel Is Fun

Highline Excel 2013 Class Video 20

DESCRIPTION Topics in this video: (00:15) VLOOKUP to retrieve whole record change columns manually. (02:20) VLOOKUP to retrieve whole record column number in cell. (03:43) VLOOKUP & MATCH to retrieve whole record — more dynamic [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 19

DESCRIPTION Topics in this video: (00:11) Text Functions. (00:23) Partial Text Lookup: RIGHT & VLOOKUP. (02:17) Partial Text Lookup: LEFT and SEARCH & VLOOKUP. (05:56) Partial Text Lookup: MID & VLOOKUP. (07:51) Converting Numbers Stored [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 18

DESCRIPTION Topics in this video: (00:38) Why do we have to know lookup functions? (03:44) VLOOKUP, Exact Match. VLOOKUP delivers a value to the cell. (08:34) What happens if lookup value is not in your [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 08

DESCRIPTION Excel Table Formula Nomenclature / Structured References 22 Ex. (00:48) Excel Table feature works for Proper Data Sets. (01:16) Single cell, then keyboard to convert proper data set to Excel Table: Ctrl + T (“List” in [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 02

Comprehensive Excel Formula Types & Elements Video 12 Examples DESCRIPTION (00:39) Overview. (03:31) Hours worked formula. Type of Formula: Calculating. Formula Elements: Equal sign, parenthesis, cell reference, math operator, cell reference, parenthesis, math operator, number that [Read More >>>]

Dueling Excel

Dueling Excel 019

DESCRIPTION See Mr Excel and excel is fun try to use VLOOKUP to the left. Mr Excel shows how to use INDEX & MATCH to solve this problem. Excelisfun will use the LOOKUP function to [Read More >>>]

Dueling Excel

Dueling Excel 018

DESCRIPTION See Mr Excel and excelisfun use the functions: IF, FIND, SEARCH, AND, OR, ISNUMBER, ISERROR, REPLCE and VLOOKUP. See Mr Excel and excel is fun create an IF function formula that use the functions [Read More >>>]

Dueling Excel

Dueling Excel 001

DESCRIPTION See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array: Mr Excel: MATCH and INDEX functions in one formula to retrieve a value from the intersection [Read More >>>]

Excel Is Fun

Excel Magic Trick 1085

DESCRIPTION What if you are not allowed to have a helper columns to lookup Price and Region with VLOOKUP? And you need to calculate Total Revenue by Region? This video shows how to create a [Read More >>>]