Excel Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 >>>]

Excel Is Fun

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 >>>]

Excel Is Fun

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 >>>]

Excel Is Fun

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 >>>]

Excel Is Fun

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 >>>]

Excel Is Fun

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 >>>]