Excel Is Fun

Excel Magic Trick 1341

December 11, 2017 0

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

Dueling Excel 114

October 19, 2016 0

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

Excel Is Fun

Highline Excel 2016 Class 02

July 24, 2016 0

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

Excel Is Fun

Excel Magic Trick 1164

September 28, 2015 0

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

Excel Magic Trick 1117

April 17, 2015 0

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

Dueling Excel 013

February 24, 2015 0

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

Excel Is Fun

Highline Excel 2013 Class Video 10

February 9, 2015 0

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