Intermediate Microsoft Excel

Duration: 1 Day


To build on attendees’ existing knowledge of the application, with tuition in the more advanced or less obvious features to a level that will provide a deeper understanding and increased efficiency in the use of the software.


A working knowledge of Excel, or previous attendance on the Introduction to Excel course.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Workbooks and worksheets

  • Using Workbooks properly
  • Linking worksheets
  • Data consolidation
  • Using Group Edit to input data into more than one place

Conditional formulae

  • The IF() function
  • Using IF to produce a result with multiple possibilities using just one formulae
  • Using operators such as AND, OR and NOT
  • Using nested IF()s

More advanced functions

  • The LOOKUP() function
  • The INDEX() function
  • The MATCH() function

Using Range names

  • Overview of working with Range names
  • Naming cell ranges in efficient ways
  • Changing and deleting Range name
  • Jumping quickly to a named Range
  • Using Range names in formulae
  • Using Range Finder

Outlining and Pivot Tables

  • Using the Outline feature to produce a collapsible formula sheet
  • Creating an Outline manually
  • Showing and hiding detail data
  • Understanding Pivot tables
  • Creating a Pivot Table
  • Adding fields to a Pivot table
  • Charting a pivot table
  • Formatting pivot tables
  • Hiding or displaying items in a Pivot Table
  • Displaying sub-totals and totals in rows and columns

Brief introduction to Macro recording

  • Recording simple Macros
  • Playing back Macros
  • Assigning Macros to buttons
  • The limitations of recorded Macros; considering further development with VBA


  • Cell and document protection
  • Customising Excel

This course is available as a private or customised course. Contact us for further information and to customise this course to your exact requirements:

Phone us: 0208 269 4260Book Now

"Trainer's knowledge was immense, clearly an experienced practitioner."

Joseph Chamberlain College

"An excellent presentation, very clearly explained and enjoyable at the same time. Has given me confidence in using this software."

RAF Culdrose

"Informative, useful, relaxed - Excellent! Will certainly use Transmedia again."

Tate & Lyle

© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260       Privacy Policy