Part time Excel Intermediate

Microsoft Excel 2003 - Intermediate Type of learning:
Instructor lead at DBIC

Duration:
1 day intensive

Times/dates:

Cost:

£185 (includes course materials, lunch and refreshments)
Corporate rates available please contact us for further information

Target Audience
This course is aimed at anyone who has some experience of Excel 2003 and wishes to examine some of the more advanced features.

Pre-Course Requirements
Delegates should be familiar with the basics of Excel 2003, either from attending our Introductory Course or knowledge gained from their own experience.

Benefits to the Employer
Staff will respond to your commitment to their career development and are likely to become more motivated to perform well and be dedicated to the business. Well-trained staff will be able to complete tasks more quickly and efficiently and productivity may go up.

Course Aims
This course allows the delegate to experience the power of Excel 2003. By the end of the course, the user will be competent with the following skills:

Course Outline

Workbooks

- Renaming Sheets

- Display Multiple Sheets

- Copy and Moving Sheets

- Inserting and Deleting Sheets

- Grouping Sheets

Cell Referencing

- Relative Addressing

- Absolute Addressing

Functions

- Insert Function

- Count, CountA and Average

- Minimum and Maximum

- IF

- CountIF and SumIF

Options

- Control Display Options

- Create Custom Lists

Setting Chart Parameters

- Add Data Labels

- Add/Remove Legends

- Change Axis Intervals/Limits

- Add a Trendline

- Data Series Colour

Worksheet Views

- Multiple Windows

- Freeze Panes

Advanced Cell Formatting

- Text Wrap and Merge Cells

- Text Orientation

- Format Painter

- Conditional Formatting

- Paste Special

- AutoFormat

- AutoCalculate

Cell Comments

- Create, Edit and Delete Comments

Using Names

- Create, Apply and Paste

- Names in Formulas

Advanced Cell Editing

- Repeat

- Transposing Data

- Delete and Insert Cells

Templates

- Create a basic Template

- Using a Template

Advanced Printing

- Scaling

- Print Titles, an Area and a Selection

Advanced Formulas

- Data Series

- Custom Number Formats

Views

- Create, Display and Delete Views



Filter Lists

- AutoFilter

- Custom AutoFilter

Sorting

- Multiple Column sorts

- Custom Date Sorts

Importing Data

- Import Text Files

This course outline is a guide. All our courses can be tailored to customer requirements.