Excel 2010 offers a cool trick that anyone with a browser can try out right now. You can view and edit your Excel workbooks in a browser. Episode 1189 shows you how to try it out.
Transcript of the video:
MrExcel podcast is brought to you by “Easy-XL”!
Did you see it?
Did you see my twitter announcement?
May 12th, that's the date Microsoft's going to release Office 2010!
May 12th, time is flying, I need to review all those chapters.
Today's podcast, I'm not actually going to be in Excel, I’m going to be in a browser.
I want you to go out to Windows Live, sign up for a Windows Live account, come over here to More, choose something called SkyDrive, 5 GB of storage on your SkyDrive.
I want you to upload an Excel 2007 file to your SkyDrive, OK, and then once it's up there, you'll see something kind of cool, where you can go in and say that you want to View, right?
And you can actually see your spreadsheet on a browser.
It is pretty amazing what you can do when you choose View.
I have a Pivot table here, I have a chart, I have some slicers, watch what happens when I change the slicers?
This is all happening in a browser, not using Excel at all, the Pivot table updates, the chart updates.
Now what you need to do here is, you need to poke around, and you're going to see a link to something about a beta version, where you can actually edit this.
Alright, so it's not obvious, you have to click around and find it, but then you're going to be able to do something called Edit in Browser.
This is brand-new in Office 2010, you can get to Word, PowerPoint, and Excel web versions of those.
So you can take data from Excel, save it up to your SkyDrive.
And then when you're at home, even if you don't have Excel at home, you can come in here, Edit in Browser, and you can do basic data entry and create new formulas.
And so =2^3, and it calculates, it's very, very cool.
Now you don't have everything, you have the Home tab, you have the Insert tab, and a few things on the File tab.
Basically, as soon as you do an entry, it automatically saves, so where's the Save button?
Well it saves every time.
You could go, and you can even have multiple people editing on the web at the same time, so something that we just really have not been able to do at all in Excel for quite some time.
It is amazing just how Excel-like this is, this is a browser, I'm in a browser, and I'm using something that feels an awful lot like Excel.
Now I can't create new Pivot tables here, I can't create new array formulas here, but the Pivot tables that already exist work, the array formulas that already exist work, I can use the 360 functions or whatever.
So this is extremely cool, something new that's coming in Excel 2010.
And if you poke around out there, set up a Live account, and then set up a SkyDrive, get an Excel file up there, you'll eventually see that link that will let you try this out.
Now, if you get Windows Live, go ahead and try and connect to me, pub@mrexcel.com.
I have a series of documents that I've shared out here, Public Excel Web Tests, and PublicReadOnly.
If you go into Excel web test, you can actually edit the guest book, and go in, just say that you were there, or try out some of these other things that I have out there.
A very, very cool feature coming in Excel 2010, seamless integration with Excel 2010, being able to do File, Save, Save to the SkyDrive, you get 5 GB up there.
Now I've heard some people outside of the US, they're worried, because this is, basically, saving encrypted data crossing the border into the US, which is a violation of, you know, some US treaty, or something like that.
But if you're in the US, very cool way to go, the data can be shared with either everyone like this folder or, you know, Private, or only for people that you invite.
Check it out, a great new tool in Office 2010.
Thanks for stopping by, and we'll see you next time for another netcast from MrExcel!
Did you see it?
Did you see my twitter announcement?
May 12th, that's the date Microsoft's going to release Office 2010!
May 12th, time is flying, I need to review all those chapters.
Today's podcast, I'm not actually going to be in Excel, I’m going to be in a browser.
I want you to go out to Windows Live, sign up for a Windows Live account, come over here to More, choose something called SkyDrive, 5 GB of storage on your SkyDrive.
I want you to upload an Excel 2007 file to your SkyDrive, OK, and then once it's up there, you'll see something kind of cool, where you can go in and say that you want to View, right?
And you can actually see your spreadsheet on a browser.
It is pretty amazing what you can do when you choose View.
I have a Pivot table here, I have a chart, I have some slicers, watch what happens when I change the slicers?
This is all happening in a browser, not using Excel at all, the Pivot table updates, the chart updates.
Now what you need to do here is, you need to poke around, and you're going to see a link to something about a beta version, where you can actually edit this.
Alright, so it's not obvious, you have to click around and find it, but then you're going to be able to do something called Edit in Browser.
This is brand-new in Office 2010, you can get to Word, PowerPoint, and Excel web versions of those.
So you can take data from Excel, save it up to your SkyDrive.
And then when you're at home, even if you don't have Excel at home, you can come in here, Edit in Browser, and you can do basic data entry and create new formulas.
And so =2^3, and it calculates, it's very, very cool.
Now you don't have everything, you have the Home tab, you have the Insert tab, and a few things on the File tab.
Basically, as soon as you do an entry, it automatically saves, so where's the Save button?
Well it saves every time.
You could go, and you can even have multiple people editing on the web at the same time, so something that we just really have not been able to do at all in Excel for quite some time.
It is amazing just how Excel-like this is, this is a browser, I'm in a browser, and I'm using something that feels an awful lot like Excel.
Now I can't create new Pivot tables here, I can't create new array formulas here, but the Pivot tables that already exist work, the array formulas that already exist work, I can use the 360 functions or whatever.
So this is extremely cool, something new that's coming in Excel 2010.
And if you poke around out there, set up a Live account, and then set up a SkyDrive, get an Excel file up there, you'll eventually see that link that will let you try this out.
Now, if you get Windows Live, go ahead and try and connect to me, pub@mrexcel.com.
I have a series of documents that I've shared out here, Public Excel Web Tests, and PublicReadOnly.
If you go into Excel web test, you can actually edit the guest book, and go in, just say that you were there, or try out some of these other things that I have out there.
A very, very cool feature coming in Excel 2010, seamless integration with Excel 2010, being able to do File, Save, Save to the SkyDrive, you get 5 GB up there.
Now I've heard some people outside of the US, they're worried, because this is, basically, saving encrypted data crossing the border into the US, which is a violation of, you know, some US treaty, or something like that.
But if you're in the US, very cool way to go, the data can be shared with either everyone like this folder or, you know, Private, or only for people that you invite.
Check it out, a great new tool in Office 2010.
Thanks for stopping by, and we'll see you next time for another netcast from MrExcel!
