Dueling Excel

Dueling Excel 026

June 3, 2015 0

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

Dueling Excel

Dueling Excel 025

May 27, 2015 0

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

Dueling Excel

Dueling Excel 024

May 24, 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? […]

Dueling Excel

Dueling Excel 023

May 23, 2015 0

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

May 22, 2015 0

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

May 21, 2015 0

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

Dueling Excel

Dueling Excel 020

March 20, 2015 0

DESCRIPTION See Mr Excel and excel is fun summarise survey data with a Pivot Table (Grouping & Report Filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function. Adding Counting […]

Dueling Excel

Dueling Excel 019

March 19, 2015 0

DESCRIPTION See Mr Excel and excel is fun try to use VLOOKUP to the left. Mr Excel shows how to use INDEX & MATCH to solve this problem. Excelisfun will use the LOOKUP function to […]

Dueling Excel

Dueling Excel 018

March 18, 2015 0

DESCRIPTION See Mr Excel and excelisfun use the functions: IF, FIND, SEARCH, AND, OR, ISNUMBER, ISERROR, REPLCE and VLOOKUP. See Mr Excel and excel is fun create an IF function formula that use the functions […]

Dueling Excel

Dueling Excel 017

March 17, 2015 0

DESCRIPTION See Mr Excel and excelisfun Create 5 formulas to count times greater than five minutes. Excel functions COUNTIF and TIME. Different syntaxes for the criteria argument in the COUNTIF function WORKBOOKS