Excel

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

               

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 Episode 1169. …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(…)

Coercing Number Array 1167 – Learn Excel Podcast

               

Building on Teo’s question from yesterday, Bill expands the technique to generate an array of 50 sequential numbers instead of typing that whole range out. Episode 1167 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(…)

Sum Big 3 – 1166 – Learn Excel from MrExcel Podcast

               

Teo asks how to sum up the three largest values in a range. Episode 1166 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!

Lookup 3 Tables – 1165 – Dueling Excel Podcast

               

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 show many ways to solve the problem in Episode 1165. …This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute(…)

Learn Excel from MrExcel