Excel Is Fun

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

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

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

Excel Magic Trick 1375

DESCRIPTION See how to: (00:01) How to Navigate to sections of this video (00:46) Introduction (01:32) What is an OR Logical Test using OR Criteria (02:30) Fundamental Problem with an OR Logical Test on Two [Read More >>>]

Excel Is Fun

Excel Magic Trick 1372

DESCRIPTION See how to Get the Total for each employee when the Employee Name column has many empty cells and the “TOTAL” is in a row without an employee name. See five methods: (00:13) Introduction [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 05

DESCRIPTION In this video learn about: (00:04) Download Files (00:24) Aggregate vs. Array Calculations & Define Array (02:55) Define Array Formulas (05:49) Example of non-array formula. Standard Formula: Formulas that calculate a single answer. Goal: [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

Excel Magic Trick 1341

DESCRIPTION See how to use Power Query, a PivotTable and an Excel Formulas to calculate to calculating Average and Standard Deviation with Criteria: (00:14) Introduction & Setup (01:28) Array Formula for calculating Average and Standard [Read More >>>]

Excel Is Fun

Excel Magic Trick 1334

DESCRIPTION See how to use Power Query (Get & Transform) and a set of Formulas to create a report that Adds Total Units for Each Product, Finds Max Units Sold for Each Product, and Lists [Read More >>>]

Excel Is Fun

Excel Magic Trick 1326

DESCRIPTION See how to Conditionally Format Text Modes with: PivotTable, Array Formula or Power Query: (00:17) Introduction (01:52) PivotTable & MATCH formula. (08:23) Array Formula with the functions: MATCH, IF, ISTEXT, MODE.MULT, N, N(IF,1 formula [Read More >>>]