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

DESCRIPTION See how to use the SUMIFS and SUMPRODUCT functions to Calculate Sum Of Amazon And Google Under Each Region. Properly you will learn about OR Logical Tests and AND Logical Tests so that we [Read More >>>]

Excel Is Fun

Excel Magic Trick 1348

DESCRIPTION See how to look up multiple items, retrieve the number associated with the items and add the array of numbers. Examples of SUM Many VLOOKUPs: (00:10) Introduction (01:00) Exact Math Lookup for Adding Multiple [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 1329

DESCRIPTION See how to Clean a data set and then add with two criteria using SUMIFS function and Wildcards with the criteria or Power Query and Group By feature: (00:14) Introduction (01:44) SUMIFS function and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1311

DESCRIPTION See an Array Formula that can extract (from a proper data set) multiple invoice items for one lookup value & show total. See the functions: COUNTIFS, ROW, AGGREGATE, ROWS, INDEX, IF and SUMIFS. See [Read More >>>]

Dueling Excel

Dueling Excel 149

DESCRIPTION See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria: (00:15) PivotTable (01:12) Excel Table feature with a Total Row with [Read More >>>]

Dueling Excel

Dueling Excel 141

DESCRIPTION See Mr Excel and excelisfun in an epic back and forth duel (7 back and forths) try to figure out how to lookup three different items in three different tables and then multiply the [Read More >>>]