Excel Is Fun

Excel Magic Trick 1307

July 24, 2017 0

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

Excel Is Fun

Highline Excel 2013 Class Video 45

July 21, 2017 0

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 Is Fun

Excel Magic Trick 1306

July 20, 2017 0

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

WORKBOOKS & WORKSHEETS

Organising Workbooks

July 18, 2017 0

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 Is Fun

Excel Magic Trick 1305

July 17, 2017 0

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

Formulas & Functions

Display Formulas

July 16, 2017 1

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 Is Fun

Excel Magic Trick 1304

July 15, 2017 0

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

Dueling Excel

Dueling Excel 150

July 12, 2017 0

DESCRIPTION See Mr Excel and excelisfun lookup the first value in column A when the first value in B is greater than 100: (00:13) Method 1: IF function and array operation inside MIN function inside […]

Excel Is Fun

Highline Excel 2013 Class Video 43

July 7, 2017 0

DESCRIPTION Topics in this video: 1. Keyboard for chart on Active Sheet = Alt + F1 2. Keyboard for chart on New Sheet = F11 3. Set Default Chart in Excel 2013 WORKBOOKS