Microsoft Excel 2003 Intermediate + Advanced

This is a fast track 2 day course which combines EXCL03INTER and EXCL03ADV

Microsoft Excel 2003 Introduction Course Outline

Target Audience

Delegates that need to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web

Prerequisites

To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Excel 2003.

Viewing Worksheets In Excel 2003

• Customising View Options

• Displaying And Customising Toolbars

• Hiding Workbooks And Worksheets

• Freezing Panes

• Grouping And Ungrouping Worksheets

Printing In Excel 2003

• Using Page Setup

• Margins

• Headers And Footers

• Printing a Spreadsheet

More Formatting Techniques In Excel 2003

• Using Styles

• Conditional Formatting

• Using The Format Painter

• Using Guidelines

• Hiding And Displaying Cells

More Formulas And Functions In Excel 2003

• Using Named Cells And Ranges In Formulas

• Using The Series Command

• Using The Insert Function Wizard

• Using The Excel Function Categories

• Correcting Formulas

• Using The Formula Error Checker

• Using The Formula Auditing Toolbar

• Using The Watch Window

Database and List Management In Excel 2003

• Using Databases

• Creating And Editing A Database

• Sorting A Database

• Using Autofilters

• Advanced Filters

• Working With Filtered Data

• Using Data Forms

Excel 2003 And Other Applications

• Converting Files From Other Applications

• Copying Data From Another Application

• Embedding And Linking Objects

• Hyperlinks

• Managing Links

Microsoft Excel 2003 Advanced Course Outline

Target Audience

Delegates that need to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data   

Prerequisites

Delegates must already have a good working knowledge of Excel 2003, using formulas. Creating, editing and formatting spreadsheets.

Importing Data In Excel 2003

• Importing Data From External Sources

• Importing Text Files

• Using Microsoft Query

• Querying Data From The Web

• Refreshing Data

Templates and Styles In Excel 2003

• Working With Templates

• Working With Styles

Analysing Data In Excel 2003

• What-If Analysis

• Goal Seek

• Data Tables

• Scenario Manager

• Solver

• Using Pivot Tables

Macros and Custom Controls In Excel 2003

• Working With Macros

• Running Macros

• Adding Custom Controls

Charts In Excel 2003

• Chart Wizard

• Chart Toolbar

• Working With Charts

• Formatting the Chart Security And Proofing

• Security Features

• Protecting Excel Files

• Worksheet Protection

• Checking Spelling

• Using Data Validation

• Using Text To Speech

• Documentation

Customising Excel 2003

• Configuring Excel 2003 Options

• Working With Workspaces

Collaboration and Consolidation In Excel 2003

• Sharing Workbooks

• Sending Workbooks

• Consolidation

Analysing Data In Excel 2003

• Solver

Macros and Custom Controls In Excel 2003

• Basic VBA

• Working With Macros

• Running Macros

• Adding Custom Controls

Customising Excel 2003

• Configuring Excel 2003 Options

• Customising The Excel Environment

• Working With Workspaces