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

Excel Is Fun

Excel Magic Trick 1098

DESCRIPTION See how to compare two e-mail lists where one list has extra semi-colons: (00:28) Find and Replace feature to remove semi-colons (Ctrl + H). (01:32) Is in List: MATCH and ISNUMBER functions. (03:20) Is [Read More >>>]

Excel Is Fun

Excel Magic Trick 1097

DESCRIPTION See how to: (00:11) AND and OR Criteria. (01:14) Counting Formula with SUMPRODUCT and COUNTIFS and a function argument array operation (03:16) Adding Formula with SUMPRODUCT and SUMIFS and a function argument array operation [Read More >>>]

Excel Is Fun

Excel Magic Trick 1096

DESCRIPTION See how to extract date from middle of text string with a formula that uses SUBSTITUTE, SEARCH and MID functions. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1095

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

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

Excel Magic Trick 1093

DESCRIPTION Extract Date from Middle of Description: Text To Columns or Formula: 1. Text To Columns 2. Formula that uses the functions SUBSTITUTE, REPLACE, SEARCH and LEFT WORKBOOKS