Excel 2000/XP Intermediate Version 10.0
Prerequisites Duration 1 day(s)
Working with Worksheets
Viewing, Renaming, and Color-coding Worksheets
Editing a Group
Manipulating Worksheets
Creating Linked Formulas
Using 3-D References
Protecting Workbooks and Worksheets
Working with Functions
Creating and Using Named Ranges
Creating a Relative Name
Using Custom Zoom
Using Functions
Working with Insert Function
Using Financial Functions
Using Date Functions
Working with Formatting and Data Validation
Using Conditional Formatting
Using Data Validation
Creating and Using Custom Formats
Working with Auditing and Error Checking Tools
Creating Charts
Using the Chart Wizard
Modifying Charts - Overview
Changing the Chart Type
Changing a Chart's Location and Size
Changing Chart Options
Adding and Removing Data Series
Changing Worksheet Data Using a Chart
Using the Range Finder with Charts
Working with Charts
Using Text Boxes
Formatting Chart Elements - Overview
Formatting Chart Text
Formatting Chart Objects
Printing Charts
Creating Advanced Charts
Working with Three-Dimensional Charts
Creating a Combination Chart
Creating Complex Pie Charts
Creating a Pictograph
Using List Features
Using a List - Overview
Using AutoComplete
Sorting a List
Using the Data Form
Filtering a List Using AutoFilter
Using Styles and Templates
Creating and Using Styles
Merging Styles
Using Templates
Creating Templates
WEX2XP ONLINE - 4/9/2002 0:00:00
