Dueling Excel

Dueling Excel 005

January 6, 2015 0

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

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