Mentor for Excel 2000
Table of Contents

Overview

Mentor Overview

• Use Mentor for Microsoft Excel 2000

Excel Overview

• What is Microsoft Excel 2000?
• Learn what's new in Excel 2000
• What are a Workbook and a Worksheet?
• Explore the Excel 2000 Workbook Window

Working in Excel 2000

Using Excel 2000 Tools

• Introduction to the Menus
• Introduction to the Toolbars
• Use the Standard Toolbar
• Use the Formatting Toolbar
• Display Toolbars on Separate Lines
• Hide or Display Other Toolbars
• Move a Toolbar
• Create a Floating Toolbar
• Use AutoCorrect and AutoComplete
• Check Spelling and Grammar
• Create a View

Customize Excel 2000 Tools

• Customize the Toolbars
• Customize Commands
• Customize the View
• Customize Calculations
• Customize Edit Features
• Customize General Options
• Customize Transition Options
• Create Custom Lists
• Customize Chart Options
• Customize Colors

Managing Excel 2000 Workbooks

• Create a New Workbook
• Open an Existing Workbook
• Create a New Workbook from an Existing Workbook
• Open a Workbook in Read-Only Mode
• Set Properties for a Workbook
• Save a Workbook
• Create a New File Folder
• Open Multiple Workbooks
• Close All Open Workbooks
• Save a Workspace
• What is a Template?
• Create a New Workbook from a Template
• Create My Own Template
• Share a Workbook
• Merge Workbooks
• Protect a Workbook

Creating a Worksheet in Excel 2000

Manage Excel 2000 Worksheets

• Navigate a Worksheet
• Insert a New Worksheet
• Arrange Windows
• Name a Worksheet
• Create a Worksheet Using Move or Copy Sheet
• Rename a Worksheet
• Delete a Worksheet
• Splitting a Worksheet
• Zoom In or Out on a Worksheet

Enter Data to a Worksheet

• What are Labels and Values
• Enter Text (Labels)
• Enter Numbers (Values)
• Enter a Number as a Label
• Enter a Label from the Picklist
• Enter the Current Date or Time
• Enter Data into a Range
• Enter Data Using AutoFill
• Use AutoComplete
• Use Data Validation
• Import Data to a Worksheet
• Add a Comment to a Cell
• Enter Data to Multiple Worksheets

Create a Formula or Calculation

• What is a Formula?
• Create a Formula
• Use a Range in a Formula
• Use Auto Sum Feature
• Calculate a Range Using AutoCalculate
• Use Cell References in a Formula
• Link Worksheets with Formulas
• Use a Range Name in a Formula
• Insert a Range Using AutoFill
• Join Cells of Information (Concatenate)
• Calculate the Worksheet

Using Excel 2000 Functions

• Use Excel Functions
• Use the AVERAGE Function
• Use the COUNT Function
• Use the COUNTIF Function
• Use the DSUM Function
• Use the IF Function
• Use the IRR (Internal Rate of Return) Function
• Use the SUM Function
• Use the VLOOKUP Function

Modify a Worksheet

• Insert a Row
• Delete a Row
• Insert a Column
• Delete a Column
• Adjust Row Height
• Adjust Column Width
• Freeze Titles
• Delete a Worksheet

Select and Edit Data

• Select a Cell or Range of Cells
• Select a Noncontiguous Range of Cells
• Name a Cell or Range of Cells
• Select a Named Cell or Named Range
• Edit the Contents of a Cell
• Deleting Cell Data, Formatting and Comments
• Undo a Deletion
• Insert a Cell or Cells
• Delete a Cell or Cells
• Copy and Move Data
• Edit Formulas
• Copy Formulas
• Use Collect and Paste
• Convert a Formula to a Number
• Transpose Column and Row Headings
• Edit or Delete a Comment

Formatting Cells

• Quickly Format Text
• Quickly Format Numbers
• Format a Number
• Format the Date and Time
• Format Telephone Numbers
• Format Social Security Numbers
• Control Cell Alignment
• Merge Cells
• Rotate Text
• Set Font Characteristics
• Insert a Border
• Set Cell Color and Patterns
• Wrap Text in a Cell
• Shrink Data to Fit a Cell
• Indent Text
• Copy Cell Formats

Formatting a Worksheet

• Change the Background of a Sheet
• Use Auto Formatting
• Create Conditional Formatting
• Modify the Style of a Worksheet

Protecting and Hiding Data

• Protect a Worksheet
• Hide Formulas on a Protected Worksheet
• Hide a Row
• Hide a Column
• Hide a Worksheet

Using Lists and Analyzing Data

List Management

• What is a List?
• Build a List Using a Data Form
• Sort a List Quickly
• Sort a List Using Multiple Sort Criteria
• Find Data in a List
• Filter Data in a List
• Create a Custom Data Filter
• Subtotal a List
• Parse Data
• Consolidate Data
• Group and Outline Data

Forecast Values and What-If Analysis

• Create a Data Table
• Create a Scenario
• Use Goal Seek
• Use Solver

Analyze Data Using a PivotTable

• What is a PivotTable?
• Create a PivotTable
• Update a PivotTable
• Add and Remove PivotTable Fields
• Create a PivotTable Report
• AutoFormat a PivotTable Report
• Chart a PivotTable
• Revise a PivotChart
• Change Field Settings for a PivotTable or PivotChart

Other Data Tools

• Audit a Worksheet
• Track Data Changes
• Protect a Worksheet

Presenting a Worksheet

Creating Charts

• What is a Chart?
• Use the Chart Wizard to Create a Chart
• Change a Data Series
• Add or Delete a Data Series
• Change the Data Series Order
• Add a Trendline
• Format Chart Options
• Change the Chart Type
• Change Placement of a Chart
• Resize an Embedded Chart
• Insert a Picture
• Insert an Object from Another Program
• Draw an Object
• Add a Chart to Another Document

Printing a Worksheet or Chart

• Specify the Print Area
• Use Print Preview
• Print a Worksheet
• Print a Chart
• Explore Print Options
• Change the Print Orientation
• Adjust the Print Scale
• Change the Paper Size
• Change the Page Margins
• Center a Worksheet on a Page
• Print Headers and Footers
• Print Without Gridlines
• Print Row and Column Headings
• Adding Page Breaks
• Print Comments
• Create an Adobe PDF

Excel 2000 Web Functionality

Using Excel 2000 Web Functionality

• Save as a Web Page
• Preview as a Web Page
• Paste as a Hyperlink
• Insert a Hyperlink
• Use Online Collaboration