Saturday, January 28, 2012

Excel 2003 Menu Bar Tutorial


1. Click 'File' to view options that are related to file operations. You can create new files, open files, save files, print files and change file properties from this menu.
2. Click 'Edit' to view common options for performing Excel edits. This menu contains options that allow you to copy and paste data, find and replace text strings and delete cells or cell contents.
3. Click 'View' to change the Excel 2003 display. You can use this menu to change the Excel toolbars, document headers and footers and change the screen view.
4. Click 'Insert' to add something new to your document. You can use this menu to add blank cells, columns or rows. You can also add formula functions and graphics to a cell via this menu.
5. Click 'Format' to change the appearance of elements in your document. You can change the format of individual cells, rows, columns and entire worksheets using the functions under this menu heading.
6. Click 'Tools' to access a menu of tools that you can use to augment the contents of your workbook. The Tools menu includes entries for spell-checking, sharing your document and protecting cells with a password. The menu also contains entries for changing Excel options and editing the Excel AutoCorrect feature.
7. Click 'Data' to perform categorical edits on your worksheet's data. You can sort data, create forms and filters, insert pivot tables and import external data to your spreadsheet.
8. Click 'Window' to change the active window, freeze panes in your spreadsheet or split your view of the spreadsheet into multiple parts.
9. Click 'Help' to view Excel 2003 help documentation.
10. Click the 'Double Arrow' icon at the bottom of any menu to view all menu items. When you first click on the menu, the menu only displays items that you have used recently.

Blogger news