Datasheet

You move to the folder.

3 Click New.

A menu appears.

4 Click Microsoft Excel workbook.

1 Sign in to SkyDrive.

2 Click the folder where you want to store

the file.

Create a File Using Excel’s Web-Based Application

ou can create Excel files with Excel’s Web-based

application. For example, if the computer you are

using does not have Excel, you can sign in to

SkyDrive and create an Excel worksheet.

The look a feel of the Excel Web-based application is the

same as the desktop application. To issue commands, you

use the Ribbon. For the most part, the commands work

exactly as they do in the desktop application. Therefore,

as you are learning Excel, you are also learning the Web-

based application. You will find, however, that the

commands available to you are limited and are not as

sophisticated as they are in the desktop application.

If you upload a file to SkyDrive, you can view most

features. For example, you can upload and view a

PivotTable and the sort and filter buttons are available to

you. However, you cannot create a PivotTable in the

Web-based application. You can view a chart, but you

cannot create a chart. If you edit the data a chart is based

on, the chart will update.

You cannot view comments, shapes, and a few other

objects when using the Web-based application. If a

workbook has any objects that you cannot view, the

Web-based application will warn you when you attempt

to view the workbook. You can view a workbook that has

objects you cannot view in it, but you cannot edit it. If

you need to edit the workbook, use the File menu to

make a copy of the file and then edit the copy.

All the functions that are available to you in Excel are

available to you in the Web-based application.

Create a File Using Excel’s

Web-based Application

03_591604-ch01.indd 1003_591604-ch01.indd 10 5/25/10 12:34 PM5/25/10 12:34 PM