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