Request a callback
Email us

Business Booking Details

Payment Of Invoices

For bookings from established businesses, we do not require payment at the point of booking.

We will send you an invoice which you can submit to your accounts payable system.

Purchase Orders

If your employer uses a purchase order (P.O.) system to manage supplier invoices that is no problem.

  • If you already have a P.O. number when booking add it to the PO number box on the booking form, and we will include it on your invoice.
  • If you need an invoice to generate a P.O. number in your accounts system, please book the course as normal and add a note in the PO number box – to be provided
  • We will send you an invoice (without a P.O.) which you can use to generate a P.O..
  • We will then re-issue your invoice with your P.O. included when you provide us with it

PAYMENT METHODS:

You are not able to pay directly online at the time of booking, we issue an invoice for all bookings.

We accept payment either via direct bank transfer or card

Our invoices contain our bank details if you would like to pay by bank transfer and there is also information on how to pay by card.

Please note, if you are using a business card there is a surcharge of 2% to cover the payment processing charges.

Dynamic Array Formulas

Dynamic Array Formulas

4.79
19 reviews
microsoft-partner
feefo award

Master the new dynamic array formulas that Office 365 offers on this new Excel training course.

This powerful new feature allows formulas to return multiple results to a range of cells. These results are generated by a single formula entered into one cell.

It is a hands-on Excel course and includes plenty of time to try out what you are being taught.

✔ An Excel course focused exclusively on dynamic array formulas.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.

What Will I Learn?

You’ll return to the office with a detailed understanding of how to make best use of dynamic array formulas.

By the end of this course you’ll:

  • Understand how dynamic array formulas impact all Excel formulas.
  • Be comfortable using any dynamic array formula, for example, FILTER or UNIQUE
  • Understand how to handle the #SPILL error message
  • Be able to refer to dynamic ranges using #

Am I Ready For This Course?

This course is designed for advanced Excel users.

It assumes that you have either attended our advanced Excel training course, or have equivalent skills.

Course Details

Click on the sections below to see the full syllabus covered during this Excel training course.

  • What is an array formula?
  • Why are dynamic array formulas useful?

Examples of the most useful dynamic array formulas:

  • UNIQUE
  • SORT and SORTBY
  • FILTER (including tips for entering filtering criteria)
  • SEQUENCE
  • RANDARRAY
  • XLOOKUP and XMATCH
  • Handling the #SPILL error message
  • Using # to refer to dynamic arrays
  • How dynamic array formulas features impact all formulas

This Excel workshop includes a number of exercises including:

  • Multiple filters for tracking event seating
  • Emulating pivot tables with dynamic arrays
  • Keyword searches with FILTER

The Training Day

You don’t need to bring anything with you. We provide everything that you’ll need for a really great day’s training.

Our courses run from 9.30 am to roughly 4.30 pm with refreshments and biscuits throughout the day and a break for lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest instructors on the planet.

Also, you’ll receive:

✔ A full-colour A4 manual to keep which covers everything in the course.
✔ A USB stick so that you can take the course exercises home with you.
✔ A Certificate of Attendance.

Online Training Requirements

To attend this Excel course online, you will need:

✔ MS Excel on your Windows PC with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom

If you have access to a second screen, we would encourage you to use it as it improves the experience.