Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 04

DESCRIPTION See two examples of Array Formulas and two examples of PowerPivot DAX formulas that count unique values in a column (Distinct Count) and compare and contrast: (00:09) Array Formula For counting unique values using [Read More >>>]

Dueling Excel

Dueling Excel 017

DESCRIPTION See Mr Excel and excelisfun Create 5 formulas to count times greater than five minutes. Excel functions COUNTIF and TIME. Different syntaxes for the criteria argument in the COUNTIF function WORKBOOKS

Dueling Excel

Dueling Excel 015

DESCRIPTION See Mr Excel use a Pivot Table with Grouping and a Count function to create a Frequency Distribution. See excel is fun use the FREQUENCY function (upper limit is included in count) to create [Read More >>>]

Dueling Excel

Dueling Excel 013

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

Dueling Excel

Dueling Excel 003

DESCRIPTION See Mr Excel and excelisfun demonstrate three methods to count words that contain the letter D: 1) Filter & SUBTOTAL 2) Table & SUBTOTAL 3) COUNTIF and criteria syntax Count with criteria conditions. Use [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 10

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

Excel Is Fun

Highline Excel 2013 Class Video 02

Comprehensive Excel Formula Types & Elements Video 12 Examples DESCRIPTION (00:39) Overview. (03:31) Hours worked formula. Type of Formula: Calculating. Formula Elements: Equal sign, parenthesis, cell reference, math operator, cell reference, parenthesis, math operator, number that [Read More >>>]

Excel Is Fun

Excel Magic Trick 1095

DESCRIPTION See how to count Doubles, triples, quadruples, etc. using FREQUENCY function rather than COUNTIF. FREQUENCY is much faster calculating. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1092

DESCRIPTION See how to build an array formula that uses the COUNTIF & SUMPRODUCT functions as well as a function argument array operation, a comparative array operation and a math array operation in a single [Read More >>>]