Skip to content

Intermediate Excel

This intermediate excel course will teach you how to use more advanced tools, shortcuts and applications to develop your performance and support your business.

Intermediate Excel overview

This intermediate excel course will teach you how to use more advanced tools, shortcuts and applications to develop your performance and support your business.

Who the Intermediate Excel course is for

Suitable for anyone with a working knowledge of Microsoft Office Excel.

What you'll learn

  • Excel 2003 v 2007 v 2010 (and later)
  • Quick Access Toolbar
  • Named Ranges
  • Data validation (using Named Ranges)
  • Absolute Values
  • Data Transfer between worksheets and spreadsheets
  • Conditional Formatting
  • Formula Auditing
  • IF Statements and Formulas
  • VLOOKUPS
  • 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

Course duration

1 day

Fees and booking

Get in touch

Whether you have a suggestion about Intermediate Excel content or need information about course dates, we can help.

Scroll To Top