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

From £500 per day
(additional expenses may be payable)

Open Course Dates

  • You come to our venue
  • Suitable for individuals

From £175 per day per person

Online Courses

  • Self paced
  • Budget Friendly
  • 24/7 Learning

From £29 per person


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

North West Office

Woodthorpe IT Solutions Ltd
4 Haycroft Close
Great Sutton
Ellesmere Port
Cheshire
CH66 2GY

Registered No. 05572129

VAT No. 936 2824 09

North East Office

Woodthorpe IT Solutions Ltd
13 Queensway House
Middlesbrough
Cleveland
TS3 8TF

Telephone

0800 044 3779

Email

contactus@woodthorpeitsolutions.co.uk

top
© 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

×