Mentor for Excel 2002
Table of Contents
Overview
Use Mentor
• How Do I Use Mentor for Excel 2002?
How Does Excel 2002 Work?
• How Does Excel 2002 Work?
• What Can Excel 2002 Do?
Collaboration in Office XP
• Office XP--A Whole New Way to Work
• What’s New and Improved in Excel 2002?
• Find Out What's New and Improved in Excel 2002
• Find Out About Smart Tags and Options Buttons
• Collaborative Spreadsheet Review
• Web Integration
Use Basic Commands and Features
Basic Workbook Features (Tutorial)
• Find Out About the Excel Screen
• Arrange Workbook Windows Open a Workbook in a New Window
• Split a Worksheet
• Freeze Panes in a Worksheet
• Switch Between Open Workbook Windows
• Use, Modify, or Hide the Office Assistant
Use and Customize Menus (Tutorial)
• Find Out About the Menu Bar
• Add or Remove a Menu
• Customize Menus
• Right-Click to Open Shortcut Menus
• Find Out About Keyboard Shortcuts
Use and Customize Toolbars (Tutorial)
• Find Out About the Standard Toolbar
• Find Out About the Formatting Toolbar
• Hide or Display Toolbars
• Move Toolbars
• Customize Toolbars
• Create a Custom Toolbar
Use Smart Tags (Tutorial)
• Use Smart Tags
• Set Smart Tag Options
• Check for New Smart Tags
Use Macros (Tutorial)
• Record a Macro
• Set the Macro Security Level
• Run a Macro
• Delete a Macro
Use Workbooks
Create and Open Workbooks (Tutorial)
• Find Out About the New Workbook Task Pane
• Create a New Workbook
• Create a New Workbook from an Existing Workbook
• Create a New Workbook from a Template
• Create a Workbook Template
• Open an Existing Workbook
Manage Workbooks (Tutorial)
• Save a Workbook
• Save a Workbook in a Different File Format
• View and Set Workbook Properties
• Set Custom Workbook Properties
• Change the Workbook View Options
Navigate Workbooks (Tutorial)
• Use the Search Task Pane
• Use the Find and Replace Feature
• Insert a Hyperlink
• Edit a Hyperlink
Protect Workbooks (Tutorial)
• Protect a Worksheet
• Protect Elements of a Workbook
• Track Changes to a Workbook
• Accept or Reject Changes to a Workbook
Share and Review Workbooks (Tutorial)
• Password Protect an Excel File
• Set Sharing Options
• Allow Users to Edit Ranges
• Find Out About the Reviewing Toolbar
• Send a Workbook for Review
• Send a Portion of a Workbook
• Compare and Merge a Workbook
Share Workbooks with SharePoint Team Services (Tutorial)
• Find Out About Team Web Sites
• Create a Team Web Site
• Open a File on a Web Server
• Save a File to a Web Server
• Create a SharePoint Team Services List with Excel 2002
• Check Out a File
Use Worksheets
Manage Worksheets (Tutorial)
• Navigate a Worksheet
• Insert a New Worksheet
• Move or Copy a Worksheet
• Rename a Worksheet
• Delete a Worksheet
• Create a Custom Worksheet View
• Zoom In or Out of a Worksheet
Modify Worksheets (Tutorial)
• Insert Rows
• Delete Rows
• Insert Columns
• Delete Columns
• Adjust Row Height
• Adjust Column Width
• Transpose Column and Row Headings
• Undo an Action
Format Worksheets (Tutorial)
• Add a Background to a Worksheet
• Change the Color of a Worksheet Tab Apply an AutoFormat
• Create Conditional Formatting
• Remove Conditional Formatting
• Modify the Style of a Worksheet
Protect Workbooks (Tutorial)
• Protect a Worksheet
• Protect Elements of a Workbook
• Track Changes to a Workbook
• Accept or Reject Changes to a Workbook
Hide Elements of Worksheets (Tutorial)
• Hide a Worksheet
• Hide a Formula
• Hide Rows and Columns
• Compare and Merge a Workbook
Work with Styles (Tutorial)
• Create a New Style
• Use the Style Tool
• Modify a Style
• Delete a Style
• Merge a Style from Another Workbook
Use Cells
Work with Cells (Tutorial)
• Select Cells
• Name a Cell or Range of Cells
• Select a Named Cell or Named Range
• Edit the Contents of a Cell
• Insert Cells
• Delete Cells
• Merge and Center Cells
Format Cells (Tutorial)
• Set Cell Colors and Patterns
• Copy Cell Formats
• Create a Cell Border
• Draw a Cell Border
• Clear Cell Contents and Formatting
Add Comments to Cells (Tutorial)
• Add a Comment to a Cell
• Edit or Delete a Comment
• Display or Hide Comments
• Navigate Comments
• Print Comments
Manage Data
Enter Data (Tutorial)
• Find Out About Types of Data
• Enter Data from a Pick List
• Enter Data into a Range of Cells
• Enter Data with AutoFill
• Use the AutoComplete Feature
• Enter Data into Multiple Worksheets
• Copy Web Data to a Worksheet
• Import Data into a Worksheet
Work with Data (Tutorial)
• Copy Data
• Move Data
• Insert Data Between Existing Cells
• Use the Clipboard Task Pane
• Convert Text to Columns
• Consolidate Data
Format Data (Tutorial)
• Align the Contents of a Cell
• Change the Orientation of Text
• Fit Text in Cells
• Format Text
• Format Numbers
Check Data for Errors (Tutorial)
• Customize Editing Options
• Use AutoCorrect
• Use Data Validation
• Circle Invalid Data
• Check Spelling
Get Data from External Sources (Tutorial)
• Create a Refreshable Web Query
• Edit a Web Query
• Run a Saved Web Query
• Create a Database Query
• Edit a Database Query
• Refresh a Query
• Link to Data in Other Workbooks
• Edit Links to Data
Analyze Data
Use Goal Seek (Tutorial)
• Find Out About Using Goal Seek
• Use Single Cell Goal Seek
Analyze Data Using What-If Analysis Tools (Tutorial)
• Create a Data Table
• Define a Scenario
• Display a Scenario
• Modify a Scenario
• Merge Different Scenarios
• Create a Scenario Summary Report
Create and Revise a Pivot Table (Tutorial)
• Create a Pivot Table
• Create a Pivot Table from External Data
• Find Out About the Pivot Table Toolbar
• Change the Pivot Table Structure
• Refresh a Pivot Table
• Customize a Pivot Table Field
• Format a Pivot Table
• Group Pivot Table Items
• Use a Pivot Table to Consolidate Worksheets
Create and Revise a Pivot Chart (Tutorial)
• Create a Pivot Chart from a Pivot Table
• Create a Pivot Chart from a Data Field
• Revise a Pivot Chart
Work with Formulas, Calculations, and Functions
Create Formulas (Tutorial)
• Create a Formula
• Create a Formula Using Cell References
• Copy and Paste a Formula
• Use a Range in a Formula
• Use a Formula to Link Worksheets
• Use a Range Name in a Formula
• Convert a Formula to a Number
Evaluate Formulas (Tutorial)
• Find Out About Formula Auditing
• Trace Precedents
• Trace Dependents
• Trace Errors
• Edit a Formula
• Evaluate a Formula
• Display the Watch Window
Calculate Information (Tutorial)
• Customize Calculations Options
• Use the AutoCalculate Feature
• Calculate a Worksheet Manually
Use Basic Functions (Tutorial)
• Learn About Excel Functions
• Use the AutoSum Feature
• Use the AVERAGE Function
• Use the COUNT Function
• Use the SUM Function
• Use the MAX Function
• Use the MIN Function
• Use the IF Function
Use Advanced Functions (Tutorial)
• Use the Payment (PMT) Function
• Use the VLOOKUP Function
• Use the Real-Time Data (RTD) Function
• Use the COUNTIF Function
• Use the SUMPRODUCT Function
• Use the SUMIF Function
• Use the Internal Rate of Return (IRR) Function
Work with Lists, Outlines, and Charts
Work with Lists (Tutorial)
• Build a List
• Add to a List Using a Data Form
• Sort a List
• Create a Custom Sort Order
• Apply a Custom Sort Order
• Find Data in a List
• Filter Data in a List
• Subtotal a List
• Work with a Subtotaled List
Group and Outline Data (Tutorial)
• Group and Outline Data
• Display or Hide Outline Levels
Create Charts (Tutorial)
• Create a Chart
• Work with Data Series
• Add a Trendline to a Chart
Format Charts
• Find Out About Chart Options
• Change the Chart Type
• Change the Location of a Chart
• Resize an Embedded Chart
Specify Chart Options (Tutorial)
• Add Titles and Axis Labels
• Hide or Display the Legend
• Hide or Display a Data Table
• Add Data Labels
• Format Chart Elements
Insert Objects and Pictures
Insert Pictures (Tutorial)
• Insert Clip Art
• Insert a Picture
• Format a Picture
Insert Objects (Tutorial)
• Draw an Object
• Insert an Object from Another Program
• Work with WordArt
• Insert a Diagram
Print Worksheets
Format a Worksheet for Printing (Tutorial)
• Use Print Preview
• Change the Page Setup for Printing
• Modify Chart Printing Options
• Specify the Print Area
• Change the Margins of a Worksheet
• Create Headers and Footers
• Create Custom Headers and Footers
• Insert Page Breaks
Print a Worksheet (Tutorial)
• Print a Worksheet
• Print with Gridlines
• Print Row and Column Headings
• Print Repeating Row and Column Titles
Excel 2002 Web Functionality
Excel 2002 Web Functionality (Tutorial)
• Save a Workbook as a Web Page
• View a Web Page with Excel
• Find Out About Interactive Web Components
• Work with FTP Sites Publish a Worksheet to the Web
• Use the AutoRepublish Feature
|