Excel XP\2003 Intermediate

Course

In Birmingham and London

£ 495 + VAT

Description

  • Duration

    2 Days

This course is designed to enhance the knowledge of existing Excel users and improve their skills.

Facilities

Location

Start date

Birmingham (West Midlands)
Spring House, 3010 The Crescent, Solihull Parkway, Birmingham Business Park Birmingham, B37 7YE

Start date

On request
London
See map
3-5 Crutched Friars, EC3N 2HR

Start date

On request

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

Course content

  • Freezing and splitting worksheets, hiding and un-hiding files, rows and columns
  • Conditional formatting
  • Creating 2D and 3D charts
  • Formatting charts
  • Inserting and clearing data
  • Naming cells and creating 3D formulas
  • Relative and absolute cell referencing
  • Using IF and nested IF functions
  • Lookup tables
  • Subtotals
  • Data series
  • Using the watch window
  • Setting manual and automatic outline
  • Hiding and displaying outline
  • Working with visible data only
  • Linking worksheets
  • Consolidating worksheets
  • Hyperlinks

Excel XP\2003 Intermediate

£ 495 + VAT