Excel Is Fun

Excel Magic Trick 1309

DESCRIPTION Learn how to create an array formula to display a unique list in a single cell. This formula comes from Bill Szysz at YouTube. See the functions: MATCH, ROW, IF and the new Excel [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 46

DESCRIPTION Topics in this video: 1. Formulas for Min and Max values 2. Formulas for Chart Labels 3. COUNTIFS formula to count between upper and lower numbers. BETWEEN Criteria. AND Criteria. 4. Histogram Chart with [Read More >>>]

Excel Is Fun

Excel Magic Trick 1308

DESCRIPTION Learn how to Concatenate Items in Rows & Columns from Two-Way Table with TEXTJOIN (New Excel 2016 Function). WORKBOOKS

Excel Is Fun

Excel Magic Trick 1307

DESCRIPTION Create Logical Formula to conditionally format only certain cell sin cross tabulated report using a Boolean Array Operation inside the SUM function: (00:13) Problem Set Up (01:25) Look at Logical Formula using AND and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1306

DESCRIPTION Learn how to create a formula that simulates a relationship between two tables (like a VLOOKUP Helper Column) to create a Regional Report. See array formula where we see VLOOKUP function and Exact Match [Read More >>>]

WORKBOOKS & WORKSHEETS

Organising Workbooks

Excel workbooks can accumulate very quickly and you can very easily start to lose your way so it is always good practice to be organised from the start. In this article we will provide a [Read More >>>]

Excel Is Fun

Excel Magic Trick 1305

DESCRIPTION Learn how to perform multiple two-way lookups for a cross tabulated table to get multiple sales numbers and then add them using an array formula. Learn how to get INDEX function to deliver an [Read More >>>]

Formulas & Functions

Display Formulas

Display Formulas You Can toggle between Excel’s normal display which shows the results of the formulas in the spreadsheet and a display mode that shows the actual formulas. The keyboard shortcut is Ctrl + tilde [Read More >>>]

Excel Is Fun

Excel Magic Trick 1304

DESCRIPTION Learn how to create an array formula to show a sorted list of modes in a single cell. Learn how to get INDEX function to deliver an array of items using the formula element: [Read More >>>]