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.
Still copying and pasting data in Excel? Stop wasting hours on repetitive tasks. Imagine automating your most tedious processes in minutes, not days. Our Excel Office Scripts Introduction course delivers exactly that. In just one day, you will master the tools to build dynamic automations within Excel for the web. No programming background required. You will learn to record scripts, edit code with confidence, and deploy custom buttons that save your entire team time. This practical training transforms how you work, freeing you to focus on analysis rather than administration. Whether you join an open course or book a closed group session you will gain immediate, real world skills. Plus, this intensive session counts towards six CPD hours, adding value to your professional development. Take the first step towards effortless efficiency. To find out more, contact us at lets dash talk at e q v dot co dot uk.
Counts towards 6 CPD Hours 1 Day Open Public & Closed Group
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.
This course is designed for professionals who regularly work with data in Excel for the web and wish to streamline their workflows through automation. It is particularly suitable for those looking to reduce manual effort and enhance productivity without needing to transition into full-scale software development.
This course is ideal for:
Experienced Excel users who want to move beyond manual data entry and begin automating repetitive tasks
Data analysts seeking to build scalable solutions for processing and reporting large datasets efficiently
Business administrators responsible for maintaining spreadsheets who need reliable, repeatable processes
Finance professionals looking to automate routine reporting cycles and reduce the risk of human error
Team leaders who wish to create custom tools that can be easily shared and deployed across their department
Non-programmers interested in exploring low-code automation concepts within a familiar Excel environment
No prior programming experience required
You do not need a background in computer science or formal programming knowledge to succeed on this course. The curriculum is structured to introduce scripting concepts gradually, starting with simple recorded actions and progressing to more dynamic logic, ensuring that even those new to coding can build confidence and competence at their own pace.
What you will take away
By the end of the day, you will possess the practical skills to create, edit, and deploy your own Office Scripts. You will gain the ability to transform static spreadsheets into dynamic tools, allowing you to automate complex tasks, share solutions with colleagues, and significantly improve the efficiency of your data-driven processes.
For Groups & Teams
We can deliver this training session in several ways to suit your organisationโs needs:
Open Public Course
Join delegates from other organisations on a scheduled date
Closed Group
Exclusively for your team, using your real scenarios
In Person
Face-to-face at your premises or a venue of your choice
Virtual
Live, interactive online delivery via Teams or Zoom
One-to-One Coaching
Personalised sessions tailored entirely to you
Have two or more people to train?
You may want to consider a closed group course. Benefits include:
Cost effective for teams
Choose a date to suit you
Customise content and timings
No minimum delegate numbers
Uses your real-world scenarios
Builds shared language in your team
Contact us on [email protected] to discuss specific dates and delivery requirements.
How Our Tutor-Led Courses Are Delivered
Before the day
Delegates are given pre-work to complete before attending. This ensures everyone arrives with relevant context and real scenarios from their own experience, so learning is immediately relevant and actionable from the first minute.
On the day
Our sessions are participative and highly interactive. We donโt do โdeath by PowerPointโ โ instead, the day includes a variety of engaging activities throughout:
Real-world casework using your scenarios
Practical hands-on exercises
Real Play (not role play) simulations
Peer learning and group discussion
Case studies and scenario work
Facilitated discussion and structured reflection
What you leave with
Participants leave with:
Practical tools โ frameworks and models you can use straight away
Clear action plans โ specific next steps tailored to your role
Greater confidence โ built through intensive, realistic practice
Skills you can apply immediately โ not theory, but techniques tested during the day
After the day
Post-session measurements and a 30-day challenge ensure that learning is embedded and behaviour change is sustained.
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
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.