2007

Episode 572 – 2007 Filters

               

Excel 2007 adds some amazing new features to the Excel 2003 AutoFilter technology. Learn how you can filter to multiple items, by month or by color. Episode 572 shows you how. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday(…)

Episode 538 – Overlapping 2007 Charts

               

Peter sends in a question that relates back to Episode 444. In that podcast, I showed how to change the gap width in Excel 2003 to have two columns stacked on top of each other. Peter wonders how to do this in Excel 2007. This is a great opportunity to show off a change in(…)

Episode 529 – 2007 Themes

               

Rather than having to customize the color palette, Office 2007 offers 20 built-in color schemes. You can change the document theme in just a few clicks. Episode 529 shows you how. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday(…)

Episode 439 – AutoFilter Woes

               

Jim from Montreal calls in wondering why the AutoFilter dropdowns changed radically in Excel 2007. Episode 439 takes a look at the old AutoFilter, and the new AutoFilter. This blog is the video netcast companion to the books Learn Excel from MrExcel and Excel 2007 Miracle Made Easy. Download a new two minute video every(…)

Episode 438 – Translate

               

Excel 2007 offers an oddity – an icon to do translations between 20 different languages. Episode 438 shows you how. This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Learn Excel from MrExcel