562 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
|Introducing two new Wise Owl courses on Office Scripts|
|This blog gives the background to Microsoft's decision to roll out Office Scripts, and explains why you might want to learn how to automate Excel using scripts, rather than VBA (and how you'd then go about doing this).|
You may have noticed recently that a new tab has appeared on your Excel ribbon:
The new Automate tab - what's this about?
If you click on this you'll see something like this:
Scripts? What are these?
The rest of this blog explains what scripts are, and why you might want to learn about them.
For some years now Microsoft have been trying to kill off Visual Basic for Applications, mainly because of the security risks it poses:
Every time someone chooses the options below, another Microsoft security expert experiences a cold wind of doom blow over them.
Here are some of the things they've tried:
Visual Studio Tools for Office
An attempt to provide a single coding environment within Visual Studio, this never really took off because most Excel coders aren't developers - just people trying to speed up their working lives.
In addition to this, Microsoft wanted to provide some way for programmers to automate Excel online workbooks (and there was no way they were going to let VBA run in their cloud!).
It seems to me that Microsoft have learnt from their past mistakes and got things right with the introduction of Office Scripts:
A typical Office Scripts function - if you're a web developer the language should look familiar.
We now offer the following Office Scripts courses:
An introduction to how to automate Excel using Office Scripts.
For those who have attended the introduction course, a more in-depth look at what you can do with scripts in Excel, including linking to Power Automate. At the moment this is only available as a tailored course.
So if you want to add to your CV, automate Excel in the cloud or just modernise your IT skills, here's your chance!
25 Aytoun Street