Links Failing - 1174

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 Episode 1174 show why and how to fix this problem forever.

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

Turn Data - 1173

Paula asks how to take a range and turn it on its side.
Episode 1173 Episode 1173 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!

Picture Lookup - 1172 - Dueling Excel

Today's dueling Excel podcast shows how to do a picture lookup in Excel.
Episode 1172 Episode 1172 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!

Concatenated Lookup? 1171a - Learn Excel from MrExcel

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.
Episode 1171 Episode 1171 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!

Concatenated Lookup? 1171 - Learn Excel from MrExcel

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.
Episode 1170 Episode 1170 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!

Microsoft First? 1170 Learn Excel Podcast

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

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!

Microsoft First? 1170 Learn Excel Podcast

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

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!