Excel XP\2003 Intermediate

Course

In London and Birmingham

£ 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

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

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