Microsoft Excel 2002 - Excel XP Advanced

Course Overview

Microsoft Excel provides powerful tools that enable you to analyse, share, and manage information in order to make more informed decisions. InterAction courses are packed with practical lessons and simulation that were developed in Australia - so yes you will be listening to Australian voices! Now you can access the same self-paced learning InterAction has been delivering to Corporate and Government organisations across the world for 25 years. Up to 85% of our screens are interactive, ensuring that you are constantly involved and thus motivated to learn. You can also start by completing an optional interactive pre-test which identifies any skills gaps you may have, and then recommends the most appropriate modules that you need to concentrate on to round off your knowledge. If you are an intermediate or advanced user, you will be directed to the specific topics that will supplement your existing knowledge.

Audience

You might be a new, intermediate or power user, or a user migrating from an earlier version. We assume that you also have the basics of operating your PC and Windows.

Delivery Method

Online Delivery

Language Options

English and Spanish

Total Learning Time

5 to 6 hours

Learn To

Importing Data

• Import Text Files
• Use the Text Import Wizard
• Save an Imported Worksheet
• Import Using Drag and Drop
• Query Databases
• Import from HTML Files
• Export Files Data Validation
• Apply Data Validation
• Set Validation Criteria
• Enter Input Messages
• Enter Error Alert Filtering Data
• Add Automatic Filters Creating a Workspace
• Select Consecutive Files
• Select Non-consecutive Files
• Open Multiple Files
• Move between Workbooks
• Arrange Workbooks
• Save the Excel Workspace
• Edit a Workspace File
• Close Multiple Workbooks Consolidating Data
• Consolidate Data
• Select Destination Area
• Consolidate Workbooks
• Update Links Linking Workbooks
• Link Data in Workbooks
• Use Paste Special Share and Protect Worksheets
• Group Edit
• View User Name
• Protect Worksheets
• Remove Protection
• Share Workbooks
• Change File Properties Working with Comments
• Use the Comments Feature
• Insert Comments
• Edit Comments
• Display Comments
• Move to Comments Tracking Changes
• Track Changes in a Workbook
• Highlight Tracking Changes
• Shared Workbook Revisions
• Hide Highlighting
• Accept or Reject Revisions
• Remove Tracking Auditing Tools
• Use Auditing Tools
• Trace Dependents
• Trace Errors in Formulas
• Correct Formula Errors The Scenario Manager
• Name Scenario Cells
• Name the Result Cell
• Create a Scenario
• Set Scenario Manager Options
• Create Summary Reports Custom Views
• Define Custom Views
• Prepare a Custom View
• Hide Rows for Custom View
• Apply Custom Views

Subscription Period

This course is available in 3, 6 and 12 month subscriptions. Please call Courses Now for respective prices.