### 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 2016 Class 04

January 24, 2017

WReferences: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Table… DESCRIPTION In this video learn about: (00:04) Download Files (00:30) Introduction to types of References (01:38) Example 1: Not Copying Formula. Goal: Calculate Net Income. (02:09) Example […]

### Excel Magic Trick 1253

December 5, 2016

DESCRIPTION Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH! Learn how to get VLOOKUP to use Column Headers for the col_index-num argument by using the MATCH function. See how to lookup […]

### Excel Magic Trick 1249

November 21, 2016

DESCRIPTION Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail **Note; The word “Database” is used loosely in this video. We use it just to mean we have a dynamic table […]

### Dueling Excel 113

October 14, 2016

Excel Truel: VLOOKUP Fun With Excelisfunner (Isaac 6 Years Old) DESCRIPTION See Excelisfunner, Mr Excel and excelisfun do VLOOKUP and Data Validation List to select a kids name and pull up the bike they ride: […]

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

### Create a Dynamic Data Validation List

May 30, 2015

When you create a Data Validation list in Excel it is locked to the range you select when you first create the list. There are couple of ways of making this list dynamic allowing your […]

### Excel Magic Trick 1127

April 27, 2015

DESCRIPTION See how to automate the tracking of and the Current and Ending Amounts for Budget Categories using The Excel Table feature, Data Validation drop-down list, the SUMIFS function, and Page Setup for printing. (00:08) […]

### Excel Magic Trick 1125

April 25, 2015

DESCRIPTION See how to use Data Validation Custom Formula to verify that dates entered into cells are in current month and are NOT a weekend or holiday. See the AND and NETWORKDAYS.INTL functions as well […]

### Highline Excel 2013 Class Video 18

February 17, 2015

DESCRIPTION Topics in this video: (00:38) Why do we have to know lookup functions? (03:44) VLOOKUP, Exact Match. VLOOKUP delivers a value to the cell. (08:34) What happens if lookup value is not in your […]