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

Working with Spreadsheets

What is a Spreadsheet?

Starting Excel

Creating New Workbooks

Opening an Existing Workbook

Activating the Open Box

The Places Bar

Changing Drives

Opening Folders

Changing Views

The Tools Button

Opening Workbooks

Creating a New Workbook

Moving Between Workbooks

Saving Workbooks

Creating a Folder

Creating a Folder

Saving Workbook Documents

Converting File Formats

Saving Existing Files

Closing Workbooks

Closing All Open Workbooks

Enhancing Productivity

Using the Ribbon

Using the Office Ribbon

The Worksheet

Cells

Identifying the Active Cell

Formula Bar

Sheet Tabs

The Status Bar

The Windows Taskbar

Hiding the Taskbar

Mouse Pointer Shapes

Excel options

Using Zoom

Using Full Screen View

Exiting Full Screen View

Zoom Slider

Excel Help

Table of Contents

Closing the Help window

Select Cells and Insert Data

Entering Data

Entering Labels

Entering Dates

Entering Values

Entering Data

Changing Data

Mouse Keyboard Selection

Selecting Columns

Selecting Multiple Columns

Selecting Rows

De-selecting Cells

Selecting a Table

Selecting Entire Worksheet

Edit and Sort Data

Editing and Sorting Cells

The Scroll Bars and Scroll Box

Moving around a Worksheet

Editing Cell Content

Using the Undo and Redo Command

Moving to the beginning of a Row

Using the Go To Command

The Name Box

Sheet Tabs

Tab Scrolling Buttons

Finding Data

Replacing Data

Sorting Data

Copy, Move and Delete Content

Copy, Move and Delete the Content of Cells

Using AutoSum

Copying with AutoFill

Deleting the Contents of Cells

Cut and Paste

Moving Data using the Ribbon

Pasting the Data

Copying with Shortcut Menu

Using Paste Special

Pasting Multiple Items

Clearing the Office Clipboard

Copying Data Between Workbooks and Applications

Copying with Drag and Drop

Arranging Workbook Windows

Moving with Drag and Drop

Maximising a Window

Working with Rows and Columns

Working with Rows and Columns

Inserting Columns

Inserting Rows

Deleting Rows

Deleting Columns

Adjusting Column Widths

Changing Row Heights

Multiple Column Width and Row Height Adjustment

Automatic Width Adjustment

Using Undo

Undoing Multiple Actions

Hiding Rows in a Worksheet

Unhiding Rows

Hiding Columns

Unhiding Columns

Splitting Windows

Freezing Panes

Unfreezing Panes

Working with Workbooks

Working with Worksheets

Naming Sheet Tabs

Copying Worksheets

Copying Between Worksheets

Editing Data

Clearing Cells

Selecting 3D Ranges

Ungrouping Worksheets

Inserting, Deleting and Ungrouping

Deselecting Cells

Multiple Sheet Formulas

Copying with AutoFill

Inserting a Worksheet

Deleting a Worksheet

Saving Workbooks

Arithmetic Formulas

Arithmetic Formulas

Standards for Arithmetic Formulas

The AutoSum Button

Copying Formulas

Copying with AutoFill

Updating Formula Results

Simple Gross and Net Profit Formulas

Errors in Formulas

Circular Reference Error

Divide by Zero Error

Finding Named Ranges

Using Shortcut Keys

Incorrect Names in Formulas

Deleting Named Ranges

Broken links in Formulas

Relative versus Absolute References

Using Relative Referencing

Copying Formulas with AutoFill

Absolute Referencing

Adding an Absolute Address

Functions

Functions

The Sum Function

The AutoSum Button

Copying Formulas

Entering Formulas

Copying with AutoFill

The NOW Function

The Average Function

The Maximum Function

The Minimum Function

The Count and Counta Function

The IF Function

The Round Function

The PMT Function

Formatting Numbers and Dates

Formatting Numbers and Dates

Formatting Numeric Values

Changing the Currency

Date Formatting

Opening the Formatting Cells Dialogue Box

Number Format Options

Currency Format Options

Accounting Format Options

Custom Number Formats

Formatting Cell Content

Formatting Cell Content

Changing Fonts

Changing Font Size

Automatic Row Height Adjustment

Changing Text Colour

Aligning Data in Cells

Bold, Italic and Underline

Bolding Data

Adding Background Colour

Adding an Underline

Text Colour and Italics

Double Underlining

Applying Bold to Values

Using the Format Painter 

Using the Format Painter to copy a range of cells

Formatting using the Format Cells dialogue box

Alignment and Border Effects

Alignment and Border Effects

Centring Titles across Columns

Clearing Data and Formatting

Left, Centre and Right Cell Alignment

Top, Centre and Bottom Cell Alignment

Orientation

Applying Borders

Indenting Cell Entries

Word Wrap

Creating Charts

Creating Charts

Creating Column Charts

Resizing Charts

Moving the Chart

Changing Chart Types

Deleting a Chart

Creating Line Charts

Creating Bar Charts

Creating Pie Charts

Editing Charts

Editing the Chart

Adding Elements to the Chart

Adding a Title to the Chart

The Range Finder

Formatting Chart Objects

Removing Chart Objects

Adding Labels to the Axis

Formatting the Legend

Formatting a Data Series

Changing Marker Colours

Changing the Colour of the Axis

Inserting Shapes and Arrows

Adding Text Boxes

Displaying Data Labels

Page Setup Options

Output Setup

Page Layout View

Previewing Worksheets

Adjusting Margins

Closing Print Preview

Previewing Multiple Worksheets

Page Break Preview

Inserting and Removing Page Breaks

Page Setup Options

Headers and Footers

Adding Headers and Footers

Custom Headers and Footers

Sheet Options

Printing Column Titles

Other Print Options

Controlling Page Order

Previewing Worksheets

Page Options in Page Setup

Page Orientation

Scaling the Worksheet

Changing Paper Size

Changing Margins

Page Centring

Editing in Page Layout View

Checking and Printing

Checking and Printing Worksheets

Using the Spelling Checker

Using AutoComplete

Using AutoCorrect

Finding Data in Worksheets

Replacing Worksheet Data

Preview and Print a Chart

Setting a Print Area

Removing a Print Area

Printing Worksheets

Selecting Printers

Printer Properties

Printing Gridlines and Headings

Printing Titles