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

"The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly."

Hannah Griffiths

"Amazing industry knowledge."

The Economist Group

"Excellent. The best training I have ever had."

National Housing Federation

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