Dueling Excel

Dueling Excel 005

January 6, 2015 0

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

Dueling Excel

Dueling Excel 004

January 5, 2015 0

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

January 4, 2015 0

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

Dueling Excel

Dueling Excel 002

January 3, 2015 0

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

Dueling Excel

Dueling Excel 001

January 2, 2015 0

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

Excel Is Fun

Excel Magic Trick 1082

January 1, 2015 2

Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data DESCRIPTION See how to add every other column using 1 or 4 formulas: (00:08 min) Manual method using SUM. See how […]