Excel 2010 Intermediate 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

Formatting Using Styles

Formatting Using Styles

Creating Styles

Applying Styles

Extended Formatting

Conditional Formatting

Conditional Formatting

Customising The Ribbon and Quick Access Toolbar

Working with the Ribbon

Minimising the Ribbon

Restoring the Ribbon

Keyboard Shortcuts

Adding commands to the Quick Access Toolbar

Assigning a Macro

Moving the Quick Access Toolbar

Removing commands from Quick Access Toolbar

Resetting Toolbars

Pivot Tables

Creating a PivotTable

The PivotTable Outline

PivotTable Layout

Rearranging a PivotTable

Updating PivotTable Data

Displaying all PivotTable Records

Customising a Field

PivotTable Report Options

PivotTable Report Options

Working with Macros

Macros

Writing Macros

Recording Macros

Running Macros

Editing a Macro

Outlining

What is Outlining?

Automatic Outline Feature

Hiding Outline Details

Showing Outline Details

Print Preview an Outline

Using Row Level Buttons

Selecting all Rows

Manually Grouping Data

Removing Group Outline

Goal Seek and Solver

Goal Seek and Solver

Working with Goal Seek

Working with Solver

Setting the Solver Target Cell

Selecting Adjustable Cells

Applying Constraints

Solver Results

Working with Named Ranges

Automatically Naming Ranges

Naming Ranges

Finding Named Ranges

Using Shortcut Keys 

Range Names in Formulas

Deleting Named Ranges

Lookup Functions

Lookup Functions

VLOOKUP

Adding VLOOKUP Values

Manually Adding a Formula

Creating a Web Page

Web Tools

What is the Internet?

Services on the Internet

Accessing the World Wide Web

Workbook Web Pages

Previewing as a Web Page

Saving a Workbook Web Page

Opening in Web Browser

Editing a Web Page

Creating a Hyperlink

Activating a Hyperlink

Worksheets and Email

E-mailing a Worksheet

Send Mail to Recipient

E-mailing a Worksheet

Entering Header Details

Sending a Message

Opening a Sent Message