This website uses cookies to ensure you get the best experience on our websites. Learn more

A laptop screen with Microsoft Excel tables and graphs being manipulated by a business person.

Live Virtual Workshop

•

3 hrs

•

4.5

(1,000)

Excel Power Tools: Power Query and Power Pivot

Approved for NASBA credits

Course Outcomes Agenda Reviews FAQs

Accelerate your spreadsheet data analysis proficiency. This LIVE, virtual, hands-on data management course provides the essential 21st century Microsoft Excel training you need to get ahead. It goes beyond the fundamentals of PivotTables to explore more advanced topics, such as calculated fields, calculated items and conditional formatting. Then it brings you up-to-date and up-to-speed with Excel for Office 365 Power Tools, including Power Query and Power Pivot.

With Excel Power Tools, you’ll be equipped to analyze an unlimited amount of data, combine multiple data sources into a single report, analyze data across multiple tables and create more sophisticated calculations.

For an optimal experience with this course, we recommend Excel 2016 and later. Windows platform preferred.

Course Outcomes

Build advanced PivotTables with calculated items and fields
Combine separate sheets into one report with the PivotTable PivotChart Wizard
Automate repetitive importing and data cleansing tasks instead of writing complicated VBA macros
Merge multiple data sets into a single report using Power Query
Import data into a Power Pivot data model
Create and edit relationships between two data tables in Power Pivot

4.5_{out of 5}

(1,000)

1,000

people have taken this course

96%

found this course to be helpful in their workplace

Course Agenda

3 hrs

Accreditations: NASBA credits

Live Virtual Workshop

Print Agenda

Session 1: Building Advanced PivotTables With Calculated Items and Fields

Session 2: Power Query Including the M language

Learn how Power Query helps you automate the process of importing, transforming and cleansing your data. Building an effective Power Query that can be used over and over on new datasets will save hours of effort and make you a more effective analyst.

Discuss the fundamentals of Power Query (Get & Transform)
Explain how to use Power Query to clean up data before you load it
Extract and organize data from many sources
Understand how to merge queries

Session 3: Introduction to Power Pivot — Gathering Data

SkillPath, the Graceland College Center for Professional Development and Lifelong Learning, 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 on its website: www.nasbaregistry.org. SkillPath's Sponsor ID number is 146710. This course qualifies for 3.2 CPEs. Delivery Method: Group Internet Based. Field of Study: Computer Software & App. Prerequisites: None. Program Level: Intermediate. Advanced Preparation: None.

Event Dates & Locations

Date	Time	Price
January 21	3:00 PM-6:00 PM UTC	^$199
January 21	7:00 PM-10:00 PM UTC	^$199
February 10	3:00 PM-6:00 PM UTC	^$199
February 10	7:00 PM-10:00 PM UTC	^$199
March 4	3:00 PM-6:00 PM UTC	^$199
March 4	7:00 PM-10:00 PM UTC	^$199

Live Virtual Workshop

Course Dates & Times

January 21Tue | 3:00 PM-6:00 PM UTC

January 21Tue | 7:00 PM-10:00 PM UTC

February 10Mon | 3:00 PM-6:00 PM UTC

February 10Mon | 7:00 PM-10:00 PM UTC

Schedule a private group trainingLearn More

Show 2 More Dates

Save when you enroll multiple attendees!

Just $189 per person when you enroll 4+ learners

Included in
SkillPath Unlimited+Live

^$ per year

Access this course and 6000+ other live virtual workshop sessions(includes live virtual events priced $399 or less)
500+ webinars broadcast daily
2,000+ on-demand resources
And so much more!

More Courses in

Live Virtual Workshop Business & Technology

Participant Takeaways

Excellent trainer. I really appreciated that he checked in with us regularly to make sure we were following along ok and if we had any questions. I learned so much in just the 3 hour training time. The breaks were very helpful as well as it can be hard to follow technical training for too long.

Kristen H.

Great course and very valuable tools to utilize in my every day job. Thanks.

Keith P.

Trainer was very informative and easy to follow. Had a great speaking voice.

Lucy H.

The course and trainer were amazing!

Jennifer T.

I really appreciated our trainer's repetitive practice model. Doing repeatedly helps me remember what to look for when I forget the shortcut the first few times using new skills, as does his continued linking from what we're doing in class to the handbook for reference later. His pace was great, getting through material while checking in with participants to make sure everyone is getting the learning objectives.

Megan F.

FAQs

How does a virtual seminar work?

A virtual seminar is a live, instructor-led experience. One or two days before the actual date of your seminar (also referred to as a course or workshop), you’ll receive an email with a link and a unique registration ID you’ll use to connect to the training. It will also include an additional link to the course materials along with any additional instructions you’ll need.

About 15 minutes before the scheduled start of your workshop, you’ll be able to log on from your computer, laptop, tablet or smartphone and join the event. Your unique registration ID may only be used once.

To ensure you have the best experience possible, please make sure your system has the necessary components. You can check your system now by following this link: Click here. Note: Please disable any pop-up blockers before testing your system.

Why should I choose virtual training?

Do you offer closed captioning?

What happens if I register, and then something comes up and I have to cancel?

We understand that occasionally things happen beyond your control, making cancellation unavoidable.

CANCELLATION POLICY: Cancellations occurring 5 business days or less before the event will be eligible for a one-time transfer to a future event. Refer to the confirmation number received upon registration and notify us by email at [email protected] or call us at 1-800-873-7545 prior to the date of the event. Post-event cancellations will be ineligible for transfer and the registrant will be liable for the entire course fee.

What happens if I get disconnected during the seminar?

How do I contact Customer Service?

Related Courses