### Highline Excel 2013 Class Video 38

June 2, 2017

DESCRIPTION Topics in this video: 1. Split Text with Delimiter = Space. Split First and Last Name and Skip a column. Text To Columns keyboard: Alt, A, E or Alt, D, E. 2. Split Text […]

### Highline Excel 2013 Class Video 37

May 26, 2017

DESCRIPTION Topics in this video: 1. Advanced Filter: Cross Between Filter and Database Functions. 2. Advanced Filter 3 Areas: Criteria Area Data Set Extract Area: Be sure to keep area below CLEAR!!!! 3. Advanced Filter […]

### Highline Excel 2013 Class Video 36

May 19, 2017

DESCRIPTION Topics in this video: 1. Sort to Extract Records. 2. Filter for extracting records. 3. Filter Toggle Keyboard: Ctrl + Shift + L or Alt, D, F, F. 4. Single Criteria Data Extract. 5. […]

### Highline Excel 2013 Class Video 35

May 12, 2017

DESCRIPTION Topics in this video: 1. 3 Reports with Formulas. 2. What is a PivotTable do? a. Summarise data b. “Calculation with criteria” c. Create Reports that contain calculations with conditions/criteria 3. Proper Data Set. […]

### Highline Excel 2013 Class Video 34

May 5, 2017

DESCRIPTION Topics in this video: 1. Subtotals. 2. Alternatives to Subtotal: SUMIFS Formulas and PivotTables. 3. Sort First!!!!!!!!!!!!!!! 4. Add Subtotals based on One Column (Field). 5. Outline. 6. Copy and Paste Subtotal Report Trouble. […]

### Highline Excel 2013 Class Video 33

April 28, 2017

DESCRIPTION Topics in this video: 1. Most sorting is done on a Proper Data Set. 2. Click in single cell and use Sort Button. 3. Whole data set is sorted, not just selected column. 4. […]

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