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
- Faculty:
- Tracy Cooper, CPA
- Course Levels:
- Intermediate
- Duration:
- 2 Hours
- License:
- Product Setting: 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, Apr 07, 2025 - 02:00pm to 03:47pm EDT
|
|
Wed, Apr 23, 2025 - 04:00pm to 05:47pm EDT
|
|
Wed, May 07, 2025 - 11:00am to 12:47pm EDT
|
|
Fri, May 16, 2025 - 02:00pm to 03:47pm EDT
|
|
Mon, Jun 02, 2025 - 04:00pm to 05:47pm EDT
|
|
Tue, Jun 24, 2025 - 07:00pm to 08:47pm EDT
|
|
Tue, Jul 15, 2025 - 02:00pm to 03:47pm EDT
|
|
Fri, Jul 25, 2025 - 12:00pm to 01:47pm EDT
|
|
Sat, Aug 02, 2025 - 12:00pm to 01:47pm EDT
|
|
Tue, Aug 19, 2025 - 02:00pm to 03:47pm EDT
|
|
Fri, Aug 29, 2025 - 12:00pm to 01:47pm EDT
|
|
Tue, Sep 16, 2025 - 02:00pm to 03:47pm EDT
|
|
Fri, Sep 26, 2025 - 12:00pm to 01:47pm EDT
|
|
Tue, Oct 21, 2025 - 02:00pm to 03:47pm EDT
|
|
Fri, Oct 31, 2025 - 12:00pm to 01:47pm EDT
|
|
Sat, Nov 01, 2025 - 12:00pm to 01:47pm EDT
|
|
Tue, Nov 18, 2025 - 02:00pm to 03:47pm EST
|
|
Wed, Nov 26, 2025 - 12:00pm to 01:47pm EST
|
|
Tue, Dec 16, 2025 - 02:00pm to 03:47pm EST
|
|
Fri, Dec 26, 2025 - 12:00pm to 01:47pm EST
|
|
Tue, Jan 20, 2026 - 02:00pm to 03:47pm EST
|
|
Fri, Jan 30, 2026 - 12:00pm to 01:47pm EST
|
|
Sat, Feb 07, 2026 - 12:00pm to 01:47pm EST
|
|
Tue, Feb 17, 2026 - 02:00pm to 03:47pm EST
|
|
Fri, Feb 27, 2026 - 12:00pm to 01:47pm EST
|
|
Tue, Mar 17, 2026 - 02:00pm to 03:47pm EDT
|
|
Fri, Mar 27, 2026 - 12:00pm to 01:47pm EDT
|
|
Tue, Apr 21, 2026 - 02:00pm to 03:47pm EDT
|
|
Fri, Apr 24, 2026 - 12:00pm to 01:47pm EDT
|
|
Sat, May 02, 2026 - 12:00pm to 01:47pm EDT
|
|
Tue, May 19, 2026 - 02:00pm to 03:47pm EDT
|
|
Fri, May 29, 2026 - 12:00pm to 01:47pm EDT
|
|
Tue, Jun 16, 2026 - 02:00pm to 03:47pm EDT
|
|
Fri, Jun 26, 2026 - 12:00pm to 01:47pm EDT
|
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.