Excel Is Fun

Excel Magic Trick 1282

March 27, 2017 0

Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function DESCRIPTION See how to use the amazing new Excel 2016 function TEXTJOIN to Find Multiple Lookup Values In First Colum AND return Multiple Items […]

Excel Is Fun

Excel Magic Trick 1281

March 23, 2017 0

TEXTJOIN & CONCAT New Excel 2016 functions (14 Examples of Joining Items) DESCRIPTION Learn about the new Excel 2016 functions TEXTJOIN and CONCAT. Compare and contrast these newer functions to the older methods of using […]

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 1279

March 16, 2017 0

DESCRIPTION Learn how to create a New Running Count (Cumulative Count) Formula After Each Zero Value using the IF and SUM functions. Trick from Bill Szysz at YouTube. See that the SUM Function ignores Text […]

Excel Is Fun

Excel Magic Trick 1278

March 13, 2017 0

Extract Colour From Description (Text String) Learn how to Extract Colour From Description (Text String) using LOOKUP & SEARCH functions and the Big Number 2^15 in an Array Formula. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1277

March 9, 2017 0

DESCRIPTION Learn how to to Sort Logical Values Alphabetically: false, FALSE, False, true, TRUE, True, and mixed single word text. See how using a space at the end of text will work, but will cause […]

Excel Is Fun

Excel Magic Trick 1276

March 6, 2017 0

DESCRIPTION Impossible: Excel Online Absolute Cell References? How do you make a Cell Reference Absolute in Excel Online? WORKBOOKS

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

Excel Is Fun

Excel Magic Trick 1274

February 27, 2017 0

DESCRIPTION Learn how to avoid long formula with multiple IF Functions by using the lookup functions: VLOOKUP or LOOKUP. Also see a “Partial Text Lookup” Situation where we have to lookup just part of a […]

Excel Is Fun

Excel Magic Trick 1273

February 23, 2017 0

DESCRIPTION Web Query To Get Super Bowl Data, PivotTable Count Teams with Most Wins Learn how to use the Get External Data Feature, Web Query to get Super Bowl data. Then make two PivotTables to […]