Microsoft Excel 2002: Level 2
Course Specifications
Software Version: Excel 2002
Course Length: 6 Hours
Course Description
Spreadsheets are used to create, revise, and save documents for printing and future retrieval. This course is the Second in a series of three Microsoft Excel 2002 courses. It will provide you with the basic concepts required to produce basic spreadsheets.
Prerequisites
You should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. One of the following courses or equivalent knowledge is required:
Basic Typing Skills
Windows XP Introduction
Windows XP Level 1 & 2
Excel Level 1
Performance-
Upon successful completion of this course, students will be able to:
Creating and Applying Templates
Creating and Modifying Charts
Working with Graphic Objects
Calculating with Advanced Formulas
Sorting
and Filtering Data
Course Content
EL2-
Create a Workbook from a Template
Create a Custom Template
Working with Comments
Create a Hyperlink
Use Web-
EL2-
Create a Chart
Format Chart Items
Change the Chart Type
Create a Diagram
EL2-
Insert Graphics Create AutoShapes
Format Graphic Objects
Change the Order of Graphic Objects
Group Graphic Objects
Move, Copy, and Resize Graphic Objects
EL2-
Create and Apply a Name for a Range of Cells
Calculate Across
Worksheets
Calculate with Date and Time Functions
Calculate with Financial Functions
Calculate with Statistical Functions
Calculate with Lookup and Reference Functions
Calculate with Logical Functions
EL2-
Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets
Copy a Workbook
