Microsoft Excel 2003 Intermediate

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