Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
551 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers 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
Search our website
We also send out useful tips in a monthly email newsletter ...
Fourteen new functions coming to Excel Part one of a three-part series of blogs |
---|
Get a preview of the 3 text functions and 11 array functions coming to your version of Excel very soon!
|
It's not that often Excel gets any new functions, but 14? Truly these are momentous times. Here's a quick summary of the new functions (as covered in the other parts of this blog):
Family | Notes |
---|---|
Splitting text | TEXTBEFORE, TEXTAFTER and TEXTSPLIT |
Combining arrays | HSTACK and VSTACK |
Reshaping arrays | TOROW, TOCOL, WRAPROWS and WRAPCOLS |
Resizing arrays | TAKE, DROP, CHOOSEROWS, CHOOSECOLS and EXPAND |
If you've worked with arrays in NumPy using Python, you'll know where Microsoft got the idea for all of the array functions shown above!
Microsoft roll out new Office 365 updates at different times to different users, but you can get an idea of your place in the pecking order by seeing what channel you're on.
Choose the Account option from the File menu in Excel to see which channel you're using.
I've bravely upgraded my laptop to the beta channel, which is why I can see the new features (even then I had to do a bit of coaxing to get them to install):
The About Excel button shows that I'm on the Beta Channel. Chances are that you will be either on the monthly channel (in which case you'll get updates soon after they go on general release) or the semi-annual channel (in which case you may wait up to 6 months).
It's always worth clicking on the drop arrow on the Update Options button above to check that you have the latest update installed!
Parts of this blog |
---|
|
Some other pages relevant to the above blogs include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.