Excel Is Fun

Excel Magic Trick 1334

October 12, 2017 0

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

Excel Is Fun

Excel Magic Trick 1325

September 29, 2017 0

DESCRIPTION See how to create a report that require that we find the MIN and MAX Alphanumeric Academic Quarters for each Student ID. See eight different methods including: 1) VLOOKUP, 2) MIN & IF Array […]

Excel Is Fun

Excel Magic Trick 1321

September 25, 2017 0

DESCRIPTION See how to use (00:14) Intro (01:36) MIN & MAX & IF & SEARCH solution (Any Version of Excel) (07:49) INDEX & MATCH & LEFT solution (Any Version of Excel) (08:35) AGGREGATE & ISNUMBER […]

Excel Is Fun

Excel Magic Trick 1285

April 6, 2017 0

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical […]

Excel Is Fun

Excel Magic Trick 1284

April 3, 2017 0

History of Excel Max or Min with Conditions / Criteria (5 Examples) DESCRIPTION Learn about 5 methods to make a Max or Min AND Criteria (AND Logical Test) Calculation with multiple Conditions / Criteria that […]

Excel Is Fun

Excel Magic Trick 1283

March 30, 2017 0

MINIFS & MAXIFS Excel 2016 Functions: Max or Min with Conditions / Criteria DESCRIPTION Learn how to use the MINIFS & MAXIFS functions to find the Minimum and Maximum values in a column based on […]

Excel Is Fun

Excel Magic Trick 1280

March 20, 2017 0

How To Get Latest Excel Updates for Insider Program: Office 365 DESCRIPTION Learn how to download the Insider Program Version of Excel 2016 so you can get new periodic updates with new features such as […]

Excel Is Fun

Excel Magic Trick 1275

March 2, 2017 0

DESCRIPTION Excel Online Office 365 MAXIFS function Learn how to find the biggest value based on a condition or criteria. New features released in these versions: 1. Office 365 Online Excel OR 2. Office 365 […]