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

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