Wednesday, November 25, 2009

Sixth Lesson of Ms-Excel

Spelling check the spelling in your workbook using this feature

Auto correct excel will automatically correct command typing errors. You can set option from

Share workbook allows multiple rests to use your worksheet. Simultaneously. Useful if your document is stored on network

Protection protect your worksheets or entire workbook with password and other features

Track changes allows you to highlight revisions your worksheet

Auditing us the auditing tools to check the structure of any formulas you

Customize allows you to customize toolbars menus and key board commands

Options allows you to change general, viewing and editing settings for your

Sort allows you to sort selected information (into alphabetical order for example)

Validation allows you to restrict what kind of information is entered into a cell

Table creates a table of data set by values and formulas

Template wizard creates a template and database form and excel workbook

Group and out line enables you to group columns or rows together and create outlines of more worksheet

Get external date this allows you to bring information from other kinds of files into your kinds of files into your worksheet

Auto correct common spelling and typing mistakes can be automatically corrected for you to save time. For example incorrect use of the caps lock key and the capitulations choose the auto correct command from the tools menu.

No comments:

Post a Comment