No items found.

Automate Excel with Office Scripts and Power Automate

20 & 21 May 2025
18:00-21:00 BST
Online-only

Learn how to free up your time by automating your processes, as Microsoft MVP Mark Proctor hosts this special in-depth online Masterclass.

Office Scripts is the new simple and intuitive language designed specifically for non-programmers who wish to automate Excel. When combined with Power Automate, you can build cross application automated processes that run in the background (you don’t even need to click a button — it runs when you sleep!).

This Masterclass starts with the fundamentals and, through practical examples, demonstrates how all the pieces fit together to build robust solutions. By the end of the Masterclass, you will be confident to write your own scripts from scratch and build simple end-to-end automation processes.

What you'll learn?

  • Fundamentals of Office Scripts (Excel Document Object Model and TypeScript)
  • How to use the script recorder
  • How to write your own scripts from scratch
  • Write reusable scripts to work with any workbook
  • Fundamentals of Power Automate
  • Using Office Script with Power Automate to build self-running automations processes that operate in the background

This Masterclass will be delivered by Microsoft MVP Mark Proctor on 20 & 21 May 2025 as an online-only course.
This is available as a single course or as part of our Premium Online Global Excel Summit 2026 ticket (includes conference + 1 Masterclass), as well as our Ultimate Online Global Excel Summit 2026 ticket (includes conference + 2 Masterclasses).

Who is it for?

This Masterclass is for anyone using Excel for Microsoft 365 who wants to automate their boring and repetitive processes. Typical job titles that could particularly benefit include:

  • Finance professionals
  • Business professionals looking to automate repetitive tasks
  • Data analysts
  • IT professionals aiming to enhance productivity

Download Event Brochure

Download Now →

What's included?

Check Icon
6 hours Masterclass with Mark Proctor, Microsoft MVP
Check Icon
6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
All downloadable presentation and working files
Check Icon
Masterclass recording
Check Icon
Certificate of attendance
Check Icon
Join from anywhere in the world
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
Check Icon
Missing Item
Course contents
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Data profiling with Power Query

✔︎ What is “extract, transform, load,”?
✔︎ How data profiling works in Power Query and why it matters
✔︎ First steps for profiling and cleaning the data

Right Arrow Icon
Efficient reporting with Power Pivot

✔︎ Avoid memory-draining “Frankentables” and build relational data models and reports right from Excel
✔︎ Power Pivot and DAX for data analysis in Excel

Right Arrow Icon
Efficient analysing with dynamic array functions

✔︎ What are dynamic array functions?
✔︎ Learn how to build quick, responsive formulas for easy analysis.

Right Arrow Icon
Supercharging Excel with generative AI and Copilot

✔︎ Boost Excel with generative Ai and Copilot
✔︎ Use natural language propmpts to simplify Python scripting, uncover insights and streamline workflows for even faster and easier analytics

Right Arrow Icon
Citizen data science with Python in Excel

✔︎ What is Python and why has it become the glue that binds today’s data analytics stack.
✔︎ Learn basic Python scripting to build compelling analyses and visualizations that would otherwise be difficult or impossible to do in Excel

Right Arrow Icon
6x expert-led Masterclasses

Course contents

Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Session 1 - Data Structures and Sources

Excel hasmoved beyond the classic grid that we love and now includes tables, spillranges, trimmed ranges, rich data types and the data model to name a few. Learnhow to take advantage of these different data structures and when to use them.


Right Arrow Icon
Session 2 - The Best Functions

Learn the best functions in Excel and combine them with good practice for optimal results. Master GROUPBY, PIVOTBY, CHOOSECOLS, CHOOSE, XLOOKUP, INDEX,TAKE and OFFSET.


Right Arrow Icon
Session 3 - Dynamic Formulas for Interactive Reporting

Learn to create dynamic and interactive reports using advanced formulas that respond to user inputs or changes in data, enhancing the flexibility and usability of your spreadsheets.


Right Arrow Icon
Session 4 - Copilot in Excel

Copilot is here for everyone, even those with advanced Excel formula skills. Utilise Copilot for Excel formula assistance.


Right Arrow Icon
Session 5 - LAMBDA Functions

Step into modern Excel formula writing using LAMBDA functions such as SCAN, BYROW, custom LAMBDAs and LET. Make robust, fast and dynamic Excel formulas.


Right Arrow Icon
6x expert-led Masterclasses

Training requirements

Attendees will need an Office Scripts compatible licence in Microsoft 365. Check the current compatible licences. If you have the Automate tab in Excel, then you have a compatible licence.

There is no previous coding experience required to attend this Masterclass.

About the trainer

Profile Pic

Mark Proctor

Mark Proctor is a qualified accountant, consultant and blogger who has been applying spreadsheet-based solutions to solve real-world problems for over 20 years. Whilst working in the media, food, retail, and manufacturing sectors, he has built extensive dashboard, reporting, and process automation tools to achieve greater business insight and efficiency.

Mark Proctor is also the owner of Excel Off the Grid, which started in October 2016. The site focuses on teaching intermediate and advanced Excel techniques so workplace warriors can become more efficient in Excel.

What people think of

Mark Proctor

★★★★★

I owe my success to this course!

I am very happy to have found Excel off the Grid. I recently implemented an Office Scripts project and I owe my success to it.

John L

★★★★★

Mark explains everything really well!

Mark explains everything really well with lots of great examples to start automating tasks, and even includes a whole section on Power Automate.

Shirley M

Full ticket details:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
3x Expert Masterclasses

Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant data visualisation, analytics and Power Query topics.

✔︎ Masterclass with George Mount: Excel Analytics 2.0
✔︎ Masterclass with Ann K. Emery: Designing and Building Interactive Dashboards in Excel
✔︎ Masterclass with Chandeep Chhabra: Advanced Data Cleaning Using M in Power Query

Right Arrow Icon
Tech & Innovation Track

Check out the introductory keynotes from Microsoft and world-renowned MVP Leila Gharani. Software developers showcase add-ins that transcend Excel's limitations, plus robust panel discussions and expert insights complete the Tech & Innovation Track!

✔︎ Keynote by Microsoft: Transforming Excel through research and AI
✔︎ Keynote by Leila Gharani
✔︎ Actionable Data Storytelling in Excel with Zebra AI
✔︎ AI: Sorting fact from fiction
✔︎ Python in Excel: First Steps
✔︎ Teaching Excel with AI
✔︎ Is AI taking over the role of the data analyst?
✔︎ How to build re-usable Excel automations with AI
✔︎ Empowering learners to Excel with digital skills certifications
✔︎ Kids meet spreadsheets
✔︎ Corporate charts inspired by social media
✔︎ ChatGPT: Match Made in Heaven or Hell..?
✔ Turn Excel models into Web apps: features, sharing, monetization
✔ Panel discussion: The future of Excel in an AI world
✔ Panel discussion: Does being Excel-certified matter?

Right Arrow Icon
Finance & Accounting Track

Harness the power of Excel and Power BI for budgeting, forecasting, and modelling. You'll master dashboards, P&L statements, and learn to build bullet-proof models that won't disintegrate!

✔ Client's perspectives on quality — lessons from a career in financial modelling and what that means for the future
✔ Dynamic Arrays - A financial modelling game changer
✔Upgrading financial modelling — how, who, and why?
✔ Fivecasting: One Better than Forecasting
✔ A bank’s perspective on Excel and AI

Right Arrow Icon
Data Visualisation & Analytics Track

Showcase your data with insightful visuals and learn the secrets of presenting it for effective communication. You'll also create custom charts, intuitive analytic experiences, and write DAX expressions for true flexibility!

✔ Is this an Excel chart?!? - 5 ways to take your boring charts to the NEXT Level
✔ Interactive Data Visualisation for decision support using Excel
✔ How to create an intuitive analytic experience in Excel using Script Labs
✔ Dynamic dashboard creation for KPI reporting using Power BI

Right Arrow Icon
The Power Stack Track

Expand your understanding of Power Query, Power Pivot, Power BI, and Power Automate. You'll arm yourself with the latest time-saving functionalities, powerful visualisations & expert techniques.

✔ Why use Power Query to solve practical data cleaning problems?
✔ 5 Things every Excel user should know about Power BI
✔ Using Git in Power BI for effective teamwork and version control
✔ Overcoming real-world problems with Power BI
✔ Power Query on Excel for Mac

Right Arrow Icon
Formulas & Automation Track

Discover the Excel hacks and best practices that empower you to do more with less. Whether it's formulas, keyboard shortcuts, or named ranges, you'll turbocharge your workflow!

✔ Optimising the Monetisation of Spreadsheets
✔ LAMBDA - There is no stopping you
✔The *NEVER SEEN* Tips & Tricks by Bob Umlas
✔ Converting spreadsheets into web apps; 3 apps in fifteen minutes
✔ 5 ways for analysts to leverage 'Analyze Data’ in Excel
✔Combine Data in Excel Like A Pro
✔ Why VLOOKUP when there is Power Query?

Right Arrow Icon
3x Masterclasses

Discover the Excel hacks and best practices that empower you to do more with less. Whether it's formulas, keyboard shortcuts, or named ranges, you'll turbocharge your workflow!

✔ Excel Analytics 2.0 with George Mount
✔ Designing and Building Interactive Dashboards in Excel with Ann K. Emery
✔ Advanced Data Cleaning Using M in Power Query with Chandeep Chhabra

Get Product

Please submit proof of student status  before proceeding to checkout.
Max file size 10MB.
Uploading...
fileuploaded.jpg
Upload failed. Max size for files is 10 MB.
Thank you! Your file has been attached successfully.
Oops! Something went wrong while attaching your file. Please try again.

If you continue experiencing issues, you can send it to us via email to info@globalexcelsummit.com
Expires 30 April
Total (incl. VAT):
SAVE 40% - BLIND TICKET
Expires 30 April
SAVE 30% - Early bird
SAVE 15% - NEW YEAR GIFT 🎁
£ 196.00 GBP

£ 280.00 GBP

✔︎ Recordings and downloadable files included
✔︎ CPD Certificate of attendance included
✔︎ Free cancellation up to 30 days prior to the event
✔︎ 2 Masterclasses included
✔︎ CPD Certificate of attendance included
✔︎ Free cancellation up to 30 days prior to the event
✔︎ 1 Masterclass included
✔︎ CPD Certificate of attendance included
✔︎ Free cancellation up to 30 days prior to the event
✔︎ Free cancellation before 15 Apr 2025.
✔︎ Event Recording and all speaker files included.
✔︎ Claim 6 CPD points - this is an approved Continuing Professional Development (CPD) course.

Run this Course In-House
✔︎ 30% Early Bird discount expires on 30 Apr 2025 at midnight.
✔︎ Free cancellation before 15 May 2025.
✔︎ Event Recording and all speaker files included.

Run this Course In-House
An icon that shows a camera or video.
Expert Footage: 12 hours
An icon that shows a camera or video.
Expert Footage: 35+ hours
An icon that shows a camera or video.
Expert Footage: 25+ hours
An icon that shows a lock.
Access to all speaker files
An icon that shows a star.
Watch any time, from anywhere
An image that shows CPD accreditation.
CPD accredited content
Calendar Icon 22 June
20 & 21 May 2025
Schedule Icon - Time
18:00-21:00 BST
Location Icon
Online-only
Level icon
Level:
Money back guarantee
Money back guarantee
20 & 21 May 2025
18:00-21:00 BST
Online-only

2026 Blind Tickets almost sold out!

In-person Blind tickets for the upcoming Global Excel Summit 2026 conference are now sold out. Only a few more ONLINE ones remaining! Secure 40% OFF discount today.

Secure Your Place
Close Cookie Popup
Cookie Preferences
By clicking “Accept All”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage and assist in our marketing efforts as outlined in our privacy policy.
Strictly Necessary (Always Active)
Cookies required to enable basic website functionality.
Cookies helping us understand how this website performs, how visitors interact with the site, and whether there may be technical issues.
Cookies used to deliver advertising that is more relevant to you and your interests.
Cookies allowing the website to remember choices you make (such as your user name, language, or the region you are in).