Course Detail

Microsoft Excel 2003 - Introduction

COURSE CONTENT

What is Microsoft Excel?

Geography of the Screen
What is a Worksheet?
Menus, Commands and Dialogue Boxes
Keyboard, Mouse and Window Control

Create A New Workbook

Introduce File New Dialogue Box
Naming Conventions & Standards for Excel Properties
Explain Formula Bar & Enter Text

Open An Existing Workbook

Open and Close a Workbook
Explain Directory Structure
Print Preview and Print Dialogue Box

Move around a Worksheet

Scroll within a Sheet/Workbook using the Keyboard and Mouse - Go To

Select Cells & Worksheets

Select Cells, Rows, Columns & Worksheets - Move within

Edit a Worksheet

Types of Data & Editing Cell Contents
Insert and Cancel a Data Entry
Undo and Repeat Commands

Create Simple Formulae

Understand the Formula Bar & Cell References
Understand Operators & the order of Evaluation
Combine Expressions with Parenthesis
Display and Work with Formulas on the Worksheet
Use Autosum & Entering Multiple Sum Formulas
Relative and Absolute Cell References

Format a Worksheet

Format Cells using the Format Toolbar & Format Menu
Clear Format & Copy Formats
Apply and Clear Autoformat

Format Columns and Rows

Adjust Column Width & Row Height
Insert Rows/Columns/Blank Cells
Delete/Clear Cells

Cut/Copy/Paste within Worksheets

Concepts of the Clipboard
Copy and Move Cells with Cut, Copy, Paste
Copy & Paste Cells for Special Results

Create Charts for Worksheet Data

The Chart wizard
Embed Charts and Chart Sheets
Work with Chart Types and Auto formats
Change Data in a Chart
Format a Chart
Prepare a Chart for Print

On-line Help

Use Excel to provide help on all aspects of Excel

Microsoft Excel 2003 - Intermediate

Page Set-up

Changing default settings
Headers and footers
Setting Print ranges

Use Fill & Create a Series

Drag to Fill a Range of Cells
Increment a Series of Numbers & Dates
Create a Series based on a Single Value

Work with Named Ranges

Create and Apply Range Names
Insert a Name into a Formula

Create Conditional IF Functions

Use the IF() Function
Use the IF() Function Combined with AND()
Use the IF() Function Combined with OR()
Use More than one IF() Function and Nest Them

Create and Edit Templates

Create, Save and Open a Template

View a Worksheet

Open, Arrange & Close Workbook Windows
Split & Remove Splits, Freeze/Unfreeze Titles
Hide/Unhide Rows & Columns

Work with Multiple Worksheets

Arrange Worksheets on the Screen Simultaneously
Organise Multiple Files in a Workbook
Group and Format Multiple Worksheets
Print Multiple Reports from a Single Worksheet

Establish Links between Worksheets

When to Link and work with Data Links
Establish DDE and OLE Links
Add Files to an Existing Workbook

Microsoft Excel 2003 - Advanced

Organise & Manage Data in a Database

Using a list as a database
List management
Using the Data Form
Converting an Excel Spreadsheet to Microsoft Access
Creating Access Forms & Reports from an Excel spreadsheet

Sort and Filter Data in a List

Sorting Data
Working with filters
Filtering using Autofilter
Filter using Custom Criteria

Outline a Worksheet

Create and Remove an Outline
Show and Hide Details in an Outline
Change an Outline’s Organization

Auditing Formulas

Understand the Audit Features
Cell Precedents and Dependents
The Audit Toolbar - Audit the Worksheets Visually, Use Tracer Arrows

Goal Seek & the Solver

Find a Solution with Goal Seek
Using the Solver

Create and Work with a Pivot Table

Change the View of the Data within the Pivot Table
Name Fields and Items in the Finished Pivot Table
Update a Pivot Table
Customise a Pivot Table
Use External Data to Create a Pivot Table
Consolidate Data from Multiple Ranges into a Pivot Table
Create a Chart from a Pivot Table

Create Custom Formats

Create Custom Formats to Emphasise Data on a Worksheet
Using conditional formatting

Create a Macro

Create a Macro using Macro Record
Execute and Assign a Macro to a Shortcut Key
Execute and Assign a Macro to a customised Button
Run a Macro