Excel Is Fun

Excel Magic Trick 1085

January 9, 2015 0

DESCRIPTION What if you are not allowed to have a helper columns to lookup Price and Region with VLOOKUP? And you need to calculate Total Revenue by Region? This video shows how to create a […]

Excel Is Fun

Excel Magic Trick 1084

January 8, 2015 0

DESCRIPTION See how to add every other column with the help of ISODD and the ISEVEN functions. Also SUMPRODUCT and COLUMN functions. Array Formula that does not require Ctrl + Shift + Enter because we […]

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