Tuesday, September 15, 2009

Getting Started with Excel

When a user start Microsoft excel following window is appear.


Standard Toolbar

Standard toolbar is located at the top of screen under Menu Bar


New: Click to create new worksheet OR Click File->New OR Press Ctrl+N to create new worksheet.

Open: Click open new worksheet OR Click File->Open OR Press Ctrl+O to open new work sheet.

Save: Click to save worksheet OR Click File->Save OR Press Ctrl+S to save the worksheet.

Permission: Click OR You can create content with restricted permission using Information Rights Management
only in Microsoft Office Excel 2003.

  • Start Microsoft Office Excel 2003, and create a new workbook.
  • On the File menu, click on Permission, and then click Do Not Distribute.
  • In the Permission dialog box, select the Restrict permission to this <file type> check box.
  • In the Read and Change boxes, type the names or e-mail addresses of people you want to give permission
    to.

    If you want to give all users permission, click Give all users Read access to the right of the Read box, or
    click Give all users Change access to the right of the Change box.

  • Click OK, save your workbook
  • And distribute to the people with permission.

E-Mail: Click to Email your worksheet.

Printer: Click to Print worksheet.
Preview: Click to see Preview worksheet.

Spell Check: Click to check the spellings of words which is use in the worksheet.

Research: Click to research icon, a window will open on the right side of the screen, you can enter a word
on which you want to research.

Copy: Select any text/picture/chart in the excel and then press to copy the text/picture/chart.

Undo: Click to cancel the last action you performed and click the forward to cancel the Undo action.

Insert Hyperlink: Select cell or text and click to insert hyperlink on the text.

Auto Sum: Enter data in the any row or column in the excel worksheet and then click on to calculate the sum of numbers You will find its sum in the next cell:-

Sort: This icon is use to sort data in ascending or descending order.

Chart Wizard: This feature will allow you to create chart/graphs.
Help: Click icon if you need any help related to Microsoft Excel.

Formatting Toolbar

Formatting toolbar is available on the top of screens. There are different quick shortcuts available in this toolbar,
you can add more shortcuts this toolbar.

No comments:

Post a Comment