2007

Both Versions? – 1081 – Learn Excel from MrExcel Podcast

               

Paul writes in with today’s question. Is it possible to keep Excel 2003 and also install Excel 2007 on the same computer? In Episode 1081, I discuss this issue and show a cool way to export a chart as a graphic. This blog is the video podcast companion to the book, Learn Excel 97-2007 from(…)

Episode 833 – Close Excel

               

Back in the good old Excel, you could click the upper “X” in the top right corner to close Excel. Well…that does not work anymore – both of the “X”s will close the workbook. In Episode 833, I will show you the quick way to close out of Excel. (Maybe you work at a dot-com,(…)

Episode 828 – 2007 Macros

               

So, you upgrade to Excel 2007 and your macros stop working. If you are incredibly lucky, it might be a situation where the macro would work, but you need to enable macros. Episode 828 shows where Microsoft hid Macro Security options and what the new words actually mean. This blog is the video podcast companion(…)

Episode 679 – Pivot Source Data

               

Dan asks another Excel 2007 question. How can you re-specify the source data for a pivot table in Excel? It used to be simple to do this in the pivot table wizard, but it is not obvious how to find the pivot table wizard in Excel 2007. In Episode 679, I will show you how(…)

Episode 678 – Page Break Preview

               

Dan asks how to find Page Break Preview in Excel 2007. In Episode 678, I will show you how to find Page Break Preview, but also the improved Page Layout View. 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 Excel from MrExcel