Using PowerPivot for Excel 2010 to create asymmetric pivot tables. An asymmetric pivot table is where you want to report Budget for next year, but Actuals for this year.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Erik asks how do deal with data where each record takes up three rows. Episode 1176 shows you how.

A question from Trinidad about using countif. Episode 1175 shows you how.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

A workbook that was working perfectly in Excel 2003 starts failing in Excel 2007. For no apparent reason, the links will no longer update. Episode 1174 shows why and how to fix this problem forever.

Paula asks how to take a range and turn it on its side. Episode 1173 shows you how.

Today's dueling Excel podcast shows how to do a picture lookup in Excel.

Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.

Szilvia noted a strange anomoly in Excel 2007 pivot tables. Microsoft started appearing at the top of every customer list! Episode 1170 takes a look at this mystery and the solution.