Excel 2010 Advanced Course Overview

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.

Learn To

Importing Data

Introduction

Importing Text Files

The Text Import Wizard

Saving an Imported Worksheet

Other File Conversion Techniques

Get External Data Button

Importing using Drag and Drop

Exporting Files

Data Validation

Introduction

Data Validation

Set Validation Criteria

Enter Input Message

Enter Error Alert

Entering Data

Data Forms

Introduction

Data Forms, Fields and Records

Locating and Displaying the Form button

Using a Form

Form Navigation

Deleting Form Records

Adding a New Record

Searching Form Records

Filtering Data

Introduction

Adding Automatic Filters

Selecting Filters

Setting Multiple Filters

Customising Filters

Removing the AutoFilter

Creating a Workspace

Introduction

Opening Multiple Files

Selecting Consecutive Files

De-selecting Files

Selecting Non-consecutive Files

Opening Selected Files

Arranging Workbooks

Saving the Excel Workspace

Editing a Workspace File

Closing Multiple Workbooks

Opening Workspace Files

Linking Workbooks

Introduction

Linking Data in Workbooks

Using Paste Special

Linking using an Equal Sign

Updating Links

Consolidating Data

Introduction

Consolidating Data

What is Consolidation?

Selecting Destination Area

Consolidating Workbooks

Updating Links

Outlining Features

Share and Protect Worksheets

Introduction

Viewing User Name

Protecting Worksheets

Removing Protection

Sharing Workbooks

Workbooks on a Network

Viewing File Properties

Working with Comments

Introduction

Inserting Comments

Editing Comments

Displaying Comments

Finding Comments

Deleting Comments

Tracking Changes

Introduction

Tracking Changes

Hiding Highlighting

Accept or Reject Revisions

Removing Tracking

Auditing Tools

Introduction

Using Auditing Tools

Tracing Precedents

Tracing Dependents

Removing Tracer Arrows

Tracing Errors in Formulas

Correcting Formula Errors

The Scenario Manager

Introduction

Scenario Manager

Naming Scenario Cells

Naming Variable Cells

Naming the Result Cell

Adding Scenarios

Creating Summary Reports

Custom Views

Introduction

Preparing a Custom View

Adding a Custom View

Hide Rows for Custom View

Adding a Custom View

Setting a Print Area

Applying Custom Views