Training Course: Microsoft Excel 2000 - Intermediate

Training Course Summary:

First, this one-day course guides participants through Excel’s charting features. Participants learn how to create and edit charts; modify chart options; format chart objects; work with multiple worksheets and workbooks, and use financial and logical functions. Students also gain hands-on experience using styles, custom formats, and conditional formatting and preparing workbooks for publication on the World Wide Web.

Pre-Requisites:

Create basic spreadsheets
Navigate within Excel
Select and edit data
Perform basic formatting
Open, close and save files
Create basic formulas – AutoSum
Work with named cell ranges
Use the Autofill feature
Use Insert Function to create built-in functions
Work with absolute references
Browse the Internet

Training Course Overview/Content:

Create and edit charts.
Format chart objects.
Use styles, custom formats, and conditional formatting.
Prepare workbooks for publication on the WWW
Use financial and logical functions.
Work with multiple worksheets and workbooks.
Modify chart options.