| Who should attend?
| Participants who wish to advance their knowledge with Excel 2000 topics. |
| Prerequisites: | Windows 95 or 98 and basic knowledge of Excel. |
| Performance objectives:
| Upon completion of the course, participants will be able to accomplish the following: - Create and use named cell ranges
- Create workbook templates
- Protect worksheet data
- Use the outline feature
- Work with multiple workbooks
- Copy data between workbooks
- Consolidate workbooks
- Use advanced formulas
- Use multiple-worksheet workbooks
- Use the conditional formatting feature
- Create format styles
- Create charts
- Customize Excel
|
Course Outline
Worksheet Organization
Range Names
Workbook Templates
Worksheet Security
Outlining
Working with Multiple Workbooks
Advanced Formulas
Using the IF Function
Linking Formulas
Consolidating Files
Consolidation Concepts
Copying Data Between Files
Using the Consolidate Command
Multiple-Worksheet Workbooks
Excels Concept of Multiple Worksheets
Managing Worksheets
Grouping Worksheets
Advanced Formatting
Format Tools
Conditional Formatting
AutoFormat
Copying Formats
Styles
Charting
Charting Concepts
Creating a Chart
Chart Objects
Chart Enhancements
Pie Charts
Customizing Excel
Custom Views
Customizing Command Bars
