### Excel Magic Trick 1309

July 31, 2017

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

### Highline Excel 2013 Class Video 46

July 28, 2017

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

### Excel Magic Trick 1308

July 27, 2017

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

### Excel Magic Trick 1307

July 24, 2017

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

### Highline Excel 2013 Class Video 45

July 21, 2017

DESCRIPTION Topics in this video: 1. Add Data To Chart with Select Data Button 2. Add Secondary Axis 3. Change Chart Type For Series Values 4. 1 click Combining Chart Types in Excel 2013 5. […]

### Excel Magic Trick 1306

July 20, 2017

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

### Organising Workbooks

July 18, 2017

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

### Excel Magic Trick 1305

July 17, 2017

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

### Display Formulas

July 16, 2017

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

### Excel Magic Trick 1304

July 15, 2017

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