Dueling Excel

Dueling Excel 026

Randomize Between 2 Dates DESCRIPTION See Mr Excel and excelisfun create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE. See formulas [Read More >>>]

Dueling Excel

Dueling Excel 025

Extract Records NOT Swim or Ski (Filter or Formula?) DESCRIPTION See Mr Excel and excelisfun extract records from database that are NOT Swim or Ski with Filter, Advanced Filter, or Formula using ISNUMBER, LOOKUP and [Read More >>>]

Dueling Excel

Dueling Excel 024

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? [Read More >>>]

Dueling Excel

Dueling Excel 023

Excel 2010 New Functions DESCRIPTION See Mr Excel and excelisfun show off the new Excel 2010 functions: NETWORKINGDAYS.INT, RANK.AVE, PERCENTILE.EXC, CONFIDENCE.T, T.DIST, T.DIST.RT and T.DIST.2T. WORKBOOKS

Dueling Excel

Dueling Excel 022

Conditional Formatting VBA or OFFSET? DESCRIPTION See Mr Excel use VBA code for Conditional formatting and see excelisfun use the OFFSET, MOD and ROWS functions to do Conditional Formatting. WORKBOOKS

Dueling Excel

Dueling Excel 021

Excel 2010 Sparklines (Amazing Cell Charts!!) DESCRIPTION See Mr Excel and excelisfun demonstrate Excel 2010 Sparklines! Sparklines are small cell charts that help to visualize data! Amazing Cell Charts! Great for Skew and Statistics. WORKBOOKS