Skip to main content
Live Webcast Replay

Excelling at Excel: The Magic of Power Query


Total Credits: 2 including 2 Business Management & Organization - Non-technical

Average Rating:
Not yet rated
Categories:
ACPEN Industry Institute |  Technology
Speaker:
Tracy Cooper, CPA
Course Levels:
All Levels
Duration:
2 Hours

Dates
Please Note: Programs with a ☾ insignia begin after 5pm or air on the weekend.


Description

Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks.

Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes.

Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before.

Basic Course Information

Learning Objectives
  • Learn to use Power Query

Major Subjects
  • Intro to Power Query & how to get started
  • Examples of data clean up using Power Query
  • Combining workbooks and files with Power Query

Course Materials

Speaker

Tracy Cooper, CPA's Profile

Tracy Cooper, CPA Related Seminars and Products

The Knowledge Institute


Tracy Cooper, CPA is a specialist serving small and mid-size businesses in resolving their accounting, technology, business process, and reporting challenges. She has worked with Price Waterhouse, ALLTEL, and other leading firms. Tracy’s ability to communicate at both the strategic and tactical levels has given her the privilege of leading training with individuals and groups of all sizes throughout her career, both in the US and abroad. Tracy graduated from The University of Texas San Antonio summa cum laude, and is currently based in Little Rock, Arkansas.


Dates

Tue, Nov 05, 2024 - 10:00am to 11:47am CST
Thu, Nov 21, 2024 - 01:00pm to 02:47pm CST
Wed, Dec 04, 2024 - 03:00pm to 04:47pm CST
Thu, Dec 19, 2024 - 06:00pm to 07:47pm CST
Fri, Jan 03, 2025 - 01:00pm to 02:47pm CST
Thu, Jan 30, 2025 - 03:00pm to 04:47pm CST
Wed, Feb 05, 2025 - 10:00am to 11:47am CST
Tue, Feb 25, 2025 - 01:00pm to 02:47pm CST
Fri, Mar 07, 2025 - 03:00pm to 04:47pm CST
Wed, Mar 26, 2025 - 10:00am to 11:47am CDT
Mon, Apr 07, 2025 - 01:00pm to 02:47pm CDT
Wed, Apr 23, 2025 - 03:00pm to 04:47pm CDT
Wed, May 07, 2025 - 10:00am to 11:47am CDT
Fri, May 16, 2025 - 01:00pm to 02:47pm CDT
Mon, Jun 02, 2025 - 03:00pm to 04:47pm CDT
Tue, Jun 24, 2025 - 06:00pm to 07:47pm CDT

Additional Info

Basic Course Information

Prerequisites A working knowledge of Excel
Advanced Preparation None
Designed For All business professionals
Original Recording Date 07/30/2024
Course Developer The Knowledge Institute
Date Added to Catalog 05/3/2024
Yellow Book No

Additional Information

Complaint Resolution Policy

Please contact Anne Taylor for any complaints. anne.taylor@acpen.com, (972-377-8199). 


Official Registry Statement

Business Professionals' Network, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org


Instructional Delivery Method

Group Internet Based


Course Registration Requirements

Online Registration


Refund/Cancellation Policy

Please contact the ACPEN help desk 1-877-602-9877 or help@acpen.com if you wish to cancel your attendance for a previously purchased webcast and are requesting a refund or transfer. 


Promo Video

Reviews