Excel 2003 Intermediate

Afiniti

Short course

In London

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Level

    Intermediate

  • Location

    London

  • Duration

    1 Day

The aim of this course is to provide delegates with further practical experience of Microsoft Excel 2003. By the end of the course delegates will be able use further functions, manage lists and use charts and drawing tools. Suitable for: This course is designed for existing users of Excel who want to learn new skills and apply them effectively.

Facilities

Location

Start date

London
See map
Lower Ground Floor Russell Square House 10 - 12 Russell Square, WC1B 5EH

Start date

On request

About this course

Delegates should have a working knowledge of Excel 2003, gained through the attendance of an Excel 2003 one day introduction course or through experience in the work place.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Core Topics

Viewing Worksheets

· Customising View Options

· Displaying And Customising Toolbars

· Hiding Workbooks And Worksheets

· Freezing Panes

· Grouping And Ungrouping Worksheets

More Formatting Techniques

· Using Styles

· Conditional Formatting

· Using The Format Painter

· Using Guidelines

· Hiding And Displaying Cells

More Formulas and Functions

· Using The Series Command

· Using The Insert Function Wizard

· IF Functions and VLOOKUP

· 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

· Using Databases

· Creating And Editing A Database

· Sorting A Database

· Using Autofilters

· Advanced Filters

· Working With Filtered Data

· Using Data Forms

Charts

· Chart Wizard

· Chart Toolbar

· Working With Charts

· Formatting The Chart

Drawing and Picture Objects

· Drawing Toolbar

· Working With Autoshapes

· Creating Text Boxes

· Adding Pictures

· Layering Objects

· Grouping And Ungrouping Objects

Excel 2003 and other Applications

· Converting Files From Other Applications

· Copying Data From Another Application

· Embedding And Linking Objects

· Hyperlinks

· Managing Links


Follow up Courses

Excel 2003 Advanced

See related categories

Excel 2003 Intermediate

Price on request

The best Excel courses

See all

See all