Dueling Excel

Dueling Excel 030

Count Bills for Money Transaction DESCRIPTION See Mr Excel and excelisfun create formula that will take a dollar amount and count how many $100 bills, how many $50 bills, etc. are needed for the minimum [Read More >>>]

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

Excel Is Fun

Excel Magic Trick 1114

DESCRIPTION See how to create formula for Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 1, 18443 2, 18444 2, 18445 2, 18446 3…. See formula that uses the functions ROWS, INT and the [Read More >>>]