Excelling at Excel: The Magic of Power Query
Total Credits: 2 including 2 Business Management & Organization - Non-technical
- Average Rating:
- 1
- Categories:
- ACPEN Industry Institute | Technology
- Faculty:
- Tracy Cooper, CPA
- Course Levels:
- Intermediate
- Duration:
- 2 Hours
- License:
- Expires 30 day(s) after program date.
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
| Important CPE Credit Instructions_READ BEFORE WEBCAST UPDATED (442.7 KB) | Available after Purchase | ||
| Excelling at Excel: The Magic of Power Query Handout (16.6 MB) | Available after Purchase | ||
| Extra Files (10.3 MB) | Available after Purchase | ||
| Sales Files (47.8 KB) | Available after Purchase | ||
Faculty
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
|
Mon, Jun 02, 2025 - 1:00 PM to 2:47 PM PDT
|
|
Tue, Jun 24, 2025 - 4:00 PM to 5:47 PM PDT
|
|
Tue, Jul 15, 2025 - 11:00 AM to 12:47 PM PDT
|
|
Fri, Jul 25, 2025 - 9:00 AM to 10:47 AM PDT
|
|
Sat, Aug 02, 2025 - 9:00 AM to 10:47 AM PDT
|
|
Tue, Aug 19, 2025 - 11:00 AM to 12:47 PM PDT
|
|
Fri, Aug 29, 2025 - 9:00 AM to 10:47 AM PDT
|
|
Tue, Sep 16, 2025 - 11:00 AM to 12:47 PM PDT
|
|
Fri, Sep 26, 2025 - 9:00 AM to 10:47 AM PDT
|
|
Tue, Oct 21, 2025 - 11:00 AM to 12:47 PM PDT
|
|
Fri, Oct 31, 2025 - 9:00 AM to 10:47 AM PDT
|
|
Sat, Nov 01, 2025 - 9:00 AM to 10:47 AM PDT
|
|
Tue, Nov 18, 2025 - 11:00 AM to 12:47 PM PST
|
|
Wed, Nov 26, 2025 - 9:00 AM to 10:47 AM PST
|
|
Tue, Dec 16, 2025 - 11:00 AM to 12:47 PM PST
|
|
Fri, Dec 26, 2025 - 9:00 AM to 10:47 AM PST
|
|
Tue, Jan 20, 2026 - 11:00 AM to 12:47 PM PST
|
|
Fri, Jan 30, 2026 - 9:00 AM to 10:47 AM PST
|
|
Sat, Feb 07, 2026 - 9:00 AM to 10:47 AM PST
|
|
Tue, Feb 17, 2026 - 11:00 AM to 12:47 PM PST
|
|
Fri, Feb 27, 2026 - 9:00 AM to 10:47 AM PST
|
|
Tue, Mar 17, 2026 - 11:00 AM to 12:47 PM PDT
|
|
Fri, Mar 27, 2026 - 9:00 AM to 10:47 AM PDT
|
|
Tue, Apr 21, 2026 - 11:00 AM to 12:47 PM PDT
|
|
Fri, Apr 24, 2026 - 9:00 AM to 10:47 AM PDT
|
|
Sat, May 02, 2026 - 9:00 AM to 10:47 AM PDT
|
|
Tue, May 19, 2026 - 11:00 AM to 12:47 PM PDT
|
|
Fri, May 29, 2026 - 9:00 AM to 10:47 AM PDT
|
|
Tue, Jun 16, 2026 - 11:00 AM to 12:47 PM PDT
|
|
Fri, Jun 26, 2026 - 9:00 AM to 10:47 AM PDT
|
Additional Info
Basic Course Information
Prerequisites A working knowledge of ExcelAdvanced 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 PolicyPlease 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
| 5 |
|
| 4 |
|
| 3 |
|
| 2 |
|
| 1 |
|