Learn Excel from MrExcel Video Podcast

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

Erik asks how do deal with data where each record takes up three rows. Episode 1176 shows you how. This blog is the video podcast companion ...

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

A workbook that was working perfectly in Excel 2003 starts failing in Excel 2007. For no apparent reason, the links will no longer update. ...

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 ...

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

Ahmed asks how to do a lookup that only looks at the text portion of the lookup value. Mike and Bill compare methods in this Dueling Excel ...

Khader asks how to concatenate three cells so that they appear on three lines in a new cell. Episode 1168 shows you how.

Building on Teo's question from yesterday, Bill expands the technique to generate an array of 50 sequential numbers instead of typing that ...

Teo asks how to sum up the three largest values in a range. Episode 1166 shows you how.

In today's dueling podcast, we need to look up a value in one of three different tables depending on the product selected. Mike and Bill ...