Excel 2002: Intermediate

« back to previous page

Description:	Students will gain the skills needed to work with multiple worksheets, create outlines, use HTML files and use advanced functions. Students will be able to view and analyze date using paste special, range names, scenarios and charts. Worksheets may be enhanced using drawing objects. Students will learn to use the database features of Excel by manipulating an Excel list, adding and deleting records and performing sorts and filters.
Prerequisites:	Introduction to Excel 2002 or equivalent experience
Length:	One day

Working with Workbooks
• Moving Around in a Workbook
• Selecting Several Worksheets
• Renaming, Inserting and Deleting Worksheets
• Moving and Copying Worksheets
• Grouping Worksheets
• Setting Automatic Recovery
• Adding a Watch Window
• Creating Formulas and Functions Across Worksheets
• Entering a Simple Linked Formula
• Entering a 3-D Reference
• Managing Links

Working with Outlines
• Creating the Worksheet Structure
• Applying an Outline
• Expanding and Collapsing an Outline
• Applying an Auto Outline
• Clearing an Outline
• Modifying Outline Settings

Using HTML Files and Hyperlinks
• Using Excel 2002 and HTML
• Saving a Worksheet as a Web Page
• Opening an HTML File
• Using the Web Toolbar and Hyperlinks
• Inserting a Hyperlink to Jump Between Files
• Inserting a Hyperlink to Jump within a Worksheet
• Using and Removing Hyperlinks
• Using the Address Box

Using Paste Special
• Pasting Formats between Worksheets
• Pasting Values or Formulas
• Using Paste Special for Mathematical Operations
• Linking between Workbooks

Using Range Names
• Assigning Range Names
• Moving to a Named Range
• Using Range Names in Formulas
• Creating Range Names from Headings
• Applying and Deleting Range Names
• Using Range Names in 3-D Formulas
• Using Labels in Formulas

Working with Advanced Formulas
• Using Function Argument Tooltips
• Using Financial Functions
• Working with Logical Functions
• Entering Date and Text Functions
• Using Statistical and Math & Trig Functions
• Working with a Lookup Function
• Using the Formula Auditing Toolbar
• Using the Formula Evaluator

Analyzing Data
• Creating and Viewing a Scenario
• Editing and Deleting a Scenario
• Using Solver
• Using Goal Seek

Creating Charts
• Designing Charts
• Working with Chart Components
• Using the Chart Wizard
• Moving and Sizing a Chart
• Changing the Chart Range
• Changing the Chart Type
• Formatting the Chart
• Adding Text and Arrows
• Creating a Picture Chart
• Printing a Chart
Drawing an Object
• Working with Drawing Objects
• Moving and Sizing Objects
• Adding Text or Color to an Object
• Formatting Objects
• Using AutoShapes
• Adding a Text Box

Managing Data
• Understanding Database Concepts
• Entering Excel Lists
• Adding and Deleting Records
• Finding and Replacing Data
• Sorting a List
• Filtering Data
• Using AutoFilter
• Using the Advanced Filter
• Using the Data Form
• Editing, Adding, Finding and Deleting Records with the Data Form
• Creating Subtotals

Summary and Review