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!
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!
Transcript of the video:
Hey, welcome to the MrExcel netcast.
I'm Bill Jelen.
Well here we are.
It's finally release day CompUSA opened at midnight last night selling copies of the new office.
Now, I just got a call from your IT manager, and he says that you're scheduled for an upgrade in 2014.
Isn't that the way it always is I have a wild suggestion for you.
Sunday papers came out, and it required practically a PhD to figure out which version of office to get.
I mean there's the home and student, standard professional, ultimate small business, or just straight excel 2007.
If you're curious about excel 2007 and you want to try and use it at work or at home.
Go with this version here the Microsoft Home and Student 2007.
You're able to install it on a few different PC's and it gives you Excel, Word, PowerPoint and a great new program called OneNote.
Now, It doesn't give you Outlook, but the cool thing about this version. Is that you're able to run it side-by-side with Excel 2003 and Excel 2007.
So, you have Excel 2003 at work go ahead and buy this install it beautiful thing is you still have Excel 2003 when it's crunch time, but when you need more than 65,000 rows or you need to create a really jaw dropping new chart or something to really wow the manager.
You can slip over to Excel 2007, you'll also love OneNote.
I'll talk about OneNote later later this week.
Let me just show you briefly, what OneNote does, OneNote is basically like a huge notebook.
You can put things basically anywhere on the page you can make it into to-do lists or any kind of reminders from OneNote, you can insert a screen clipping.
So, let's say I'm out here surfing the web And I see something interesting I can go back to OneNote say, Insert, Screen Clipping, shoot a screenshot of whatever it is that I see gets pasted right to onenote complete with the url in the time that I captured the screen capture also captures audio and video great little product.
So this home and student edition in the us is selling for 129 Dollars on Amazon that's only twenty dollars more than excel 2007 stand alone as an upgrade great version for you couple of things to watch out for though running these side by side.
I found two problems that happen in Excel 2003 and they're probably, minor problems.
If you use VBA a lot and use something called ADO Active Data Objects, that can cause a problem if you install excel 2007 on your machine.
Or if you have a VBA, Macro, that creates a chart and then exports the chart as a graphic to your hard drive that breaks in Excel 2003 once you've installed excel 2007.
If you don't use either of those, you should be good to go.
I've used six different versions of Excel 2007 now on eight different machines, and those are the only two problems we've run into.
So, it seems like a really good way to get your feet wet with Excel 2007 even if the IT department isn't going to upgrade you.
Just run them side by side on this home and student edition doesn't have Outlook unfortunately.
The interesting piece about that though is Outlook 2003 and 2007 are the only two components of office that can't run on the same machine.
So, it's actually perfect on the home and student edition just has Excel, Word and PowerPoint.
Hey now, if you did happen to upgrade today let me just give you the first big tip about excel 2007, when you first install the thing.
This little icon up here in the upper left hand corner is going to start to flash.
It flashes exactly one time and they really hope that you click on it because the most important things are hiding behind that icon that used to have the word file on it, but somewhere along the line when they were finishing the art they took the word file off and just left that office icon it's insane.
That all the important things like New, Open, Print, Save, are hidden behind that icon with no word.
Hey, there you have it. Stop back tomorrow for another podcast from MrExcel.
I'm Bill Jelen.
Well here we are.
It's finally release day CompUSA opened at midnight last night selling copies of the new office.
Now, I just got a call from your IT manager, and he says that you're scheduled for an upgrade in 2014.
Isn't that the way it always is I have a wild suggestion for you.
Sunday papers came out, and it required practically a PhD to figure out which version of office to get.
I mean there's the home and student, standard professional, ultimate small business, or just straight excel 2007.
If you're curious about excel 2007 and you want to try and use it at work or at home.
Go with this version here the Microsoft Home and Student 2007.
You're able to install it on a few different PC's and it gives you Excel, Word, PowerPoint and a great new program called OneNote.
Now, It doesn't give you Outlook, but the cool thing about this version. Is that you're able to run it side-by-side with Excel 2003 and Excel 2007.
So, you have Excel 2003 at work go ahead and buy this install it beautiful thing is you still have Excel 2003 when it's crunch time, but when you need more than 65,000 rows or you need to create a really jaw dropping new chart or something to really wow the manager.
You can slip over to Excel 2007, you'll also love OneNote.
I'll talk about OneNote later later this week.
Let me just show you briefly, what OneNote does, OneNote is basically like a huge notebook.
You can put things basically anywhere on the page you can make it into to-do lists or any kind of reminders from OneNote, you can insert a screen clipping.
So, let's say I'm out here surfing the web And I see something interesting I can go back to OneNote say, Insert, Screen Clipping, shoot a screenshot of whatever it is that I see gets pasted right to onenote complete with the url in the time that I captured the screen capture also captures audio and video great little product.
So this home and student edition in the us is selling for 129 Dollars on Amazon that's only twenty dollars more than excel 2007 stand alone as an upgrade great version for you couple of things to watch out for though running these side by side.
I found two problems that happen in Excel 2003 and they're probably, minor problems.
If you use VBA a lot and use something called ADO Active Data Objects, that can cause a problem if you install excel 2007 on your machine.
Or if you have a VBA, Macro, that creates a chart and then exports the chart as a graphic to your hard drive that breaks in Excel 2003 once you've installed excel 2007.
If you don't use either of those, you should be good to go.
I've used six different versions of Excel 2007 now on eight different machines, and those are the only two problems we've run into.
So, it seems like a really good way to get your feet wet with Excel 2007 even if the IT department isn't going to upgrade you.
Just run them side by side on this home and student edition doesn't have Outlook unfortunately.
The interesting piece about that though is Outlook 2003 and 2007 are the only two components of office that can't run on the same machine.
So, it's actually perfect on the home and student edition just has Excel, Word and PowerPoint.
Hey now, if you did happen to upgrade today let me just give you the first big tip about excel 2007, when you first install the thing.
This little icon up here in the upper left hand corner is going to start to flash.
It flashes exactly one time and they really hope that you click on it because the most important things are hiding behind that icon that used to have the word file on it, but somewhere along the line when they were finishing the art they took the word file off and just left that office icon it's insane.
That all the important things like New, Open, Print, Save, are hidden behind that icon with no word.
Hey, there you have it. Stop back tomorrow for another podcast from MrExcel.
