Woodthorpe IT Solutions Ltd


How we deliver our Excel Array Functions course

Contact us

  • We come to you
  • We bring all the equipment needed
  • The outline can be customised

Open Course Dates

  • You come to our venue
  • Suitable for individuals

Online Courses

  • Self paced
  • Budget Friendly
  • 24/7 Learning

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

What our customers say

© Woodthorpe IT Solutions Site by Ben Timney Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.
Performing arts school database Video

No flash installed

IFA Practice Manager

No flash installed

Production Scheduling Tool

No flash installed

Format As Table Part 1

No flash installed

Format as a table part 2

No flash installed

Subtotalling a list

No flash installed

Sorting basics

No flash installed

Cell Styles

No flash installed

Remove Duplicates In List

No flash installed