×

Search our courses

Course Summary

Our Microsoft Excel Expert 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:-
Users who wish to gain a comprehensive, in-depth knowledge of this application and improve their skills within Functions
Prerequisites
Prerequisites:-
Delegates must have attended an Excel Intro/Inter 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 30th April
  • Wednesday 24th July
  • Thursday 21st November
  • Thursday 9th January 2020

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

Course content – overview

  • Array Functions – FREQUENCY(), TRANSPOSE()
  • Single and Multiple Cell Array Functions
  • Import/Export Data and Queries
  • AGGREGATE()
  • Date and Time Functions
  • Analysing Data – Single and Two-Variable Data Tables
  • Creating Scenarios
  • What-If Analysis Using Goal Seek
  • Consolidating Data
  • Linking to External Workbooks
  • Text Functions
  • Financial Functions

Outcomes

On successful completion of the course, delegates will be able to work with array formulas, use various date, time, text and financial functions, use advanced techniques to analyse data, Import and export data.

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 Expert 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.