### Dueling Excel 145

June 7, 2017

DESCRIPTION See Mr Excel and excelisfun convert YYYYMMDD Numbers To Dates: 1. Text To Columns 2. Formula with DATE, LEFT, RIGHT, MID functions 3. Flash Fill 4. Text Function with custom Number Format 0000\/00\/00 WORKBOOKS

### Highline Excel 2013 Class Video 31

April 14, 2017

Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More DESCRIPTION Topics in this video: 1. TODAY function to put in today’s date so that it updates each day. 2. NOW to put in today’s date […]

### Highline Excel 2013 Class Video 30

April 7, 2017

Custom Number Formatting & Text Functions, (33 Examples) DESCRIPTION Topics in this video: 1. 23 Examples of Custom Number Formatting. 2. Custom Number Formatting For Unit Price for Invoice. 3. Three TEXT function examples for […]

### Excel Magic Trick 1274

February 27, 2017

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 127

February 1, 2017

DESCRIPTION Adding After & Before Dash: Array Formula or VBA? See Mr Excel and excelisfun use two methods to solve this very difficult adding problem: you must add numbers from a column of text strings […]

### Dueling Excel 107

September 23, 2016

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

### Dueling Excel 102

September 14, 2016

Remove Duplicate Records Based On Partial Text in a Cell DESCRIPTION See Mr Excel and excelisfun use two methods to Remove Duplicate Records Based On Partial Text in a Cell using: 1. Formula with SUBSTITUTE, […]

### Dueling Excel 101

September 9, 2016

Sum Numbers from Cells That Contain Both Text & Numbers DESCRIPTION See Mr Excel and excelisfun use two methods to add the numbers from cells that have both numbers and text. See these tricks: 1. […]

### Excel Magic Trick 1224

August 25, 2016

Which Similar Array Formula? Compare Number of Array Operations DESCRIPTION Learn how to build similar formulas and compare the number of array operations in order to decide which formula might be most efficient: (00:08) Problem […]

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