Look Who it Was Random video

Excel - Master Excel: Upgrade Tips, Features, and Running Excel 2003 Side-by-Side - Episode 433

218 views · Published 18 September 2009 · 4:05 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Master Excel: Upgrade Tips, Features, and Running Excel 2003 Side-by-Side.

Welcome to the MrExcel netcast! I'm Bill Jelen and today we're talking about the highly anticipated release of Excel 2007. CompUSA opened at midnight last night to sell copies of the new Office, and I'm sure many of you are eager to upgrade. But before you do, I have a suggestion for you.

If you're scheduled for an upgrade in 2014, why not try out Excel 2007 now? With so many different versions of Office available, it can be overwhelming to figure out which one to get. But if you're primarily interested in Excel, I recommend the Microsoft Home and Student 2007 version. Not only does it give you Excel, Word, and PowerPoint, but it also includes a great new program called OneNote.

OneNote is like a huge notebook where you can organize your thoughts, to-do lists, and reminders. You can even insert screen clippings from the web or capture audio and video. And the best part? You can run this version of Excel side-by-side with Excel 2003. So if you're used to the older version at work, you can still have it available when needed, but also have the added features of Excel 2007 at your fingertips.

The Home and Student edition is currently selling for $129 on Amazon, which is only $20 more than the stand-alone Excel 2007 upgrade. However, there are a few things to watch out for when running these versions side-by-side. If you use VBA and ADO, or if you have a macro that creates a chart and exports it as a graphic, you may run into some minor issues. But for the most part, this is a great way to get your feet wet with Excel 2007, even if your IT department isn't planning on upgrading you anytime soon.

Now, if you did happen to upgrade today, here's a quick tip for you. When you first install Excel 2007, you'll notice a flashing icon in the upper left-hand corner. This is where all the important functions like New, Open, Print, and Save are hidden. It's a bit confusing since the word "file" has been removed from the icon, but just remember to click on it and you'll have access to all the essential features.

Thanks for tuning in to today's podcast. Be sure to check back tomorrow for more Excel tips and tricks from MrExcel. And don't forget to subscribe to our channel for more helpful videos. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Introduction to MrExcel netcast
(00:23) Upgrade suggestion for Excel 2007
(00:34) Recommendation for Microsoft Home and Student 2007
(01:03) Benefits of using Excel 2007 alongside Excel 2003
(01:29) Overview of OneNote
(02:05) Pricing and potential issues with Home and Student edition
(03:03) Tip for using Excel 2007
(03:39) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Excel 2003
Excel 2007 problems
Excel tips
Microsoft Home and Student 2007
Office icon in Excel 2007
Office upgrade 2014
OneNote
Outlook 2003 and 2007
VBA and ADO Active Data Objects

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152621/



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!

More from this channel