Skip to content

The Business Academy

Intermediate Excel

Who this course is for

Suitable for anyone with a working knowledge of Microsoft Office Excel. Learn how to use more advanced tools, shortcuts and applications to develop your performance and support your business.

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

View all our upcoming Business Academy courses

Scroll To Top