### Highline Excel 2016 Class 02

July 24, 2016

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

### Highline Excel 2016 Class 01

July 16, 2016

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 73

April 13, 2016

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 Magic Trick 1196

March 14, 2016

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

March 11, 2016

WORKBOOKS

### Excel Magic Trick 1195

March 7, 2016

Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution? DESCRIPTION See how to deal with a Text Date in the form YYMMDD when some of the years are 1900 and some […]

### Dueling Excel 67

March 2, 2016

Extract Initials From Full Name: VBA or Formula? DESCRIPTION See Mr Excel and excelisfun Extract Initials From Full Name using: VBA and a Formula. See the Functions TRIM, REPLACE, LEFT, and SEARCH. WORKBOOKS

### Dueling Excel 57

December 30, 2015

Extract Many Years from Just Two Years DESCRIPTION See Mr Excel and excelisfun take the text string “1997-2000” and create a row of years consisting of 1997, 1998, 1999, 2000. See the functions LEFT, RIGHT, […]

### Excel Magic Trick 1183

December 14, 2015

Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula DESCRIPTION See how to take a list of menu items with unwanted text after the dash and remove the unwanted text using: (00:08) […]

### Dueling Excel 045

October 14, 2015

+ or with Formula or Custom Number Formatting Math Plus or Minus DESCRIPTION See Mr Excel and excelisfun: 1) create a formula to extract a number from a text string that can be used for […]