Dueling Excel

Dueling Excel 024

May 20, 2015 0

VLOOKUP, MAX, Boolean, IF, Which is Best? DESCRIPTION See Mr Excel and excelisfun throw out 5 different methods for calculating a bonus using VLOOKUP, MAX, Boolean, and 2 IF formulas. Which one do you like? […]

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

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 10

April 10, 2015 0

DESCRIPTION Topics in this video: (00:34) Essence of PivotTable (01:08) Overview of Filter Context and CALCULATE (02:30) Look at how Filter Context works on a Calculated Field (03:53) COUNTROWS function to see “Filtered Table” Example […]

Dueling Excel

Dueling Excel 012

February 23, 2015 0

DESCRIPTION See Mr Excel and excelisfun create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest. See the functions MAX, LARGE, SMALL, ROW, and ROWS functions. WORKBOOKS

Dueling Excel

Dueling Excel 006

January 15, 2015 0

DESCRIPTION See Mr Excel and excelisfun try and retrieve the last value in a row. See the INDEX, OFFSET, LOOKUP and MAX functions. WORKBOOKS