Data Analytics Deep Dive for Dazzling Audits – October 2025

Description

$275 (per person) includes an online webinar for 4 hours of CPE credit

This 4-hour live webinar will teach actionable data analytics techniques any government auditor can implement.

Attendees will learn the basics (and not-so-basics!) of powerful analytical tools including Excel’s Power Query, Dashboarding with Excel, and Dashboarding with PowerBI.

Major Topics:

The following topics will be discussed in this dynamic and hands-on 4-hr webinar:

Power Query aka “Get and Transform”

• Improve your efficiency with an understanding of Power Query
• Learn the basics of Power Query and start saving time on analytics!

Intermediate Power Query Skills

• Learn next-level Power Query skills, including importing data from a folder and from PDFs
• Dive into conditional columns and using formulas to perform audit testing

Dashboards with Excel!

• Master techniques for building interactive dashboards using PivotTables, slicers, and charts
• Explore formatting tools and layouts for professional, user-friendly designs

Dashboards with PowerBI!

• Understand PowerBI’s interface and its key components, including datasets, reports, and dashboards
• Innovate your executive and board reporting with beautiful data visualizations

Learning Objectives:

• Identify the essentials of Power Query: what it is and how to start using it
• Recognize intermediate Power Query skills: using formulas, duplicate checks, and more!
• Describe dynamic, beautiful dashboards and how to build them with Excel
• Define the basics of Microsoft PowerBI and how to create multiple dashboards

Program Level: Basic
Field of Study: Auditing (Governmental)
Who Should Attend: Government auditors at every level of experience
Prerequisites: None
Advanced Preparation Required: None
Instructional Method: Webinar (Group Internet Based)
CPE Credit Hours: 4

Date: Thursday, October 9, 2025
Time: 12:00 p.m. – 4:00 p.m. Central

Webinar Leader:

Elizabeth McDowell, CPA CIA

Elizabeth McDowell, CPA, CIA has nearly 20 years of audit experience and is the founder of Audit Forward, an innovative internal audit consulting and training firm. Elizabeth is passionate about advancing and advocating for the internal audit profession and was recently recognized as one of the 2023 Internal Audit Beacons by Richard Chambers. Elizabeth makes auditing and training fun (no, really!) with the help of her mascot, Audie the Internal Otteror. In addition to training and consulting, Elizabeth is an adjunct Professor of Accounting at Front Range Community College.

Elizabeth’s most recent industry experience was at Achieve, where she was Sr. Director, Audit Strategy; prior to that, she held internal audit leadership roles at Elevations Credit Union, Fidelity Investments, and Xcel Energy after first starting her career at Ernst & Young.

Questions? You can find our FAQ here.

To see a breakdown of how many polls and minutes of attendance are required for this webinar, see this page.