Dueling Excel

Dueling Excel 005

DESCRIPTION See Mr Excel and excelisfun try and create Horizontal Subtotals for a data set. See the IF, SUM and SUMIF functions as they try to solve this very difficult problem. Also see Conditional Formatting [Read More >>>]

Dueling Excel

Dueling Excel 006

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

Dueling Excel

Dueling Excel 004

DESCRIPTION See Mr Excel and excelisfun create charts to compare data values: 1) Bar Chart 2) Stacked Column Chart 3) Trendline to predict future data values WORKBOOKS

Dueling Excel

Dueling Excel 003

DESCRIPTION See Mr Excel and excelisfun demonstrate three methods to count words that contain the letter D: 1) Filter & SUBTOTAL 2) Table & SUBTOTAL 3) COUNTIF and criteria syntax Count with criteria conditions. Use [Read More >>>]

Dueling Excel

Dueling Excel 002

DESCRIPTION See Mr Excel and excelisfun demonstrate two methods to subtract 35% from a column of values: Mr Excel: Create formula for remaining percentage (1 + decrease), copy remaining percentage, Paste Special, Operations Multiply, Values. [Read More >>>]

Dueling Excel

Dueling Excel 001

DESCRIPTION See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array: Mr Excel: MATCH and INDEX functions in one formula to retrieve a value from the intersection [Read More >>>]