Excel Is Fun

Excel Magic Trick 1274

February 27, 2017 0

DESCRIPTION Learn how to avoid long formula with multiple IF Functions by using the lookup functions: VLOOKUP or LOOKUP. Also see a “Partial Text Lookup” Situation where we have to lookup just part of a […]

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

Dueling Excel

Dueling Excel 107

September 23, 2016 0

Count Between Words DESCRIPTION See Mr Excel and excelisfun use three methods to add a leading zero at front and a dash in middle of a number that may be of variable length: 1. Formula […]

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

Excel Is Fun

Highline Excel 2016 Class 01

July 16, 2016 0

Excel Fundamentals: Efficiency, Data, Data Sets, Formatting DESCRIPTION In this video learn about these Excel Fundamentals for Excel Highline Excel 2016 Class: (00:33) Prerequisites for class (01:04) Excel Professional 2016 (01:50) Install Com Add-in Power […]

Dueling Excel

Dueling Excel 73

April 13, 2016 0

Coax Time Value From Text: MOD, LEFT, RIGHT, TEXT, MOD Functions DESCRIPTION See Mr Excel and excelisfun use the functions MOD, LEFT, RIGHT, TEXT, TIMEVALUE, and MOD to coax a time value from a time […]

Excel Is Fun

Excel Magic Trick 1199

April 4, 2016 0

Formula to Extract Everything After Last Space: Two Formula Solutions DESCRIPTION See how to use Formula to Extract Everything After Last Space: (00:08) Problem Setup (01:05) Formula with TRIM, RIGHT, SUBSTITUTE, REPT, LEN and LEN […]

Excel Is Fun

Excel Magic Trick 1196

March 14, 2016 0

YYMMDD Text Dates To Serial Number Dates? 2 More Formulas & Other Tips… DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then […]