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