MrExcel Excel Videos

Once you have defined an Excel 2007 table, Excel will usually automatically sense when you enter data in adjacent cells and extend the table to include the new cells. Episode 420 takes a look at extending tables, using the Table Tools Design ribbon, and new selection options when you have a table. 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!

John asks if there is a way to automate the process from Episode 322 of adding pop-up pictures to a cell. Today's Episode 1108 takes a look at the VBA code to add pop-up pictures to many cells. 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!

John asks how to take 10 years worth of stock data and convert it to a chart showing months across the bottom and a different line for each year. Episode 1107 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!

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!