Excel Is Fun

Highline Excel 2013 Class Video 13

February 12, 2015 0

DESCRIPTION Topics in this video: (00:37) Excel TABLE. (01:04) Total Row. (01:59) AND Criteria with Table Feature. (04:07) OR Criteria with Table Feature. (04:40) AND and OR Criteria with Table Feature. WORKBOOKS

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