Microsoft Excel Intermediate Courses

Intermediate Microsoft Excel Training Course Information

Microsoft Excel Intermediate Training Courses

Microsoft Excel Training COurse

Our fee for a standard onsite Excel Intermediate course £545 + VAT
Includes up to 4 people onsite. Additional attendees: £35 + VAT per person.

  • Instructor-led Excel training (non-tailored)
  • Delivered onsite at your location (up to 4 people)
  • Printed reference materials for each attendee
  • Trainer travel is included

Perfect for: Small teams who want a focused, hands-on Excel course on the key skills used within the workplace.

This equates to about £75.00 plus vat per person (assuming 10 people attend), with each person receiving a supporting reference manual and course attendance certificate.

(Course tailoring is available for a small additional fee.)

 

Keys Training also deliver regular scheduled Excel Intermediate courses at our venues.

1 Day Excel Intermediate Course | 1 delegate £225.00 plus VAT
*Book 2 or more delegates and receive significant discounts. Click here for information.

Scheduled public courses are held at Preston, Liverpool, Manchester & London.

Introduction

This one-day instructor led course is designed to develop the practical skills of Excel users. By the end of the course delegates will be able to use to full advantage a greater range of available Excel functions in order to produce more effective spreadsheets.

Course Objectives

  • Use advanced formulas and functions
  • Define names for individual cells and ranges
  • Use the database tools in Excel
  • Work effectively with large spreadsheets

Pre-requisites

This course is designed for delegates who have completed the Excel Level 1 course or have equivalent knowledge. Delegates should already be able to create formulas, use basic functions such as SUM, MIN, MAX and COUNT and also be aware of the difference between relative and absolute references.

Course Content

Functions

  • IF functions
  • VLOOKUP and HLOOKUP
  • Function to combine data from multiple cells
  • Data functions
  • Nested functions

Tools

  • Naming cells and ranges
  • Protecting cells
  • Linking workbooks
  • Linking applications (Excel with Word or PowerPoint)

Database tools

  • Sorting data – ascending, descending, left to right
  • Sorting data in custom sequences
  • Filtering data with AutoFilter
  • Creating customised and advanced filters
  • Using data forms to enter, delete and search for data
  • Using subtotals to calculate sub sets of data

Formatting

  • Hiding columns, rows and formulas
  • Grouping columns and rows
  • Applying conditional number formatting