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

Highline Excel 2013 Class Video 09

January 31, 2015 0

DESCRIPTION (01:03) Create Defined Name with Name Box. (02:19) Name Manager. Keyboard = Ctrl + F3. (03:23) Create Names From Selection. Keyboard = Ctrl + Shift + F3. (04:12) Enter names into aggregate functions. Paste Name in formulas […]

Excel Is Fun

Highline Excel 2013 Class Video 08

January 30, 2015 0

DESCRIPTION Excel Table Formula Nomenclature / Structured References 22 Ex. (00:48) Excel Table feature works for Proper Data Sets. (01:16) Single cell, then keyboard to convert proper data set to Excel Table: Ctrl + T (“List” in […]

Excel Is Fun

Highline Excel 2013 Class Video 07

January 29, 2015 0

DESCRIPTION Worksheet & Workbook References, 3-D Cell References (00:20) Worksheet References, Sheet References. (02:08) Workbook References. (07:16) 3-D Cell References. WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 06

January 28, 2015 0

Scenarios To Save Sets Of Formula Inputs, Paste Special Trick DESCRIPTION (00:15) What If Analysis. (01:10) Add Formula Inputs As A Scenario using Scenario Manager. (02:29) Alt keyboard for Scenario Manager: Alt, T, E. (03:25) Budget Paste […]

Excel Is Fun

Highline Excel 2013 Class Video 05

January 27, 2015 0

Cell References: Relative, Absolute & Mixed (8 Examples) 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 […]

Excel Is Fun

Highline Excel 2013 Class Video 03

January 25, 2015 0

Order of Precedence in Excel DESCRIPTION Parenthesis ( ) Reference Operators: colon, space, comma Example of colon in range of cells Example of intersection operator Example of comma (union Negation Converts % Exponents Multiplication (*) […]

Excel Is Fun

Highline Excel 2013 Class Video 02

January 24, 2015 0

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