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

Excel Is Fun

Excel Magic Trick 1272

February 20, 2017 0

DESCRIPTION Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods) Learn how to find the max value for each day of the week using the Excel 2010 or later function AGGREGATE. See […]

Excel Is Fun

Excel Magic Trick 1271

February 16, 2017 0

DESCRIPTION Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? Learn how to extract Top 20 values and dates for those values using Formulas when there are no duplicates, Array Formula for […]