Here is a very useful Excel 2003 Reference Guide, at Ohio University, that deals with and demonstrates many features of Excel which will help you organize your data into rows and columns, worksheets, and help you work with and manage that data. It also helps you create formulas, perform data analysis, and do mathematical calculations quickly. Topics that are explained in this Excel tutorial reference include: working with workbooks, worksheets and cells, displaying toolbars, deleting a row or column, merging and moving cells, pasting linked data, page setup options, templates, autofill, creating a formula, inserting graphics, working with functions, and creating charts and graphs.
Microsoft Excel 2003 Reference Guide 26 Pages, 1.08 Mb
- What is Excel 2003?
- Excel Workbooks, Worksheets, and Cells
- Displaying Toolbars
- Changing Options
- Changing Screen Magnification
- Controlling Column Width
- Controlling Row Height
- Inserting Cells
- Deleting Cells
- Inserting a Column
- Inserting a Row
- Deleting a Column
- Deleting a Row
- Selecting with the SHIFT key
- Selecting with the CTRL key
- Selecting a Range Of Cells
- Merge and Center Cells
- Moving Cells through Cutting
- Moving Cells Drag and Drop
- Moving Cells using Copy and Paste
- The Office Clipboard
- Pasting Linked Data
- Use another Sheet in the Workbook
- Rename a Worksheet
- Moving a Worksheet
- Page Setup Options
- Print Preview
- Use Help
- Templates
- AutoFill
- AutoSum
- Auto Calculate
- Creating a Formula
- Function
- Hiding Columns and Rows
- Defining Styles
- Chart Wizard
- Insert a Picture from a File
- Data Analysis




