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

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

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

Highline Excel 2013 Class Video 35

May 12, 2017 0

DESCRIPTION Topics in this video: 1. 3 Reports with Formulas. 2. What is a PivotTable do? a. Summarise data b. “Calculation with criteria” c. Create Reports that contain calculations with conditions/criteria 3. Proper Data Set. […]

Excel Is Fun

Excel Magic Trick 1294

May 8, 2017 0

DESCRIPTION If you do not have a Proper Data Set Lookup Table, but rather a Rectangular Improper Lookup Table, learn how to create a single cell formula to Score Myers-Briggs Assessment (Test). This amazing formula […]

Excel Is Fun

Highline Excel 2013 Class Video 32

April 21, 2017 0

DESCRIPTION Topics in this video: 1. Essential definition of array formula: operation on an array of items rather than single items. 2. Example of operation on single items: subtracting 2 cells. 3. Example of operation […]

Excel Is Fun

Excel Magic Trick 1279

March 16, 2017 0

DESCRIPTION Learn how to create a New Running Count (Cumulative Count) Formula After Each Zero Value using the IF and SUM functions. Trick from Bill Szysz at YouTube. See that the SUM Function ignores Text […]

Dueling Excel

Dueling Excel 133

March 15, 2017 0

DESCRIPTION See Mr Excel and excelisfun use two methods to sum the three biggest values that match three criteria (3 conditions) 1. Advanced Filter and LARGE and MAX value 2. SUM and LARGE functions with […]

Dueling Excel

Dueling Excel 126

January 25, 2017 0

DESCRIPTION SUM Daily Totals from Text Dates with Text Day Criteria See Mr Excel and excelisfun use two methods to 1. Add up daily sales from a template that is not setup properly: multiple columns […]

Dueling Excel

Dueling Excel 123

January 4, 2017 0

DESCRIPTION Lookup Column and then Add With Criteria See Mr Excel and excelisfun use two methods to lookup a column based on a date and then add all the values for the North Region 1. […]