### Excel Magic Trick 1165

October 1, 2015

Substitute Final Score If Greater Than Low Score: IF, MIN & SUM Functions DESCRIPTION See how to Add 4 Tests Scores, But Substitute Final Score If Greater Than Low Test Score using the IF, MIN […]

### Excel Magic Trick 1164

September 28, 2015

Average Score After Subtracting Two Lowest: SMALL & Array or AVERAGEIF? DESCRIPTION See how to calculated the average for quiz scores after subtracting the two lowest (00:08) Problem Setup (00:22) Status Bar Trick (00:50) Convert […]

### Excel Magic Trick 1153

August 20, 2015

Unique Count For Name & Date: Array Formula, 2013 PivotTable, More… DESCRIPTION See how to: (00:08) Problem Set Up (00:55) Excel 2013 PivotTable and “Add to Data Model” to get Distinct Count Formula (02:38) Remove […]

### Dueling Excel 034

July 29, 2015

Dynamic Range for Adding Three Methods DESCRIPTION See Mr Excel and excelisfun add a range of values that is dynamic in two directions. The range of values to add changes depending on what you select […]

### Automatically SUM() with ALT + =

July 26, 2015

Quickly SUM an entire row or column by clicking in the first empty cell in the column or row. Use the shortcut keys ALT + = Excel will guess the range you want to sum. […]

### Dueling Excel 027

June 10, 2015

COUNT w More Than 1 Criteria 10 Examples! DESCRIPTION See Mr Excel and excelisfun use 10 different methods for counting with more than 1 criteria. See the functions: SUMPRODUCT w multiplying, SUMPRODUCT w double negative, […]

### Excel 2013 PowerPivot Basics 09

April 9, 2015

DESCRIPTION See how to create 9 different DAX functions or Calculated Fields (00:08) Overview of Reports we need to create (01:05) Calculated Fields Overview (01:58) Calculated Column For Net Revenue using ROUND and RELATED function […]

### Excel 2013 PowerPivot Basics 07

April 7, 2015

DESCRIPTION See how to: (00:17) Calendar Table in Diagram View with no Calculated Fields (00:58) Format Date Column (01:08) Create Calculated Column #01: Month Number using MONTH function. (01:53) Create Calculated Column #02: Month Name […]

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