### Excel Magic Trick 1341

December 11, 2017

DESCRIPTION See how to use Power Query, a PivotTable and an Excel Formulas to calculate to calculating Average and Standard Deviation with Criteria: (00:14) Introduction & Setup (01:28) Array Formula for calculating Average and Standard […]

### Dueling Excel 114

October 19, 2016

Cross Tabulated AVERAGING 3 Criteria: PivotTable or AVERAGEIFS DESCRIPTION See Mr Excel and excelisfun use two methods to create Cross Tabulated AVERAGING with Three Criteria: Pivot Table or AVERAGEIFS function. See Grouping Numbers in PivotTable […]

### Highline Excel 2016 Class 02

July 24, 2016

Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excelâ€™s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text […]

October 24, 2015

WORKBOOKS

### Excel Magic Trick 1164

September 28, 2015

Average Score After Subtracting Two Lowest: SMALL & Array or AVERAGEIF? DESCRIPTION See how to calculated the average for quiz scores after subtracting the two lowest (00:08) Problem Setup (00:22) Status Bar Trick (00:50) Convert […]

### Excel Magic Trick 1117

April 17, 2015

DESCRIPTION See how to calculate an average for 12 different samples when numbers are in a single column: (00:25) PivotTable (average in one condition/criteria) (02:22) AVERAGEIFS Function (average in one condition/criteria) (05:37) AVERAGE, ROWS and […]

### Dueling Excel 013

February 24, 2015

DESCRIPTION See Mr Excel and excelisfun create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set. See the functions SUM, COUNTIF, AVERAGE / IF array formula and the AVERAGEIF new […]

### Highline Excel 2013 Class Video 10

February 9, 2015

DESCRIPTION Topics in this video: (00:34) AND Criteria for SUMIFS, COUNTIFS, AVERAGEIFS (05:18) DSUM (07:53) SUMIFS with 3 criteria. (10:36) Use COUNTIFS or COUNTIF for 1 condition? (12:35) Use SUMIFS or SUMTIF for 1 condition? […]