K2's Office Scripts – The New Macros
Online
2.00 Credits
Member Price $79.00
Price will increase by $10 after 11/5
Non-Member Price $114.00
Price will increase by $10 after 11/5
Overview
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.
Objectives
- 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
Highlights
- Introduction to Office Scripts
- Recording your first script
- Integration with Power Automate ,/ul>
Designed For
This course is essential for business professionals seeking guidance on how to work with Office Scripts
Prerequisites
Fundamental knowledge of basic computer operations
Preparation
None
Notice
To access this program, log into your CTCPA account at https://www.ctcpas.org/my-cpe/upcoming and click on the orange "Launch Event" button.
Leader(s):
Leader Bios
Brian Tankersley, Director of Strategic Relationships, K2 Enterprises, LLC
Brian Tankersley is a consultant who advises US firms and companies on accounting technology issues. Mr. Tankersley is a frequent speaker at continuing education courses for K2 Enterprises, writes for multiple accounting media outlets, and publishes a nationally recognized blog on accounting and technology (www.cpatechblog.com). Mr. Tankersley has over 30 years of professional experience, including accounting, auditing, technology, and education, has been with K2 Enterprises since 2005.
Tankersley has been recognized eight times as one of the “Top 25 Thought Leaders in Public Accounting Technology” by Cygnus Business Media. Brian has made presentations in 48 of the 50 US states and has served as a guest speaker for many professional accounting organizations across Canada. He has received numerous awards for his writing and speaking from state CPA societies. Brian has presented sessions at most major national accounting technology conferences, including AICPA TECH+/Practitioners Conference, The Sleeter Group’s Solutions Conference, Sage Summit, CCH Connections, and Thomson Reuters Synergy User Conference.
Brian is a certified public accountant (Tennessee), a certified information technology professional (CITP), and a Chartered Global Management Accountant (CGMA). He holds bachelor’s degrees in both Accounting and Finance, cum laude, from the University of Tennessee. Tankersley also maintains numerous vendor software certifications, and is a member of the Tennessee Society of CPAs and the American Institute of CPAs.
Brian and his family make their home in Farragut, Tennessee.
Non-Member Price $114.00
Member Price $79.00