### Dueling Excel 144

May 31, 2017

DESCRIPTION See Isaac Excelisfunner Girvin, Bill Mr Excel Jelen and Mike excelisfun Girvin have mirror fun in Excel. Copy stuff like it was a mirror with: Relative Cell Reference Paste Special Picture Link View New […]

### Excel Magic Trick 1300

May 29, 2017

DESCRIPTION Learn how to list all modes in single cell with TEXTJOIN & MODE.MULT. learn about the three different mode functions: MODE, MODE.SNGL and MODE.MULT. WORKBOOKS

### Highline Excel 2013 Class Video 37

May 26, 2017

DESCRIPTION Topics in this video: 1. Advanced Filter: Cross Between Filter and Database Functions. 2. Advanced Filter 3 Areas: Criteria Area Data Set Extract Area: Be sure to keep area below CLEAR!!!! 3. Advanced Filter […]

### Excel Magic Trick 1299

May 25, 2017

DESCRIPTION Learn how to: create Automatic Calendar Table in Data Model, New in Excel 2016. This ability was not in earlier versions of Excel. WORKBOOKS

### Dueling Excel 143

May 24, 2017

DESCRIPTION See Mr Excel and excelisfun create two solutions for looking up and calculating a percentage commission that does not exceed the max amount for some of the products. See the functions: VLOOKUP, MIN, and […]

### Excel Magic Trick 1298

May 22, 2017

DESCRIPTION Learn how to Group By Date in Power Pivot Data Model, New in Excel 2016. This ability was not in earlier versions of Excel. WORKBOOKS

### Highline Excel 2013 Class Video 36

May 19, 2017

DESCRIPTION Topics in this video: 1. Sort to Extract Records. 2. Filter for extracting records. 3. Filter Toggle Keyboard: Ctrl + Shift + L or Alt, D, F, F. 4. Single Criteria Data Extract. 5. […]

### Excel Magic Trick 1297

May 18, 2017

DESCRIPTION Learn how to Score Myers-Briggs Test from a Rectangular (Improper Lookup Table) with COUNTIFS Function with a Join Array Operation to create the OR Criteria Array that goes into the criteria argument& then the […]

### Dueling Excel 142

May 17, 2017

DESCRIPTION See Mr Excel and excelisfun do an average calculation with one condition: 1. PivotTable 2. Array Formula that uses AVERAGE and IF functions 3. SUMIF and COUNTIF together WORKBOOKS

### Excel Magic Trick 1296

May 15, 2017

DESCRIPTION Learn how to Score Myers-Briggs Test from a Rectangular (Improper Lookup Table) with COUNTIFS Function with OR Criteria & SUMPRODUCT function. WORKBOOKS