Dueling Excel

Dueling Excel 144

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1300

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

Excel Is Fun

Highline Excel 2013 Class Video 37

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1299

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

Dueling Excel 143

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1298

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

Excel Is Fun

Excel Magic Trick 1297

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 [Read More >>>]

Dueling Excel

Dueling Excel 142

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

Excel Magic Trick 1296

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