Microsoft Excel 2010 Intermediate

Course Details

This Excel course is aimed at those who wish to build on their knowledge of Microsoft Excel and gain a more detailed understanding of what the software can offer.

Our Microsoft Excel courses are delivered in over 50 locations nationwide. The course is accredited by Microsoft and includes all course materials, a manual and a certificate.

Course Contents


Advanced File Tasks

  • Using Windows Explorer within Excel
  • Saving your Files
  • Using File Management Tools, Part One
  • Using File Management Tools, Part Two

Working with Functions and Formulas

  • Using Formulas in Excel
  • Exploring Excel Functions
  • Using Functions in Excel
  • Working with Names and Ranges
  • Working with Array Formulas

Managing Tables

  • Working with Tables
  • Working with Records and Fields
  • Working with Tables and Filters
  • Using Excel as a Database

Adding the Finishing Touches

  • • Research Tools • Using Themes • Adding Text Boxes • Inserting Pictures and ClipArt • Editing Pictures

Showing Data as a Graphic

  • • Inserting SmartArt • Formatting SmartArt • Adding Symbols, Equations, and Shapes • Sparklines • Editing Sparklines


What are the prerequisites for this course?

We recommend being familiar with the basics of Microsoft Excel.

What am I provided on the course?

You will be provided with an official courseware folder, detailed user-friendly manual, pre/post course email support, refreshments and a certificate of completion.

Who will be instructing me?

You will be a taught by a qualified, knowledgeable instructor with years of experience in their field.

When should I arrive to the venue?

You should aim to arrive at 9am.

How can I contact you?

If you would like more information about any course please feel free to either contact us on 01159 031 029 or you can email us at