Excel Is Fun

Highline Excel 2013 Class Video 12

February 11, 2015 0

DESCRIPTION Topics in this video: (00:32) D Functions. (01:20) AND Criteria for DCOUNT, DSUM, DAVERAGE, DSTDEV (05:50) OR Criteria for DSUM (07:02) AND and OR Criteria for DSUM WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 11

February 10, 2015 0

DESCRIPTION Topics in this video: (00:12) OR Criteria. (00:55) OR Criteria for counting with 2 COUNTIFS (03:40) OR Criteria that does counts and yields incorrect answer (don’t double count) (04:30) OR Criteria for counting with […]

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

Excel Is Fun

Excel Magic Trick 1100

February 7, 2015 0

DESCRIPTION See Two Methods that can return a “Yes” when a Two Way Lookup based on a Column Header and Row Header must lookup items from a second table that presents Dimension (row / column […]

Excel Is Fun

Excel Magic Trick 1099

February 6, 2015 0

DESCRIPTION See how to compare two e-mail lists where one list has extra semi-colons and we want a dynamic formula that can handle periodic data dumps. (00:08) Setup of problem (00:46) Excel Table Feature to […]

Excel Is Fun

Excel Magic Trick 1098

February 5, 2015 0

DESCRIPTION See how to compare two e-mail lists where one list has extra semi-colons: (00:28) Find and Replace feature to remove semi-colons (Ctrl + H). (01:32) Is in List: MATCH and ISNUMBER functions. (03:20) Is […]

Excel Is Fun

Excel Magic Trick 1097

February 4, 2015 0

DESCRIPTION See how to: (00:11) AND and OR Criteria. (01:14) Counting Formula with SUMPRODUCT and COUNTIFS and a function argument array operation (03:16) Adding Formula with SUMPRODUCT and SUMIFS and a function argument array operation […]

Excel Is Fun

Excel Magic Trick 1096

February 3, 2015 0

DESCRIPTION See how to extract date from middle of text string with a formula that uses SUBSTITUTE, SEARCH and MID functions. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1095

February 2, 2015 0

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 1094

February 1, 2015 0

DESCRIPTION See how to lookup all A8 cell references from across many sheets using a wildcards, incomplete sheet names and the INDIRECT function. WORKBOOKS