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:
- All Levels
- 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
|
Thu, Jan 30, 2025 - 01:00pm to 02:47pm PST
|
|
Wed, Feb 05, 2025 - 08:00am to 09:47am PST
|
|
Tue, Feb 25, 2025 - 11:00am to 12:47pm PST
|
|
Fri, Mar 07, 2025 - 01:00pm to 02:47pm PST
|
|
Wed, Mar 26, 2025 - 08:00am to 09:47am PDT
|
|
Mon, Apr 07, 2025 - 11:00am to 12:47pm PDT
|
|
Wed, Apr 23, 2025 - 01:00pm to 02:47pm PDT
|
|
Wed, May 07, 2025 - 08:00am to 09:47am PDT
|
|
Fri, May 16, 2025 - 11:00am to 12:47pm PDT
|
|
Mon, Jun 02, 2025 - 01:00pm to 02:47pm PDT
|
|
Tue, Jun 24, 2025 - 04:00pm to 05:47pm PDT
|
|
Tue, Jul 15, 2025 - 11:00am to 12:47pm PDT
|
|
Fri, Jul 25, 2025 - 09:00am to 10:47am PDT
|
|
Sat, Aug 02, 2025 - 09:00am to 10:47am PDT
|
|
Tue, Aug 19, 2025 - 11:00am to 12:47pm PDT
|
|
Fri, Aug 29, 2025 - 09:00am to 10:47am PDT
|
|
Tue, Sep 16, 2025 - 11:00am to 12:47pm PDT
|
|
Fri, Sep 26, 2025 - 09:00am to 10:47am PDT
|
|
Tue, Oct 21, 2025 - 11:00am to 12:47pm PDT
|
|
Fri, Oct 31, 2025 - 09:00am to 10:47am PDT
|
|
Sat, Nov 01, 2025 - 09:00am to 10:47am PDT
|
|
Tue, Nov 18, 2025 - 11:00am to 12:47pm PST
|
|
Wed, Nov 26, 2025 - 09:00am to 10:47am PST
|
|
Tue, Dec 16, 2025 - 11:00am to 12:47pm PST
|
|
Fri, Dec 26, 2025 - 09:00am to 10:47am PST
|
|
Tue, Jan 20, 2026 - 11:00am to 12:47pm PST
|
|
Fri, Jan 30, 2026 - 09:00am to 10:47am PST
|
|
Sat, Feb 07, 2026 - 09:00am to 10:47am PST
|
|
Tue, Feb 17, 2026 - 11:00am to 12:47pm PST
|
|
Fri, Feb 27, 2026 - 09:00am to 10:47am PST
|
|
Tue, Mar 17, 2026 - 11:00am to 12:47pm PDT
|
|
Fri, Mar 27, 2026 - 09:00am to 10:47am PDT
|
|
Tue, Apr 21, 2026 - 11:00am to 12:47pm PDT
|
|
Fri, Apr 24, 2026 - 09:00am to 10:47am PDT
|
|
Sat, May 02, 2026 - 09:00am to 10:47am PDT
|
|
Tue, May 19, 2026 - 11:00am to 12:47pm PDT
|
|
Fri, May 29, 2026 - 09:00am to 10:47am PDT
|
|
Tue, Jun 16, 2026 - 11:00am to 12:47pm PDT
|
|
Fri, Jun 26, 2026 - 09:00am to 10:47am 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.