Jump directly to main content Jump directly to menu

Excel Intermediate

Customised programme

Key Information

  • Duration

    1 day

Apply or Enquire

The course covers the following –

  • Excel 2003 v 2007 v 2010 (and later);
  • Quick Access Toolbar;
  • Named Ranges;
  • Data Validation (using Named Ranges);
  • Absolute Values (‘Locking’ the cell reference);
  • Data Transfer between worksheets and spreadsheets;
  • Conditional Formatting;
  • Formula Auditing;
  • IF Statements and Formulas;
  • Inserting Charts;
  • Sub-totals;
  • Pivot Tables;
  • Paste Options;
  • Date and Time Functions;
  • Placing Existing Data into a ‘Table’;
  • Themes;
  • Adapting the view of the Spreadsheet;
  • Inserting ‘Screen-Shots’;
  • SmartArt Graphics;
  • What-If Analysis;
  • Macros

Financial Support

UK students can take out a tuition fee loan to cover the cost of their course and a maintenance loan to cover living costs.

We also have a range of other financial support available.

Course Fees


Total Cost: £150.00


Apply or enquire about this course

Please use the following links to make an enquiry about this course.

Apply online Make an enquiry Call 01724 294040

Information for EU Students

From January 2021, how you apply for a course will change. For more information, read the UK Government's guide for the UK points-based immigration system for EU students (pdf).

Visit our International pages for more information and contact details