Description

$150 (per person) includes an online webinar for 2 hours of CPE credit

Government auditors can transform their daily workflow with this comprehensive webinar. Participants will discover how to leverage advanced Excel formulas, including VLOOKUP, XLOOKUP, dynamic arrays, and logical functions that streamline complex calculations and automate routine audit tasks. This practical approach focuses on real-world applications, showing auditors how to reduce hours of manual work into efficient, automated processes that minimize errors and strengthen data reliability. Beyond powerful formulas, participants will gain hands-on experience with pivot tables, the cornerstone of modern audit reporting. The course demonstrates how to create dynamic reports, implement advanced calculations, and design intuitive data visualizations that support findings, conclusions, and recommendations. Auditors will walk away with immediately applicable skills that strengthen analytical capabilities, improve the reporting process, and add significant value to their audit function. This course bridges the gap between basic Excel knowledge and the advanced techniques needed in today's data-driven audit environment, making it an essential investment for government auditors seeking to enhance their technical capabilities and better serve the public interest. Learning Objectives:

• Describe advanced Excel formulas to automate common audit calculations and data analysis tasks
• Identify how to apply lookup functions and dynamic arrays to streamline complex audit data analysis
• Determine how to construct powerful pivot tables for comprehensive audit reporting and data visualization
• Determine the most effective Excel tools for analyzing large datasets in government audits
• Recognize how to organize audit data using combination text, date, and lookup formulas

Program Knowledge Level: Basic NASBA Field of Study: Auditing (Governmental) Learning Program Type: Group Delivery Method: Webinar Who Should Attend: Auditors seeking to advance their Excel skills for improved reporting efficiency Prerequisites: None Advance Preparation: Participants should have Microsoft Excel 365, Excel 2021, or Excel 2024 installed on their computer prior to attending this course. Recommended CPE Credit: 2 Hours Date: Thursday, November 5, 2026 Time: 12:00 p.m. – 2:00 p.m. Central

Webinar Leader:

Stephen M. Yoss Stephen M. Yoss, Jr., MS CPA, is a visionary CPA and the entrepreneurial mind behind Devmatics, LLC. He started his tech journey at age 10, established his own IT company at 13, and began crafting software by 15. At the helm of Devmatics since 2017, Stephen specializes in developing tailored software solutions, mobile apps, and sophisticated automation systems to solve complex, critical challenges for a variety of clients. Stephen is a powerhouse in professional education presenting at over 200 events a year and having authored 150+ CPE courses. His sessions cover critical technology topics from cloud computing to preventing data breaches, artificial intelligence, and automation, empowering professionals across the globe. When he's not developing software or enlightening professionals, Stephen enjoys music, community service, and the great outdoors. His commitment to community and adventure is evident, whether he’s up on the Playa in Black Rock City or volunteering in his hometown of Big Bear Lake, California.     Questions? You can find our FAQ here and our policies here. To see a breakdown of how many polls and minutes of attendance are required for this webinar, see this page.