### Highline Excel 2013 Class Video 32

April 21, 2017

DESCRIPTION Topics in this video: 1. Essential definition of array formula: operation on an array of items rather than single items. 2. Example of operation on single items: subtracting 2 cells. 3. Example of operation […]

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

### Highline Excel 2013 Class Video 29

March 31, 2017

Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example) DESCRIPTION Topics in this video: 1. Extract First Name. 2. Extract Last Name. 3. Formulas or Flash Fill?. 4. Extract First and Last Initial. 5. Flash […]

### Highline Excel 2013 Class Video 28

March 24, 2017

Excel Data Validation: List, Date, Time, Custom (22 Examples) DESCRIPTION Topics in this video: 1. Data Validation to allow only whole numbers between an upper and lower limit. 2. Create an Input Message for your […]

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

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

### Highline Excel 2013 Class Video 25

March 3, 2017

DESCRIPTION Topics in this video: 1. Goal Seek: Get Formula To Evaluate To Desired Result 2. Goal Seek: Keyboard: Alt T, G 3. Set Cell: Contains a formula with a formula input you want to […]

### Highline Excel 2013 Class Video 24

February 24, 2017

Getting Top 5 Values With LARGE And Bottom 5 With SMALL DESCRIPTION Topics in this video: 1. Getting Top five values with LARGE and ROWS 2. Getting Bottom five values with SMALL and ROWS WORKBOOKS

### Highline Excel 2013 Class Video 23

February 17, 2017

VLOOKUP and IFNA for Commissions DESCRIPTION Topics in this video: VLOOKUP and IFNA for Commissions: VLOOKUP to look up an actual sales rep that has a contractual rate and then the IFNA to assign the […]