564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Find out how dynamic arrays in Excel will change your (working) life!
Part one of a six-part series of blogs
Dynamic arrays are a new feature being rolled out in Excel 365. This blog explains how they work, and why they will make so many things in Excel easier.
With apologies to Harold Macmillan:
"The wind of change is blowing through this software and whether we like it or not, this growth of functionality is a technological fact".
Or to put it another way ... get ready for dynamic arrays in Excel! This blog explains how to find out if you can use dynamic arrays yet, shows how to use them and then gives three case studies showing some of the implications of this brave new world.
See my separate blog on the new(ish) XLOOKUP function for more on this specific function.
|Parts of this blog|
Some other pages relevant to the above blogs include:
25 Aytoun Street