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

Dueling Excel

Dueling Excel 149

July 5, 2017 0

DESCRIPTION See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria: (00:15) PivotTable (01:12) Excel Table feature with a Total Row with […]

Excel Is Fun

Excel Magic Trick 1303

July 3, 2017 0

DESCRIPTION Learn how to to create three different formulas to calculate minimum value greater than zero: (00:13) Introduction (01:00) Before Excel 2010: =MIN(IF(C4:T4 greater0,C4:T4)) (03:05) Excel 2010 – 2013: =AGGREGATE(15,6,C4:T4/(C4:T4 greater0),1) (04:53) Excel 2016 or […]

Excel Is Fun

Excel Magic Trick 1302

June 29, 2017 0

DESCRIPTION Learn how to create an Array Formula to list multiple text modes in a single cell using the functions, MATCH, MODE.MULT, HLOOKUP and the wildcard for “any text” asterisk, “*”, and the new Excel […]

Dueling Excel

Dueling Excel 148

June 28, 2017 0

DESCRIPTION See Mr Excel and excelisfun create a Formula To Deliver TRUE When 3 Out 4 Tests Are Met 1. Boolean Formula with 4 Logical Tests (See Formula Evaluator) 2. SUM function with 4 Logical […]

Excel Is Fun

Excel Magic Trick 1301

June 26, 2017 0

DESCRIPTION Learn how to create an array formula to show a sorted list of modes in a single cell. See the Functions: TEXTJOIN, INDEX, SMALL, MODE.MULT, COUNT, ROW, INDIRECT. Learn about difference (and history) between […]

Excel Is Fun

Highline Excel 2013 Class Video 41

June 23, 2017 0

DESCRIPTION Topics in this video: 1. What do Charts do? Visually portray Quantitative data (number data). Give a quick impression of the number data. Create a picture that can communicate more quickly than just the […]

Dueling Excel

Dueling Excel 147

June 21, 2017 0

DESCRIPTION See Mr Excel and excelisfun Avoid Sheet References From Current Sheet in a formula: 1. View, Arrange Vertically 2. Use Function Argument Dialog Box (Zack Barresse trick) WORKBOOKS