Woodthorpe IT Solutions Ltd

Excel-Array-Functions

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.