Excel

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(…)

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(…)

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(…)

Learn Excel from MrExcel