Microsoft Excel 2003 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.

Target 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

Online

Language Options

English and Spanish

Duration

5 to 6 hours

Course Outline

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 Periods

3, 6 and 12 month access periods are available for this course.  Please contact Courses Now International for respective prices.