| Who should attend? | This course is intended for participants who have no previous experience with spreadsheet programs. |
| Prerequisites: | Windows 95 Fundamentals or Windows 98 Fundamentals |
| Performance objectives: | Upon completion of the course, participants will be able to accomplish the following:
- Open and move around in an Excel workbook to learn the navigation skills necessary for creating and using Excel spreadsheets
- Organize columns and rows to accommodate information and edit the contents of cells to organize the information on your worksheet
- Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference
- Use functions to create complex formulas
- Sort information to arrange data in ascending or descending order and use filters to display specific information from a list
- Format cells and worksheet elements to make the worksheet consistent and readable
- Create charts to show data graphically
- Change the page setup and preview the workbook to define how the printed worksheet appears
|
Course Outline
Module 1: Getting Started with Excel 2000
Working with an Existing Workbook
Navigating Worksheets
Selecting Cells
Creating a New Workbook
Module 2: Modifying the Worksheet
Working with Columns and Rows
Resizing Columns and Rows
Adding and Removing Rows and Columns in a Worksheet
Working with Cell Contents
Editing Cell Contents
Copying and Moving Cell Contents
Using AutoFill
Module 3: Using Formulas
Creating and Using Formulas
Entering Formulas
Using AutoFill to Copy Formulas
Using Absolute Cell References
Module 4: Using Functions
Creating and Using Functions
Using the AutoSum Feature
Using Functions to Compare Cell Values
Using the Paste Function Command
Module 5: Sorting and Filtering Data
Sorting Data
Filtering Data
Module 6: Formatting Worksheets
Formatting Cells
Applying Text Formatting
Copying the Formatting to Other Cells
Changing Number Formatting
Formatting Worksheet Elements
Applying Formatting Manually
Applying Formatting Automatically
Module 7: Working with Charts
Creating Charts
Modifying Charts
Resizing and Formatting Charts
Changing the Chart Type
Module 8: Setting Print Options
Changing Page Setup
Modifying Page Setup Settings
Modifying Headers and Footers
Previewing the Workbook
