Microsoft Excel Tutorial - 01

Ovoya Academy

Excel Tutorial - 01

Setting up a Workbook to open a workbook:

1.   Click the Microsoft Office Button, and then click Open.

2. Navigate to the folder that contains the workbook you want to open.

3.  Click the workbook, and then click Open.

To create a new workbook:

1. Click the Microsoft Office Button, and then click New.

2. In the New Workbook window, click Blank Workbook.

3. Click Create.

To save a workbook:

1. On the Quick Access Toolbar, click the Save button.

2.  Type a name for the file.

3. Click Save.

 To set file properties:

1.   Click the Microsoft Office Button, point to Prepare, and then click Properties.

2.    In the Document Information Panel, click the type of properties you want to set in the Property Views and Options list.

3.    Add information describing your file, and then close the Document Information Panel.

To define custom properties:

1.    Click the Microsoft Office Button, point to Prepare, and then click Properties.

2.  In the Property Views and Options list, click Advanced Properties.

3.  In the Properties dialog box, click the Custom tab.

4.  In the Name box, type a property name, select the type of data contained in the property,         and then type a value for the property.

 5. Click Add, and then click OK.

Written by:

Mohmmad Younus