Excel Is Fun

Highline Excel 2013 Class Video 17

DESCRIPTION Topics in this video: (00:35) Bank Deposit Example: Multiply and then Add in Succession. (02:37) Grade Book Weighted Average Example: Multiply and then Add in Succession. (03:30) Accounting Budget Weighted Average Example: Multiply and [Read More >>>]

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

Highline Excel 2013 Class Video 05

DESCRIPTION (01:09) Relative Reference Example, Net Income Formula. (02:02) Ctrl + Enter to populate a range of cells with a formula. (02:20) Relative and Absolute Reference Example, Increase Price Formula. (04:29) Ctrl + Period ( . [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 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 1089

DESCRIPTION Mr Excel did Month, Year To Date and Variances from data set with GETPIVOTDATA function. See excelisfun do it with Formulas Advanced Filter/Unique List. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1083

DESCRIPTION See how to Add Invoice Amounts Between Start and End Dates using the SUMIFS function, a start and end date in cells, the ampersand (join symbol) and comparative operators in double quotes. WORKBOOKS