MrExcel Excel Videos

David from Australia sends in a cool trick for adding a timestamp to a spreadsheet. Episode 1106 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!

Creating a pivot table from dates where daily dates stretch across the top of your data set. This episode compares the pain of adding multiple value fields to a pivot table versus unpivoting using multiple consolidation range pivot tables. Fabien sends in an intriguing pivot table question. I show one mildly acceptable way to solve the problem using the existing data and then a way to spin the data to make the problem easier to solve. Episode 1105 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!

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 workday to learn a tip for both versions of Excel!

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!

Did you ever notice the status bar below your spreadsheet? Select some numbers in Excel and the totals will appear in the status bar. In Episode 437, learn how to change the number shown in the status bar, and also the new enhancements in Excel 2007. 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 workday to learn a tip for both versions of Excel!

Use the Goal Seek function to back into an answer. Episode 436 shows you how. 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 workday to learn a tip for both versions of Excel!

The Home & Student edition of Office 2007 includes a product that may be new to you - OneNote 2007. Episode 435 takes a quick tour of OneNote. 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!

As you dive in to get all the great features in Excel 2007, you will be frustrated trying to find things on the ribbon interface. The MrExcel tip card will solve those problems. Download the card for free. Episode 434 shows you how. This blog is the video netcast companion to the 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!

Office 2007 debuted at midnight last night. In Episode 433 Bill discusses the new release, the various packages available, and how to run Excel 2003 and Excel 2007 side by side. 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!