### Dueling Excel 013

February 24, 2015

DESCRIPTION See Mr Excel and excelisfun create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set. See the functions SUM, COUNTIF, AVERAGE / IF array formula and the AVERAGEIF new […]

### Highline Excel 2013 Class Video 18

February 17, 2015

DESCRIPTION Topics in this video: (00:38) Why do we have to know lookup functions? (03:44) VLOOKUP, Exact Match. VLOOKUP delivers a value to the cell. (08:34) What happens if lookup value is not in your […]

### Highline Excel 2013 Class Video 15

February 14, 2015

DESCRIPTION Topics in this video: (00:33) IF Function to deliver numbers. (01:37) IF Function to deliver text. (03:19) IF Function to deliver formulas. (05:19) IF Function to deliver functions. (07:51) Nested IFs. (10:24) Null Text […]

### Highline Excel 2013 Class Video 14

February 13, 2015

DESCRIPTION Topics in this video: Analyze customer credit worthiness with logical formulas: (00:23) Analyze customer credit worthiness. (01:42) AND functions. (03:45) IF function and AND function. (06:05) OR function. (07:47) Formula Evaluator (Evaluate Formula) = […]

### Excel Magic Trick 1100

February 7, 2015

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

### Highline Excel 2013 Class Video 02

January 24, 2015

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

### Dueling Excel 007

January 17, 2015

Reverse Lookup VBA or Formula? DESCRIPTION See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA code (Macro) excelisfun uses […]

### Excel Magic Trick 1090

January 14, 2015

DESCRIPTION See how to use the MEDIAN function is unusual ways that allow you to shorten the formula (for last two examples): (00:09) Deliver an OR Criteria Logical Value. (02:15) Payroll Tax calculation where there […]

### Excel Magic Trick 1087

January 11, 2015

DESCRIPTION (08:00) Number Outside range with lower and upper hurdle. Numbers below the lower hurdle OR above the upper hurdle. (01:25) OR function. OR Criteria: only one TRUE is necessary for OR function to deliver […]

### Dueling Excel 005

January 6, 2015

Horizontal Subtotals DESCRIPTION See Mr Excel and excelisfun try and create Horizontal Subtotals for a data set. See the IF, SUM and SUMIF functions as they try to solve this very difficult problem. Also see […]