Excel 2002/3 Intermediate

Target Audience

Microsoft Excel Intermediate is designed for users who are keen to extend their understanding and knowledge of the software. In particular, delegates should be familiar with the various data types, basic formulae and functions, the differences between Absolute & Relative Cell References and opening, closing and saving files.

Pre-requisites

To fully benefit from this course, attendees are expected to be confident users of Excel and be familiar with the topics covered in the Excel Foundation course.

At the completion of the course you should be able to:

• Set up spreadsheet models across multiple worksheets
• Work with linked workbooks
• Combine data in separate worksheets/workbooks using data consolidation
• Apply workbook and worksheet protection
• Apply names to ranges of cells or values
• Use the range of Paste Special options
• Use more advanced functions including logical and lookup functions
• Set up a simple database (list/table)
• Manage a database with sorts, filters and advanced filters
• Add data to an existing chart
• Use a range of advanced chart formatting techniques
• Use the various printing features to produce a variety of reports

Working With Linked Worksheets/Workbooks

Copy/Move/Rename/Insert/Delete Worksheet(s) • Grouping Worksheets • Hide & Unhide Worksheets • Formulae Using Data from Multiple Worksheets

Protection

Password Protect a Workbook  • Protect Workbook Structure  • Protect All/Part of a Worksheet

Consolidation

Consolidating Data with Identical/Different Layout

Range Names

Create or Define Range Names  • Use Range Names in Formulae

Paste Special

Paste Special to Copy Formulae/Formats/Validations • Paste Special for Arithmetic & Transpose Options

Logical & Lookup Functions

Use the IF/AND/OR/NOT Functions  • Nested Functions  • Use VLOOKUP/HLOOKUP Functions • Use the Insert Function Feature

Database (List) Features

Create a Database (List) • Use Data Forms With List Data  • Sort List Data  • Select Rows Using AutoFilter and Custom AutoFilter • Use Advanced Filter Feature for Complex Selection • Large Worksheet Viewing Options

Chart Editing Techniques

Add Data to a Chart  • Chart Options

Printing Techniques

Printing a Selection • Setting the Print Area • Setting Margins with Page Setup • Specifying Print Title Rows/Columns • Printing Row/Column Headings & Gridlines

You may also be interested in some of the following related courses below:

Microsoft - Excel 2002/3 - Foundation
Microsoft - Excel 2002/3 - Power User
Microsoft - Excel 2002/3 - VBA

Send this course to a friend
 

Course Fee

We have a rolling programme of Scheduled Public sessions for the majority of standard courses – both in IT Productivity and Management & Soft Skills. Group sizes are limited to ensure optimum learning amongst delegates.

Passport Saving Plans

The advertised rates are on a per delegate basis, however if you have more than one attendee you may be entitled to a discount. To maximise your training budget why not email or contact one of our training consultants to see what rates/discounts may apply for your particular requirement.

Alternatively, if you have regular, ongoing training requirements, you may find one of our Training Passports of interest. Each is designed to provide our clients with significant benefits:
• Far better discounts
• Less administrative overhead
• Better control of your training schedules

Scheduled Training Passports
Enables you to pre-purchase training places on any of our standard scheduled courses.

Private Training Passports
Enables you to pre-purchase private training days against any of our standard courses.

Each of the above passports come with substantial discounts.

To maximise your training budget why not email or contact one of our training consultants who will be happy to provide you with the latest offers on any of our Training Passports. See what rates/discounts may apply for your particular requirement.

Please fill out the form below for more details:

First Name
Last Name
Job Title
Company
Office Telephone
E-mail
Brief Details	Characters Left.