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

Excel Is Fun

Highline Excel 2013 Class Video 01

January 23, 2015 0

Back To Basics: Number Format, Keyboards, PivotTables, Formulas DESCRIPTION (0:01:14) Cells, Worksheets, Sheet Tabs and Workbooks. (0:02:14) Navigating Sheets in Excel 2013. (0:03:30) Keyboards. (0:08:51) Number Formatting as Façade. (0:21:36) Types of Data in Excel. (0:23:20) Alignment. (0:27:47) Proper Data Sets, Non-Proper […]