Excel Is Fun

Highline Excel 2013 Class Video 14

DESCRIPTION Topics in this video: Analyze customer credit worthiness with logical formulas: (00:23) Analyze customer credit worthiness. (01:42) AND functions. (03:45) IF function and AND function. (06:05) OR function. (07:47) Formula Evaluator (Evaluate Formula) = [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 13

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

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

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

Excel Magic Trick 1097

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

Excel Is Fun

Excel Magic Trick 1086

DESCRIPTION 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch & Merged Cell Trouble See how to:  (00:11 min) Create formula to lookup a value from a table with three criteria: INDEX and MATCH and [Read More >>>]