Today, in Episode #1526, Bill shows us how to not only view workbooks on the iPad, but also how we can make changes to those workbooks - on the iPad! Follow along with Bill to see how it it done!
...This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
...This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Transcript of the video:
MrExcel podcast is sponsored by Easy- XL.
Learn excel from MrExcel podcast.
Episode # 1526 - Excel on the iPad Hey, welcome back to MrExcel netcast. I'm Bill Jelen from MrExcel.
So, the MVP summit, couple weeks ago, and one of the things I learned was just an offhand comment that is incredible.
All right. So, here we have excel on the laptop.
Here, we have an iPad. Fine. And I'm doing a lot on the iPad. I browse on the iPad, I do my gmail on the iPad, I use the iPad for everything, but I don't like numbers on the iPad.
They can't create new Excel files. I can create old Excel files. It's clunky. I just don't like numbers.
I'm sorry, I want Excel on the iPad.
Today, I'm going to give you Excel on the iPad.
Here's what we do. You start with your spreadsheet here in excel 2010.
If you're in excel 2007, you'll have to go direct to the SkyDrive.
From Excel 2010, we do File Save & Send Save to the web, and then you're going to sign in with your SkyDrive account.
If you don't have a SkyDrive account, go to SkyDrive.live.com and sign up.
It's free.
Create some folders, and I have a folder here called Public, and I've shared that with everyone. So, you can go try this out yourself.
And we'll do Save As, to save the file in that folder.
All right.
Now, we're going to close it, here in excel.
By the way, the SkyDrive does show up then in your recent places.
All right, so you can get right back to it just like, all right, just like a hard drive. All right, now.
Okay, so now, here is the really really, non-intuitive part.
You're on the iPad, you go to SkyDrive.live.com and you're going to be able to see those files that you uploaded.
The piece that no one knows, and I learned this from an Excel PM named Harrison.
You have to scroll down, to the bottom of the browser window, and there is a link there called PC site.
Right. That link is the magic link.
Right now, you're looking at the mobile version of SkyDrive, and the mobile version will not let you edit the Excel files.
Click PC site.
Then all of a sudden, you're on the real version of SkyDrive and now the editing works. All right.
This setting is not persistent.
Almost every day, you're going to have to go back in and choose PC site.
There's a hack to get it to be more persistent, but then all of your web sites would not give you the mobile site.
And that's going to be more hassle than it's worth.
Alright, so let's switch over and take a look at the iPad now.
Okay, so now, here we are on the iPad.
This is the SkyDrive. I'm in the public folder, and at this point, we can still use the stretch to make it larger.
I'm going to click on MachineReading. Which is the file that I saved from the desktop.
Oh, this is perfect. This is beautiful.
Okay. Now, this is exactly what happens if you don't click PC site. All right.
So here we are, we see the results, the charts not showing up.
And there's no way to edit in browser. You see there's no edit in browser, so I'm going to go back.
Okay, so here we are, back at the main drive. I'm focusing down here at the bottom.
See that link right there, PC site. That's the important one.
Choose PC site.
And now, we have a completely different experience.
Look, you have the File menu up there, Open in Excel, Edit in Browser and the chart is rendering.
So, let's give it a try. Edit in Browser Choose a cell. So, I'll click here in cell A11.
All right now, to actually enter anything in that cell, to get the keyboard, click on the formula bar.
Keyboard appears.
Let's enter time of 9:45 Return.
Click in the formula bar.
Use the keyboard. 117.1 Return.
All right, and our chart updates.
Now, here's the wild wild thing.
When you're using this mobile version of Excel, Excel for the web, the limitation of having one person edit the spreadsheet at a time, has gone away.
All right, so I'm going to take a look at the PC here.
So, on the PC screen, you can see a browser. This is internet explorer here, showing the exact same spreadsheet in edit mode, that we are seeing on the iPad.
All right now, I'm going to put the webcam on the iPad, and you can see on the regular screen, I'm going to enter 9:55 I use the right arrow key and there it just appear in the iPad. Did you see that? That's crazy!
Anyone can be editing, you edit on either side, and it shows up in the other place.
Absolutely wild!
There's about a 3 or 4 second lag there, as it gets saved up to the SkyDrive, and then the other device sees it.
So hey, I think this is pretty darn cool.
I want to say thanks to Harrison out of Microsoft, for showing me that PC site.
Again that PC site link at the bottom.
That's the amazing, like that enables all of this to work.
Using Excel on the SkyDrive, now edit your spreadsheets on the iPad, very very cool.
Well hey, I want to thank you for stopping by.
See you next time, for another netcast from MrExcel.
Learn excel from MrExcel podcast.
Episode # 1526 - Excel on the iPad Hey, welcome back to MrExcel netcast. I'm Bill Jelen from MrExcel.
So, the MVP summit, couple weeks ago, and one of the things I learned was just an offhand comment that is incredible.
All right. So, here we have excel on the laptop.
Here, we have an iPad. Fine. And I'm doing a lot on the iPad. I browse on the iPad, I do my gmail on the iPad, I use the iPad for everything, but I don't like numbers on the iPad.
They can't create new Excel files. I can create old Excel files. It's clunky. I just don't like numbers.
I'm sorry, I want Excel on the iPad.
Today, I'm going to give you Excel on the iPad.
Here's what we do. You start with your spreadsheet here in excel 2010.
If you're in excel 2007, you'll have to go direct to the SkyDrive.
From Excel 2010, we do File Save & Send Save to the web, and then you're going to sign in with your SkyDrive account.
If you don't have a SkyDrive account, go to SkyDrive.live.com and sign up.
It's free.
Create some folders, and I have a folder here called Public, and I've shared that with everyone. So, you can go try this out yourself.
And we'll do Save As, to save the file in that folder.
All right.
Now, we're going to close it, here in excel.
By the way, the SkyDrive does show up then in your recent places.
All right, so you can get right back to it just like, all right, just like a hard drive. All right, now.
Okay, so now, here is the really really, non-intuitive part.
You're on the iPad, you go to SkyDrive.live.com and you're going to be able to see those files that you uploaded.
The piece that no one knows, and I learned this from an Excel PM named Harrison.
You have to scroll down, to the bottom of the browser window, and there is a link there called PC site.
Right. That link is the magic link.
Right now, you're looking at the mobile version of SkyDrive, and the mobile version will not let you edit the Excel files.
Click PC site.
Then all of a sudden, you're on the real version of SkyDrive and now the editing works. All right.
This setting is not persistent.
Almost every day, you're going to have to go back in and choose PC site.
There's a hack to get it to be more persistent, but then all of your web sites would not give you the mobile site.
And that's going to be more hassle than it's worth.
Alright, so let's switch over and take a look at the iPad now.
Okay, so now, here we are on the iPad.
This is the SkyDrive. I'm in the public folder, and at this point, we can still use the stretch to make it larger.
I'm going to click on MachineReading. Which is the file that I saved from the desktop.
Oh, this is perfect. This is beautiful.
Okay. Now, this is exactly what happens if you don't click PC site. All right.
So here we are, we see the results, the charts not showing up.
And there's no way to edit in browser. You see there's no edit in browser, so I'm going to go back.
Okay, so here we are, back at the main drive. I'm focusing down here at the bottom.
See that link right there, PC site. That's the important one.
Choose PC site.
And now, we have a completely different experience.
Look, you have the File menu up there, Open in Excel, Edit in Browser and the chart is rendering.
So, let's give it a try. Edit in Browser Choose a cell. So, I'll click here in cell A11.
All right now, to actually enter anything in that cell, to get the keyboard, click on the formula bar.
Keyboard appears.
Let's enter time of 9:45 Return.
Click in the formula bar.
Use the keyboard. 117.1 Return.
All right, and our chart updates.
Now, here's the wild wild thing.
When you're using this mobile version of Excel, Excel for the web, the limitation of having one person edit the spreadsheet at a time, has gone away.
All right, so I'm going to take a look at the PC here.
So, on the PC screen, you can see a browser. This is internet explorer here, showing the exact same spreadsheet in edit mode, that we are seeing on the iPad.
All right now, I'm going to put the webcam on the iPad, and you can see on the regular screen, I'm going to enter 9:55 I use the right arrow key and there it just appear in the iPad. Did you see that? That's crazy!
Anyone can be editing, you edit on either side, and it shows up in the other place.
Absolutely wild!
There's about a 3 or 4 second lag there, as it gets saved up to the SkyDrive, and then the other device sees it.
So hey, I think this is pretty darn cool.
I want to say thanks to Harrison out of Microsoft, for showing me that PC site.
Again that PC site link at the bottom.
That's the amazing, like that enables all of this to work.
Using Excel on the SkyDrive, now edit your spreadsheets on the iPad, very very cool.
Well hey, I want to thank you for stopping by.
See you next time, for another netcast from MrExcel.
