ICAEW.com works better with JavaScript enabled.

A beginner's guide to automating in Excel using Office Scripts

Author: ICAEW Excel Community

Published: 26 Nov 2024

Office Scripts is a feature that allows users to automate repetitive Excel tasks.

Whether you’re a beginner or an experienced user of Excel, Office Scripts will allow you to create and run scripts without any coding knowledge or background.

In this webinar, Mark Proctor, Microsoft MVP and Director at Excel Off The Grid, will cover the basics and demonstrate how to create and run scripts in Excel to automate tasks. Mark will also explore how Office Scripts compares to VBA when choosing one over the other and how they can complement each other.

This webinar will cover real-world use cases from data manipulation to report generation and scenarios where scripts can significantly enhance your Excel experience.

First broadcast on 26 November 2024

Webinar resources

Additional resources

Please be aware that this webinar has closed captions enabled. In order to enable this feature, please click on the “CC” icon at the bottom of your screen. Please note that the transcript is automatically generated and errors may occur.

CPD

This webinar could contribute to up to 1 hour of verifiable CPD, so long as you can demonstrate that the content is relevant to your role. Find out more.

Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250