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

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

Excel Is Fun

Highline Excel 2016 Class 02

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 and Number Formulas for counting numbers above [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 01

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 Pivot (02:54) Examples of Effective and Efficient [Read More >>>]

Excel Is Fun

Excel Magic Trick 1369

DESCRIPTION See two methods to Count Entered Results For Shift & Date Range using COUNTIFS function: 1. Introduction to a well asked question 2. Create Defined Names 3. Create COUNTIF Formula #1, where we have [Read More >>>]

Excel Is Fun

Excel Magic Trick 1355

DESCRIPTION See how to extract records from a vertical column that contains Parent Names in Bold and Children Names in “Not Bold” and display parent and children records horizontally. Learn about the GET.CELL Excel 4 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1354

DESCRIPTION See how to use RANK.EQ and COUNTIFS functions to create formula to Rank with Two Criteria / Conditions to Rank Football Teams by Total Wins & Division Wins. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1346

DESCRIPTION See how to use formulas to extract records from a Master Table to Sub Tables on Each Excel Worksheets for each product in the Master Table: (00:17) Introduction. Look at Dynamic End Result Solution. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1340

DESCRIPTION See how to create expandable range in an Excel Table as part of a COUNTIFS formula that calculates a running count of names as there are entered into the table: (00:12) Introduction (00:35) Example [Read More >>>]