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. /Internal Audit

An Auditor's New Bestie: PowerQuery!

Learn how to harness Power Query to audit smarter, not harder, with tools already at your fingertips.

Created byElizabeth McDowellworkspace_premiumBest Instructor
BeginnerUpdated Jan 9, 2025

What You'll Learn

  • check_circleUnderstand the fundamentals of Power Query and its applications for internal auditors.
  • check_circleExplore techniques for cleaning, transforming, and combining data from various sources.
  • check_circleDevelop foundational skills to automate repetitive data tasks and improve audit workflows.
  • check_circleDemonstrate practical use cases of Power Query in real-world audit scenarios.

About This Course

This engaging course introduces internal auditors to Power Query, a powerful tool for simplifying data transformation and enhancing audit efficiency. Led by Elizabeth McDowell, a seasoned internal auditor and winner of the 2023 Internal Audit Beacon Award, the course provides practical insights into using Power Query to streamline audit workflows.

With step-by-step guidance, you’ll explore the tool’s menus, learn how to load and transform data, and apply steps to simplify complex tasks. Designed for internal auditors seeking to audit smarter, this course is a must for anyone looking to elevate their data analysis skills.

Course Content

6 activities • 5 videos • duration: 1h 13m

  • videocamIntroductions to Elizabeth and the Course
    Duration 4:54
  • quizFeedback Question

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
52 reviews
  • SW
    Shirley W.
    starstarstarstarstar

    Convenience

  • ME
    Michael E.
    starstarstarstarstar

    Super helpful, and very easy to follow the instructor.

  • KM
    Kalleigh M.
    starstarstarstarstar

    Interested to play around with it a bit to see if it will help in our external audit testing. I'm sure it will!

  • SM
    Susan M.
    starstarstarstarstar

    Very practical

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