### Highline Excel 2016 Class 03-02 Filter

September 20, 2016

Highline Excel 2016 Professional Class taught by Michael excelisfun Girvin WORKBOOKS Highline Excel 2016 Class 03 Start Workbook Highline Excel 2016 Class 03 Finished Workbook Highline Excel 2016 Class 03 2015 Data Highline Excel 2016 […]

### Excel Magic Trick 1229

September 12, 2016

DESCRIPTION Extract Items NOT in List 1: Conditional Format Unique Values & Sort by Color Learn how to Extract Items From List 2 that are NOT in List 1 by using Conditional Format Unique Values, […]

### Excel Magic Trick 1226

September 1, 2016

DESCRIPTION Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) Learn how to Compare 2 Lists, Extract Items In List 2 That are NOT in List 1: (00:12) […]

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

### Highline Excel 2016 Class 01

July 16, 2016

Excel Fundamentals: Efficiency, Data, Data Sets, Formatting DESCRIPTION In this video learn about these Excel Fundamentals for Excel Highline Excel 2016 Class: (00:33) Prerequisites for class (01:04) Excel Professional 2016 (01:50) Install Com Add-in Power […]

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

### Excel Magic Trick 1124

April 24, 2015

DESCRIPTION See how to Conditional Format Weekends & Holidays using the NETWORKDAYS.INTL & NOT functions. Conditionally format serial dates for weekends and holidays. Conditional Formatting. Format Conditionally. Logical Formulas. Format holidays and weekends. WORKBOOKS

### Excel 2013 PowerPivot Basics 12

April 12, 2015

DESCRIPTION See how to create Student GPA Grade by Class for each High School, with each report on a new sheet, automatically using a PivotTable and Show Report Filter Pages. This feature is NOT available […]

### Excel 2013 PowerPivot Basics 06

April 6, 2015

DESCRIPTION See how to Import, Filter, Edit Data From Access, Excel, Text Files into one Data Model, including importing new tables and columns and deleting tables after an existing connection is established: (00:28) goal of […]

### Excel Magic Trick 1112

March 10, 2015

DESCRIPTION (01:06) Group By Date In PivotTable Error (Cannot group that selection error) (01:42) Text To Columns To Convert Text Dates To Dates (02:53) Text To Columns Fatal Error (Microsoft Excel has stopped working error) […]