The
Power Pivot for Excel Course includes 5.5 hours of video tutorials
covering everything from installing Power Pivot, importing data, DAX
formulas, PivotTables and more. Download the sample files, and follow
along with the lessons.

In this hands-on project-based course, you will build a Power Pivot
model from start to finish. The training is delivered online and tutorials
are available to watch 24/7 at your own pace. Pause, rewind, replay
as many times as you like.

Combine the Advance Excel and Power Pivot courses into one bundle,
to save money, or take either course separately. The Power Pivot
course will take you from the basic steps, up to intermediate level
in skills.

This course includes access to student forums, where you can ask
questions, and discuss the lessons with other students in the course

Sample workbooks can be downloaded, to follow along the lessons

In this video, Chandoo introduces Power Pivot, and shows how to set
up linked tables in Excel. This will give you an idea of his teaching
style, before you decide to enroll in the Advanced
Excel & Power Pivot Training course.

This course covers the basics briefly, then moves on to intermediate
and advanced Power Pivot formulas and techniques. There are 19 hours
of video instruction, sample workbooks, Rob Collies DAX Formulas
book, and a handy reference card.

If you are an absolute beginner with Power Pivot, go slowly through
the first few lessons, to ensure that you understand the basics,
before going forward. The course is packed with valuable content,
and it can be overwhelming if you go too fast.

There are no student forums, but you can click a link to send
a question to the instructor.

Power Query Training

Excel's new Power Query add-in can do amazing things with your data.

Online Classes - Live Training

If you'd like to learn more about it, experts Ken Puls and Miguel
Escobar offer live, online
Power Query training. You'll have two days of live online training
(4 hours per day), then a live follow-up Q&A session, about a
week later.

Online Classes - Self-Paced

Ken and Miguel also have an online Power Query Academy, where you can go at your own pace. The course starts with the Power Query basics, and gradually builds up to advanced techniques. There are 15 modules, broken into 55 videos (over 12 hours of content). See all the course details and sign up now.

Data Master Bundle

Get the Data Master Bundle -- a series of online courses from Excel with Business. The bundle includes Excel, Data Science, Business Analysis and Microsoft Access courses. Click the image below, for bundle details

Power BI Books

These books will take you from the beginner stage, into the advanced
levels of Power Pivot and Power Query. Most links will take you to
the Amazon website, where you can read the review, and use the "Look
Inside" feature, to examine the book, before buying it.