Excel Is Fun

Excel Magic Trick 1169

October 15, 2015 0

Are Items In Row In Master List? Filter & Conditionally Format To Highlight DESCRIPTION See how to Match Ingredients for a Drink with the data base for all drink ingregients: (00:13) Problem Setup (00:35) MATCH […]

Excel Is Fun

Excel Magic Trick 1164

September 28, 2015 0

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 Is Fun

Excel Magic Trick 1153

August 20, 2015 0

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

Excel 2010 Tutorial For Beginners

Excel 2010 Tutorial For Beginners #5

May 5, 2015 0

DESCRIPTION This updated tutorial shows how to use the following functions: AVERAGE, MAX, MIN and COUNT. The tutorial also shows how to create these functions in a variety of ways, including from the Functions tab […]