Highline Excel 2016 Class 16

DESCRIPTION In this video learn about Conditional Formatting Topics : (00:16) Introduction (00:43) Built-in Feature: Cell Contains (03:28) Logical Formula: Highlight Row (Record) where cell contains a value. (10:00) Built-in Feature: Below Average (10:55) Logical [Read More >>>]

Highline Excel 2016 Class 15

DESCRIPTION In this video learn about: (00:28) Define Charts. What do Charts do? (01:12) Effective Charts: No Chart Junk. Example of Chart Junk. (02:54) Types of Charts: 11 different chart types. (06:55) Terminology for Chart [Read More >>>]

Highline Excel 2016 Class 14

DESCRIPTION In this video learn about how to create a Regional Sales Report with: (00:13) Discussion about VLOOKUP or PowerPivot Data Model Relationships. (01:57) Copy Sheets with Keyboard and Mouse. (02:43) VLOOKUP Example to create [Read More >>>]

Highline Excel 2016 Class 13

DESCRIPTION In this video learn about how to create a formula that can take One Lookup Value and Return Multiple Items. Learn about the INDEX and AGGREGATE Array Formula. See the functions: with INDEX, AGGREGATE, [Read More >>>]

Highline Excel 2016 Class 12

DESCRIPTION In this video learn about: (00:13) Introduction (00:30) Helper Column Solution with Join Operator and VLOOKUP (03:31) Array Formula with: INDEX and MATCH functions and a Join Array Operations. This formula requires Ctrl + [Read More >>>]

Highline Excel 2016 Class 11

DESCRIPTION In this video learn about: (00:12) Introduction (00:51) Data Validation List. VLOOKUP, Exact Match. IF & ISBLANK functions. Goal: Create Invoice. (09:43) HLOOKUP with Exact Match Lookup. Goal: Lookup Tyrone’s Phone Number. Horizontal Lookup [Read More >>>]

Highline Excel 2016 Class 10

DESCRIPTION In this video learn about: (00:16) Introduction (00:46) Data Validation to allow only whole numbers between an upper and lower limit (02:12) Create an Input Message for your Data Validation (02:31) Error Message with [Read More >>>]

Highline Excel 2016 Class 09

DESCRIPTION In this video learn about: (00:12) Introduction (00:22) Reminder of Date Math and Serial Number Dates and Number Formatting (02:14) TODAY and NOW functions to show the current date and time (03:13) EOMONTH function [Read More >>>]

Highline Excel 2016 Class 08

DESCRIPTION In this video learn about: (00:12) Introduction (00:46) Text Formulas: Ampersand to Join Items together (01:38) Text Functions to extract partial text items from a larger text item. (02:57) Extract State with LEFT function [Read More >>>]

Highline Excel 2016 Class 07

DESCRIPTION In this video learn about: (00:11) Introduction to these new Excel 2016 Functions (01:13) MINIFS function to find minimum value with conditions or criteria. (03:23) MAXIFS function to find max value with conditions or [Read More >>>]