Microsoft Excel 2002 Level 1
| Duration: | 1 day |
| Prerequisite: | Basic knowledge of the windows environment, basic keyboard skills |
| Course Materials: | Course manual (084200S3) |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | Students will learn how to create a basic worksheet by entering text and values, work with cells and cell data, perform calculations on data by using formulas and functions, change the appearance of worksheet data by using a variety of formatting techniques, work with multiple worksheets, create and modify charts, and print a worksheet. |
Getting Started
Identify What You Can Do with Excel
Enter Data in a Worksheet
Edit Data
Change the Appearance of Data
Save a Workbook
Obtain Help
Editing Your Worksheet
Moving Data to Other Cells
Copy Data to Other Cells
Fill Cells with a Series of Data
Insert and Delete Rows and Columns
Undo and Redo an Entry
Find and Replace Numbers
Enter Data in a Range
Verify Data in a Range
Performing Calculations
Sum a Range of Data
Use a Built-in Function
Copy a Formula
Create an Absolute Reference
Formatting
Specify Number Formats
Create a Custom Number Format
Change Font Size and Type
Apply Styles
Add Borders and Color to Cells
Find and Replace Formats
Change Column Width and Row Height
Align Cell Contents
Merge and Center Cells
Apply an AutoFormat
Working with Multiple Worksheets
Format Worksheet Tabs
Reposition Worksheets in a Workbook
Copy Worksheets
Change the Number of Worksheets
Creating and Modifying Charts
Create a Chart
Modify Chart Items
Format a Chart
Change the Chart Type
Setting Page Display and Printing Options
Freeze Rows and Columns
Set Print Title
Set Page Margins
Create a Header and Footer
Change Page Orientation
Insert and Remove Page Breaks
Print a Range