Excel 2007 Intermediate

PPi Learning Services

Course

In London and Birmingham

£ 495 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

This course is designed to provide an existing Excel user with further knowledge about building formulas and functions, outlining worksheets, and linking and grouping data.

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

  • Formulas and Functions
  • Data series
  • 3D formulas
  • Naming cells
  • Relative and Absolute cell referencing
  • Subtotals
  • Using IF and Nested IF Functions
  • Naming Cells And Creating 3D Names
  • Applying Names To Formulas
  • LOOKUPfunctions
  • Formatting
  • Conditional formatting
  • Customising The Display
  • Freezing and splitting worksheets
  • Hiding and unhiding files, rows and columns
  • Utilities
  • The Watch Window
  • Charting
  • Creating and formatting 2D and 3D charts
  • Setting Up / Editing Worksheets
  • Inserting and clearing data
  • Linking and Grouping
  • Linking Worksheets
  • Consolidating Worksheets
  • Outlining
  • Setting Manual And Automatic Outline
  • Hiding And Displaying Outline
  • Working With Visible Data Only

See related categories

Excel 2007 Intermediate

£ 495 + VAT

The best Excel courses

See all

See all