Excel Is Fun

Highline Excel 2013 Class Video 08

DESCRIPTION (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 2003 use Ctrl + L). (01:50) TableTools, Design Ribbon [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 07

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

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 Special Trick : Paste Special Operations and Values to increase [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 03

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 (*) and Division (/), left to [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

Highline Excel 2013 Class Video 01

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1100

DESCRIPTION See Two Methods that can return a “Yes” when a Two Way Lookup based on a Column Header and Row Header must lookup items from a second table that presents Dimension (row / column [Read More >>>]

Excel Is Fun

Excel Magic Trick 1099

DESCRIPTION See how to compare two e-mail lists where one list has extra semi-colons and we want a dynamic formula that can handle periodic data dumps. (00:08) Setup of problem (00:46) Excel Table Feature to [Read More >>>]