Intermediate Microsoft Excel 2003 Training Courses

Short course

In Twickenham

£ 295 + VAT

Description

  • Type

    Short course

  • Location

    Twickenham

  • Duration

    1 Day

  • Start date

    Different dates available

This course aims to give delegates a greater understanding of MS Excel 2003.

                               

Facilities

Location

Start date

Twickenham (Middlesex)
12 Northcote Road, TW1 1PA

Start date

Different dates availableEnrolment now open

About this course

On completion of the course delegates will have improved their skills in using Microsoft Excel 2003. They will be able to:

Manipulate worksheets
Use templates
Apply conditional formatting
Use various functions, including financial, logical and date/time functions
Manage Excel databases and lists
Customise charts
Use Excel in conjunction with other applications

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

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 14 years

Subjects

  • Excel
  • MS Excel
  • Microsoft Excel
  • Microsoft excel training
  • Manipulating Worksheets
  • Inserting
  • Freezing panes
  • Hiding rows
  • Grouping
  • Applying templates
  • Editing templates
  • Creating Templates
  • Financial functions
  • Data validation
  • Filtering Data

Course programme

Manipulating Worksheets

Renaming worksheets
Inserting worksheets
Deleting worksheets
Splitting worksheet window into panes
Freezing panes
Hiding rows and columns
Grouping and ungrouping worksheets
Copying data between worksheets
Formatting multiple worksheets in one operation
Entering a formula to link related worksheets
Templates

Applying templates
Editing templates
Creating templates
Formatting

Applying number formats
Creating conditional number formats
Using conditional formatting
Functions

The IF function
Nested IF functions
Financial functions, including PMT, FV
The DATE function
The NOW function
Excel databases and lists

Creating an Excel database
Editing an Excel database
Sorting
AutoFilter
Filtering data
Totalling and manipulating filtered data
Creating subtotals
Using data forms
Data validation
Charts

Plotting non-contiguous data ranges
Pie charts
Adding new data to an existing chart
Chart formatting techniques
Use of Excel with other applications

Paste special option
Linking vs Embedding
Linking data from other worksheets
Linking data from other applications
Exporting to other applications

Additional information

Course Type Cost per day
1 to 1 training £295
2 to 4 delegates £455
5 to 8 delegates £595
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT

Intermediate Microsoft Excel 2003 Training Courses

£ 295 + VAT