### Excel Magic Trick 1380

DESCRIPTION See how to extract the incomplete student assignments from a cross tabulated table using Power Query (Get & Transform), a PivotTable and Slicers. WORKBOOKS

### Excel Magic Trick 1379

DESCRIPTION Learn about how the Power Query (Get & Transform) Combine Binary “Expand Button” has changed in the Update January 2017. See a Text File Import From Folder. See the Functions that are automatically created [Read More >>>]

### Excel Magic Trick 1378

DESCRIPTION See how to calculate Average of Customer Total Sales by Product using Excel Formulas, Excel Array Formulas and DAX Measures in Excel Power Pivot: (00:15) Introduction (01:08) 2 Step Solution with SUMIFS and AVERAGEIF [Read More >>>]

### Excel Magic Trick 1377

DESCRIPTION See how to create a formula to list incomplete / missing student assignments: (00:11) Introduction (01:14) Formula to count missing assignments for a particular student using: 1) INDEX & MATCH functions to lookup a [Read More >>>]

### Excel Magic Trick 1376

DESCRIPTION See an amazing formula from Bill Szysz at YouTube to create a Description Column for a transaction table. Thanks to Michale Diamond for the good question. See the formula elements: Shirking Range (Contracting Range), [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 >>>]

### Highline Excel 2016 Class 06

DESCRIPTION In this video learn about All the ways to make conditional Calculations with Formulas in Excel: Built-in Functions like SUMIFS, AND function, OR Function, IS Functions, Array Formulas, D Functions and more: (00:23) Introduction [Read More >>>]