### Highline Excel 2013 Class Video 09

January 31, 2015

DESCRIPTION (01:03) Create Defined Name with Name Box. (02:19) Name Manager. Keyboard = Ctrl + F3. (03:23) Create Names From Selection. Keyboard = Ctrl + Shift + F3. (04:12) Enter names into aggregate functions. Paste Name in formulas […]

### Highline Excel 2013 Class Video 08

January 30, 2015

DESCRIPTION Excel Table Formula Nomenclature / Structured References 22 Ex. (00:48) Excel Table feature works for Proper Data Sets. (01:16) Single cell, then keyboard to convert proper data set to Excel Table: Ctrl + T (“List” in […]

### Highline Excel 2013 Class Video 07

January 29, 2015

DESCRIPTION Worksheet & Workbook References, 3-D Cell References (00:20) Worksheet References, Sheet References. (02:08) Workbook References. (07:16) 3-D Cell References. WORKBOOKS

### Highline Excel 2013 Class Video 06

January 28, 2015

Scenarios To Save Sets Of Formula Inputs, Paste Special Trick DESCRIPTION (00:15) What If Analysis. (01:10) Add Formula Inputs As A Scenario using Scenario Manager. (02:29) Alt keyboard for Scenario Manager: Alt, T, E. (03:25) Budget Paste […]

### Highline Excel 2013 Class Video 05

January 27, 2015

Cell References: Relative, Absolute & Mixed (8 Examples) DESCRIPTION (01:09) Relative Reference Example, Net Income Formula. (02:02) Ctrl + Enter to populate a range of cells with a formula. (02:20) Relative and Absolute Reference Example, Increase […]

### Highline Excel 2013 Class Video 04

January 26, 2015

Percentage Increase or Decrease Formula DESCRIPTION Percentage Increase or Decrease Formula WORKBOOKS

### Highline Excel 2013 Class Video 03

January 25, 2015

Order of Precedence in Excel DESCRIPTION Parenthesis ( ) Reference Operators: colon, space, comma Example of colon in range of cells Example of intersection operator Example of comma (union Negation Converts % Exponents Multiplication (*) […]

### Highline Excel 2013 Class Video 02

January 24, 2015

Comprehensive Excel Formula Types & Elements Video 12 Examples DESCRIPTION (00:39) Overview. (03:31) Hours worked formula. Type of Formula: Calculating. Formula Elements: Equal sign, parenthesis, cell reference, math operator, cell reference, parenthesis, math operator, number that […]

### Highline Excel 2013 Class Video 01

January 23, 2015

Back To Basics: Number Format, Keyboards, PivotTables, Formulas DESCRIPTION (0:01:14) Cells, Worksheets, Sheet Tabs and Workbooks. (0:02:14) Navigating Sheets in Excel 2013. (0:03:30) Keyboards. (0:08:51) Number Formatting as Façade. (0:21:36) Types of Data in Excel. (0:23:20) Alignment. (0:27:47) Proper Data Sets, Non-Proper […]

### Excel Magic Trick 1093

January 22, 2015

Extract Date from Middle of Description: Text To Columns or Formula? DESCRIPTION Extract Date from Middle of Description: Text To Columns or Formula: 1. Text To Columns 2. Formula that uses the functions SUBSTITUTE, REPLACE, […]