Excel Office Scripts an Introduction

Excel Office Scripts an Introduction

This one-day course provides a practical introduction to Excel Office Scripts, helping delegates automate repetitive tasks and improve efficiency within Excel for the web. Participants will learn how to create and edit recorded scripts, navigate the Automate tab, and work confidently with the Office Scripts code editor. The course covers key scripting concepts such as variables, functions, ranges, worksheets, tables, conditional logic, loops, and arrays, enabling learners to build dynamic and scalable automations. Delegates will also explore how to run, share, and deploy scripts using custom buttons, making automation accessible to wider teams. Ideal for experienced Excel users, analysts, administrators, and business professionals who regularly work with data, this course is designed for anyone looking to reduce manual processes and take their first steps into Excel-based automation without requiring a formal programming background.

Counts towards 6 CPD Hours
1 Day
Open Public & Closed Group


✉ Enquire About This Course



Pre-Course Reflection

Please reflect on one or more of the questions below and come prepared to discuss your responses during the session.

  • Self-Assessment: On a scale of 1โ€“10, how would you rate your current skill level in this subject? What factors influenced your rating?
  • Development Focus: Identify one specific behaviour, skill, or capability you would like to improve or develop further.
  • Relevant Examples: If possible, bring one or two relevant examples or scenarios from your experience that you would be willing to share with the group.

What You Will Learn

Getting Started
Navigating the Automate Tab
Creating a basic script
Reading & editing recorded scripts
Working with the code editor
Function concepts
Writing to console
Working with Data
Using Variables
Working with Ranges
Working with Sheets
Moving from Fixed to Dynamic Ranges
Table structures
Adding Logic Structures
Conditional Statements
Dealing with Loops
Working with 2D arrays
Running & sharing scripts
Adding Script buttons
Sharing Scripts

Your Post-Course Challenge

  • Reflect on the key topics covered and identify one area to apply immediately.
  • Share one insight or action point with a colleague within the next week.
  • Review your notes after 30 days and assess your progress.

Counts Towards 6 CPD Hours

This course contributes 6 hours of Continuing Professional Development. Delegates can log these hours as evidence of structured learning for professional bodies and employers.

Key Features

Course Duration is 1 Day

Comprehensive course materials

Certificates of attendance

Access to Customer Portal (course bookers)

Course Guarantee

Priced per person for virtual open public course

£295.00 Plus VAT

Select a Date

10/12/2026ยฃ295.00 Plus VAT
21/01/2027ยฃ295.00 Plus VAT
23/02/2027ยฃ295.00 Plus VAT
25/03/2027ยฃ295.00 Plus VAT
27/04/2027ยฃ295.00 Plus VAT
27/05/2027ยฃ295.00 Plus VAT
29/06/2027ยฃ295.00 Plus VAT

Can’t see a suitable date? Please request a date here

Payment available via all major credit cards or Invoice. All options available during the online booking process.