March 18, 2017

### Highline Excel 2013 Class Video 27

March 17, 2017

DESCRIPTION Topics in this video: 1. List of possible errors in Excel. 2. 4 Steps to finding formula errors. 3. 3 Examples of how to use the 4 steps. 4. Cleaning Text data with the […]

### Excel Magic Trick 1279

March 16, 2017

DESCRIPTION Learn how to create a New Running Count (Cumulative Count) Formula After Each Zero Value using the IF and SUM functions. Trick from Bill Szysz at YouTube. See that the SUM Function ignores Text […]

### Dueling Excel 133

March 15, 2017

DESCRIPTION See Mr Excel and excelisfun use two methods to sum the three biggest values that match three criteria (3 conditions) 1. Advanced Filter and LARGE and MAX value 2. SUM and LARGE functions with […]

### Hide / Show Worksheet Gridlines

March 14, 2017

The gridlines displayed in a worksheet can be very useful especially when you are designing your worksheets. There are times however when you may want to hide the gridlines. How to hide/show gridlines for a […]

March 14, 2017

### Excel Magic Trick 1278

March 13, 2017

Extract Colour From Description (Text String) Learn how to Extract Colour From Description (Text String) using LOOKUP & SEARCH functions and the Big Number 2^15 in an Array Formula. WORKBOOKS

### Create Your Own Icons Using Wingdings

March 12, 2017

Wingdings & Webdings are symbolic fonts used in most of the Microsoft Office package programs including Excel. Microsoft Wingdings was released in 1992 and there are three versions of it: Wingdings, Wingdings2 and Wingdings3. The […]

March 11, 2017

### Highline Excel 2013 Class Video 26

March 10, 2017

DESCRIPTION Topics in this video: 1. Is Item In List 2 also in List 1? Use MATCH and ISNUMBER. Comparing a prospective customer sales phone list to the companies master customer list. 2. Sort Dialog […]