×

Search our courses

Course Summary

Our Microsoft Excel Intermediate course is a highly practical and interactive tutor-led session delivered by highly experienced Microsoft Certified Trainers. Delegate numbers are kept low to ensure individual support can be given to each participant. Courses can be delivered on your premises on dates that suit you or you can complete the course at one of our public courses in London or Bristol.

Workshop Duration:-
1 Day
Target Students:-
Existing users of Excel who wish to develop their skills in this application and learn more about the functions and database facilities.
Prerequisites
Prerequisites:-
Delegates must have attended an Excel Introductory course or have an equivalent working knowledge of Excel.

Course format

Classroom based learning delivered by highly experienced Microsoft Certified Trainers. Very interactive session with plenty of hands on, applying new learnt skills throughout the day with exercises.

Manual provided and unlimited support after the training, backed up with a Certified Certificate at the end of the session.

Private course:

  • On your premises – anywhere throughout the UK or Europe
  • Dates to suit you
  • Maximum number of delegates 8 to ensure dedicated individual attention when required

Public Course Dates (Bristol & London):

  • Tuesday 12th March
  • Wednesday 12th June
  • Thursday 3rd October
  • Monday 16th December

Laptops can be provided, or you can bring your own, refreshments provided throughout the day and a lunch.

Course content – overview

  • Overview of introductory topics e.g. formulas/functions, absolute referencing
  • Charting
  • Outlining – Group and Ungroup Data
  • Group Edit
  • Conditional Formatting
  • Understand logical functions IF, OR, and AND functions
  • Using NESTED IF Functions IFERROR
  • Database Management – Sorting and Filtering
  • SUMIF()/COUNTIF()
  • SUMIFS()/COUNTIFS()
  • SUBTOTAL()
  • Pivot Tables
  • Slicer and Timeline

Outcomes

On successful completion of the course, delegates will be able to produce effective graphs, working with Sorting and Filtering Data, apply conditional formatting, understand logical functions and additional functions including SUMIF(), SUMIFS(), COUNTIF(), COUNTIFS(), SUBTOTAL(), use the Pivot Table functionality within Excel.

What our delegates have to say

"Very Informative." - Owen

"Kam was friendly, really helpful and informative." - Denise

"Well done to Caroline, brilliant course, learnt loads." - Angus

"Great course - informative and engaging." - James

"Very good and useful. Refreshed my knowledge on excel and gained new skills."

How to book your space

Interested in booking a space on one of our Microsoft Excel Intermediate courses or want to find out more details? Fill out our “Register Interest” form we’ll get back to you as soon as we can with further information. Or call us today on 01454 203 355.