We can set security on the file for who can view the file, or who can add/edit or delete files from our folders. And the best part of it all is that it is completely free!
This article will show you the basic functionality of the Excel WebApp including how to create a new WebApp file and upload files from your computer.
To get started you need to sign up for a Windows Live account from www.live.com if you don’t already have one. (You have a Windows Live account if you have a "hotmail" or "live" email address, whether it be .com, .ca, or .somethingelse.)
Accessing your SkyDrive
Once you’ve logged in to your account, mouse over the Windows Live section of the top bar and click SkyDrive:
Now, as Windows Live is telling us, the folder is empty. Why don’t we create a simple Excel file? (Don’t worry, this folder is private, so no one will see any mistakes you make!) Click on “New”, and click “Excel workbook”
In the next screen, give the workbook a name, and click Save.
And voila! You’re now looking at the workbook opened in the Microsoft Office WebApp.
Try it out for a bit. Put in some colour, put some numbers in the cells and write a simple SUM formula to see how it works.
One thing that is important to note here is that there is no need to save the files. It is done automatically for you when you are working in the workbook.
Adding existing files to SkyDrive
When you’re done, click SkyDrive to be taken back to your SkyDrive folders, and browse back into your My Documents folder. Click on “Add Files”:
What’s amazing is that you can even upload the older file format .xls files into SkyDrive and use them in the Webapp. The Excel WebApp converts them to the new .xlsx file format so that you can use them there.
What can you do in the WebApp?
The Excel WebApp isn’t really meant as a power user construction platform. In fact, the amount of things that you can do when working in the web version are quite limited. Things you can do include:
- Basic font selection and formatting
- Font alignment and text wrapping
- Changing number formats
- Sorting and filtering data tables
- Inserting and deleting rows
- Create tables
- Create charts
- Open the file in the full version of Microsoft Excel
What doesn’t work in the Excel WebApp?
You should be aware that there are certain things that the Web App doesn’t render, and even some things that prevent the file from opening in the webapp at all. For a complete list of supported and unsupported features, see http://www.excelguru.ca/forums/showthread.php?108
While it's great that you can view and edit your files on the web, wouldn't it be nice if you could also share them with people in the same way? Well guess what... you can! Have a look at Sharing in the Microsoft Excel WebApp to see how!