Skip to main content
by learnformula
Explore courses
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
Explore courses
  1. Courses
  2. /Audit & Assurance
  3. /IT Auditing

Audit Smarter, not Harder: Audit Testing with Power Query!

Master Power Query to streamline audit testing, automate data transformation, and analyze large datasets efficiently.

Created byElizabeth McDowellworkspace_premiumBest Instructor
IntermediateUpdated Jan 13, 2025

What You'll Learn

  • check_circleLearn how to import and transform large datasets from multiple sources using Power Query to streamline audit testing.
  • check_circleDevelop skills to automate data reshaping and transformation processes for efficient and repeatable audit tasks
  • check_circleApply advanced Power Query functions, such as grouping, filtering, and custom formulas, to identify anomalies and assess risks
  • check_circleEnhance audit processes by leveraging Power Query techniques for data analysis and testing efficiency

About This Course

"Audit Smarter, Not Harder: Audit Testing with Power Query" is a practical, hands-on training designed to empower internal auditors with the tools and techniques to streamline audit testing using the Power Query. Participants will learn how to import, transform, and analyze large datasets efficiently, automate repetitive tasks, and create dynamic models to identify anomalies and potential fraud. Through real-world examples, this course showcases how to save time and focus audit efforts on high-risk areas, enhancing overall audit success.

Course Content

9 activities • 8 videos • duration: 1h 31m

  • videocamCourse Introduction & Power Query Overview
    Duration 16:23
  • quizReview Questions

Your Instructor

Elizabeth McDowell

Audit Smarter, not Harder - with Elizabeth and Audie the Internal Otteror!

menu_book32 courses
star1,298 reviews

Elizabeth McDowell, CPA, CIA has over 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 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. 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.

Credit Information

Professional development requirements vary by profession, country, and regulatory body. Before enrolling, review the course details and confirm that the content, learning format, and any listed credits meet your specific requirements. You are responsible for confirming eligibility with your regulator or professional association and keeping the records required for reporting.

What Students Are Saying

5.0 out of 5
Student's Choice
59 reviews
  • ME
    Michael E.
    starstarstarstarstar

    I love this course and techniques used for data manipulation.

  • TP
    Tracy P.
    starstarstarstarstar

    Great tool but questions difficult when seeing it for the first time.

  • DB
    Dirk B.
    starstarstarstarstar

    Great course

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Ethics: Business Ethics

    2026 Ethics and Corporate Compliance

    starRated5.0out of 5,(632 reviews)
    2 CPD hrs
  • Finance: NASBA - Finance

    Sensitivity Analysis and Scenario Planning

    starRated5.0out of 5,(154 reviews)
    1.5 CPD hrs
  • Accounting & Tax: Technology for Accountants

    Claude Fundamentals for Accountants (2026 Update)

    starRated5.0out of 5,(697 reviews)
    2.5 CPD hrs