Seminar
Live WebinarIntermediate level
K2's Office Scripts – The New Macros
★★★★★
4.6 · 61 attendee ratings
Office Scripts is a new feature that allows you to automate tasks in Excel and other Office applications. Unlike VBA, a legacy language that runs only on Windows, Office Scripts can run on any platform and device that supports Office on the web. Further, Office Scripts has a modern and intuitive interface that lets you easily create, edit, and share your scripts. Office Scripts are stored in the Cloud, and they work with Office Online apps and integrate with Power Automate for process automation. Save time and improve productivity using Office Scripts in Excel and other Office applications.
Learning objectives
Upon completing this course, you should be able to:
- List three benefits of using Office Scripts over legacy VBA macros
- Distinguish the storage locations for Office scripts vs. VBA macros
- Identify four reasons why Office Scripts may not be available for use
- List two ways of sharing an Office Script with other users
Major topics
Introduction to Office Scripts
Recording your first script
Integration with Power Automate
Who this is for
This course is essential for business professionals seeking guidance on how to work with Office Scripts
Prerequisites: Fundamental knowledge of basic computer operations
What's included
Every registration comes with the course materials — yours to keep.
- Course handout PDF
- Demonstration & sample files ZIP
Course details
- Recommended CPE credit
- 2 — Computer Software and Applications
- Field of study
- Computer Software and Applications
- Program level
- Intermediate
- Delivery method
- Group Internet Based
- Prerequisites
- Fundamental knowledge of basic computer operations
- Advance preparation
- None
- Length
- 1h 40m
- Course number
- 24c-macros
- Provider
- K2 Enterprises
CPE Today (Devmatics, LLC) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors (Sponsor ID 167619). State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website, nasbaregistry.org. For information about our refund, complaint, and program cancellation policies, see Company Policies or contact [email protected].
Every way to take this course
How to attend this course
This course isn’t sold on its own — it’s offered exclusively at these events. One registration covers the event: you attend this course on its scheduled day, plus everything else the event offers.
Oct
1
Automation, Insight & High-Performance Analytics Week
Seminar · Sep 28 – Oct 1, 2026
· Online · this course runs Oct 1, 2026 · event offers up to 26 credits
$175/day
View event
Nov
12
Year-End Skill Strengthening & Productivity Strategies
Seminar · Nov 11–12, 2026
· Online · this course runs Nov 12, 2026 · event offers up to 10 credits
$125/day
View event
Your instructor
Lawrence A. "Mac" McClelland
Speaker & Author · K2 Enterprises · ★ 4.5 instructor rating
Mac McClelland, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas. Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business...
Full profile →Attendee feedback
4.6
61 attendee ratings
Attendee reviews
★★★★★
“I appreciate this class. It had me thinking about ways to implement this. I loved the examples, so thank you for sharing!”
★★★★★
“Instructor very knowledgeable and able to explain the material very well.”
★★★★★
“Loved the demos!”
Related reading from our instructors
You might also like
Seminar
Seminar
Conference
Seminar