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

Depending on your situation, you may be able to access a range of financial support available.

Course Fees


We do not currently have fee information available for this course. Please contact us for further information.


Apply or enquire about this course

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

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