Advanced Excel Functions and Arrays Course

Woodthorpe IT Solutions
Course summary
Length: 1 day
Price: 500 GBP excl. VAT
Language: English
Location: Nationwide
Next available date: Contact us to discuss dates (At your office) - Nationwide

Course Description

Excel Array Functions course

Delivered at your office this practical training course has been designed to give up to 8 attendees advanced knowledge of functions in Excel 2007, 2010, 2013 and 2016.  The course is delivered in a fun and interactive format, and participants are encouraged to ask questions during the day.

Why Woodthorpe IT Solutions?

  • Each attendee will be provided with a laptop.  (Up to 8 people per session).
  • Questions encouraged.  Courses delivered by industry experts who do not read from a manual.
  • Notes provided in electronic format.
  • Attendees will be sent a tips email every 2 weeks.
  • Attend free webinar sessions after the course.
  • Post course support provided via email with no time limit.

Suitability - Who should attend?

It is essential that attendees should already have a good working knowledge of Excel. 

Outcome / Qualification etc.

Each attendee will be given the tools to enable complicated data analysis and reporting.  They will receive an electronic attendance certificate. 

Training Course Content

Excel Array and Advanced Function Course

De-Arrayed Functions

  • Row()
  • Column()
  • Choose()
  • index() & match()
  • sumproduct()
  • offset()
  • indirect()

Array Functions

  • Introduction to Arrays
  • Array Constants
  • Single cell arrays
  • multi-cell arrays
  • horizontal arrays
  • vertical arrays
  • 2-dimensional arrays

Advanced Error Handling

  • Error prevention
  • automated vs. manual control
  • advanced error auditing
  • recovery i.e. dealing with corrupt spreadsheets


The cost for this in-house training is £500+VAT per day.

What is included?

  • Reasonable travel to your site on UK main land (Except to central London).
  • Provision of 8 laptops.
  • Provision of a projector.
  • Customisation of course content if required.

What is not included?

  • If the tutor has to travel more than 2 hours to the training site hotel costs may be applicable.
  • If the tutor has to travel to Central London train and taxi costs may be applicable.

Get Inspired! Watch the Video

Woodthorpe IT Solutions specialise in delivering onsite Microsoft Office training and providing consultancy support to businesses. We are a small and dedicated team who travel the length and breadth of the country providing our service. We have worked, and continue to work for companies such as Burberry, DeBeers, LVMH, John Lewis, Asics and many more.

Provider: Woodthorpe IT Solutions

Microsoft Office Training

Woodthorpe IT Solutions - Microsoft Office Training and Consultancy

We are here to help you get the most from Microsoft Office, our industry experts entertain and teach during any day we deliver for you.  No question is too small or problem too big for us to help you with, we...

Read more and show all courses with Provider: Woodthorpe IT Solutions

Request information - obligation free

Fill out your details to find out more about Advanced Excel Functions and Arrays Course.

  Contact the provider

  Get more information

  Register your interest


Contact information for Woodthorpe IT Solutions

Woodthorpe IT Solutions

4 Haycroft Close, Great Sutton
CH66 2GY Ellesmere Port, Cheshire

 Show phone number

Reviews by course attendees

Guy Dunk   |   28/07/2016
Good course, pitched at the right level for the trainees.
Christine Cramer   |   25/07/2016
well presented and informative course
Chris   |   22/07/2016
I've worked with Ben and Woodthorpe IT on a number of occasions over the past few years and the service and results have always been excellent.
Enter & win £50 voucher

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Request information

Find out more about this Advanced Excel Functions and Arrays Course course - simply fill out your details:

Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

Find more courses here