Excel Array Functions | Woodthorpe IT Solutions Ltd

How we deliver our Excel Array Functions course

meeting_1

Buy online

Contact us

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

meeting_2

Dates

Open Course Dates

You come to our venue
Suitable for individuals

meeting_3

Buy now

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

Chris Bond
March 06,2015 / 0 Comments
We all picked up some new core skills as well as having the the opportunity to ask specific questions relevant to our daily jobs. This has led to some of the team finding more efficient ways to get through their daily workload.
Tony Miles
March 06,2015 / 0 Comments
The main impact of this is that income has been dragged forward some 4 months increasing profits in the first year of purchase many times covering the cost of the software.
Marie Lewis
March 06,2015 / 0 Comments
Ben’s commitment to their learning meant he stayed around to answerquestions and give additional training where it was needed
Layla Young
March 06,2015 / 0 Comments
Never before have I received such consistently positive and up-beat feedback questionnaires, than from the Excel training delivered by Woodthorpe IT; positive comments not only about the content and the format, but the friendly, supportive and tolerant manner in which is was delivered.
Joseph Orwin
March 06,2015 / 0 Comments
Ed went that extra mile and even stayed behind at the end of the course to cover additional items which weren’t included on the original agenda. Highly recommended and a pleasure to work with.
Cheryl Smart
March 06,2015 / 0 Comments
I would recommend Ben to anyone wanting to develop their own customer led software and requiring staff IT training.
Emma Meadowcroft
March 06,2015 / 0 Comments
Ben was very patient and even stayed behind for certain items that weren't on our original tailored agenda.
Lauren Mann
March 06,2015 / 0 Comments
Everyone loved the little tips you included within the training, your friendly manner and the attention you gave each of our group.
David Garnsworthy
March 06,2015 / 0 Comments
Ben also had numerous time saving tips and advice about potential pitfalls. Ben was very conscientious in his approach and at all times was willing and open to provide help with anything the course attendees did not understand.
De Beers
March 06,2015 / 0 Comments
The feedback from the delegates was very positive, they felt the training was relevant, easy to pick up and understand.
Julie Shipley
March 06,2015 / 0 Comments
From the time i emailed you with an enquiry the service has been 'second to none'. I particularly like the way you tailored the training for our individual needs
March 06,2015 / 0 Comments
The feedback from all our employees has been complimentary and I would certainly not hesitate to recommend that any company looking to improve their IT skills employ Woodthorpe IT Solutions.