$120 (per person) includes an online webinar for 2 hours of CPE credit
Excel macros can help to streamline and automate tasks that are routine and time-consuming.
In this webinar, you will start by learning how to create a basic macro in Excel to perform formatting of a spreadsheet.
We will then talk about VBA (the programming language for Excel) and how to use Microsoft Help topics to create commands and micros using VBA.
Then we will create a macro that creates a chart and another macro that imports a text file.
We will also talk about how absolute versus relative references in a macro – and a lot more cool and useful things about Excel macros.
This webinar will be a hands-on workshop where you can try out the macros as we demonstrate them. By the end of the webinar, you will know how to use macros to make your work in Excel more automated, and therefore faster and a little more fun!
This webinar is designed for Excel for Windows users because much of the macro and VBA functionality is not available in Excel for Mac.
After attending this webinar, participants will be able to:
- Record a macro to automate routine tasks
- Assign a macro to a button in Excel
- Use VBA to create macros in Excel
Program Level: Beginning
Field of Study: Auditing
Who Should Attend: Auditors
Instructional Method: Webinar (Group Internet Based)
Advanced Preparation Required: Participants should have Excel for Microsoft 365, Excel 2021, Excel 2019, or Excel 2016 installed on their computer prior to attending this workshop.
CPE Credit Hours: 2
Date: Thursday, June 9, 2022
Time: 12:30 p.m. – 2:30 p.m. Central
Excel Time-Saving Macros Made Easy Webinar Leaders:
Wendy Tietz, Professor, Kent State University
Wendy M. Tietz, PhD, CPA, CMA, CSCA, CGMA, is a professor in the Department of Accounting in the College of Business Administration at Kent State University, where she teaches financial and managerial accounting. Dr. Tietz is a Certified Microsoft Trainer and has earned the Microsoft Office Specialist Excel designation. She is a member of the American Accounting Association, IMA, AICPA, and the Ohio Society of CPAs. She has published articles in such journals as Issues in Accounting Education, Journal of Emerging Technologies in Accounting, IMA Educational Case Journal, and others. Dr. Tietz has received several national teaching awards and is the co-author of two accounting textbooks published by Pearson Education.
Tracie Miller-Nobles, Professor, Austin Community College
Tracie L. Miller-Nobles, CPA, is an associate professor at Austin Community College. Prof. Miller-Nobles received her master’s degree in accounting and is working on her doctoral degree in Adult Education from Texas A&M University. She is on the Board of Directors for the American Accounting Association and on the Board of Directors for Teachers of Accounting at Two-Year Colleges. Tracie has received several teaching and professional awards including the AAA J. Michael and Mary Anne Cook Prize, TXCPA Outstanding Accounting Educator, and TXCPA Rising Star. Prof. Miller-Nobles is a co-author of Horngren’s Accounting published by Pearson.