Microsoft Excel 2000 Introduction
| Duration: | 1 day |
| Prerequisite: | Basic knowledge of the windows environment, basic keyboard skills |
| Course Materials: | Course manual with CD containing exercises, 136 pages |
| 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: | This class covers the basic concepts of Microsoft Excel 2000 with working with charts, formulas, and functions. The manual is recognized as a Microsoft Approved Study Guide for the Microsoft Office Specialist Program Certification Exam. The manual is also a great reference for after the class. |
Getting Started with Excel 2000
Define Spreadsheet Software
Start Excel 2000
View the Excel window
Open and Save a Workbook
Enter Labels and Values
Name and Move a Sheet
Preview and Print a Worksheet
Get Help
Close a Workbook and Exit Excel
Building and Editing Worksheets
Planning and Designing a Worksheet
Editing Cell Entries and Working with Ranges
Entering Formulas
Introducing Excel Functions
Coping and Moving Cell Entries
Understanding Relative and Absolute Cell References
Copying Formulas with Relative Cell References
Copying Formulas with Absolute Cell References
Formatting a Worksheet
Formatting Values
Using Fonts and Font Sizes
Changing Attributes and Alignment of Labels
Adjusting Column Widths
Inserting and Deleting Rows and Columns
Applying Colors, Patterns, and Borders
Using Conditional Formatting
Checking Spelling
Working with Charts
Planning and Designing a Chart
Creating a Chart
Moving and Resizing a Chart
Editing a Chart
Formatting a Chart
Enhancing a Chart
Annotating and Drawing on a Chart
Previewing and Printing a Charting
Working with Formulas and Functions
Creating a Formula with Several Operators
Using Names in a Formula
Generating Multiple Totals with AutoSum
Using Dates in Calculations
Building a Conditional Formula with the If Function
Using Statistical Functions
Calculating Payments with the PMT function
Displaying and Print Formula Contents