Register

Excel University Webinar

Impossible PivotTables: Made Possible with Power Pivot

Do you love Excel PivotTables? Me too! As great as traditional PivotTables are, they do have some limitations. When we hit one of them, we quickly conclude that this is just an impossible PivotTable.

In this complimentary 60-minute webinar, we’ll see how Power Pivot makes impossible PivotTables possible. Power Pivot can do much more than that, but, I thought this would be a fun way to introduce Power Pivot. If you use PivotTables or VLOOKUP, you’ll love learning about Power Pivot.

Attendees receive a free e-book to keep for reference 🙂

There are four live sessions plus an on-demand version for those with scheduling conflicts.

LIVE SESSIONS
Register for one of the free 60-minute live sessions:

  • Wed July 18 @ 2p CT
  • Thu July 19 @ 11a CT
  • Fri July 20 @ 9a CT
  • Fri July 20 @ 2p CT

 

  • The registration page has a time zone converter to make it easy to see these in your local time.
  • Jeff Lenning CPA presents these sessions live, in real-time and you can submit questions.
  • This complimentary webinar is not offered for CPE credit
  • Power Pivot is not available in all versions of Excel, including Excel for Mac
  • Webinar registration includes a complimentary subscription to the Excel University blog

ON-DEMAND VERSION

If you have scheduling conflicts with the live dates, please watch the free on-demand version now through July 27, 2018:

 

  • The on-demand version starts immediately and will start at the beginning.
  • If you don’t have time to watch it now, click the On-Demand Version button above and enter your name and email. The system will email you a link that you can use to launch the webinar anytime between now and July 27, 2018.
  • Although the button on the registration page says “Join Webinar in Progress” it will start at the beginning.
  • This complimentary webinar is not offered for CPE credit.
  • Webinar registration includes a complimentary subscription to the Excel University blog.

 

Pssst … pass it on!

Know someone who would enjoy this webinar? Please send them a link to this page!


 

Additional Information / Webinar Agenda

Historically, when I tried to build a traditional PivotTable (PT) that wasn’t supported by Excel, I’d have to figure out some type of workaround. These workarounds weren’t always pretty, but, they helped me get the numbers I needed. I’d use workarounds like adding helper columns to the data table, copy/pasting multiple data tables into a single data source table, clicking-and-dragging to manually sort the labels, or creating formulas outside the PT on the worksheet. All of these worked, sort-of, but, they didn’t feel very elegant. They didn’t feel very reliable either … they felt fragile, like they could easily break in future periods when I had to update the report. Then, everything changed when I learned about Power Pivot (PP).

To explore Power Pivot, we’ll do these things:

  • We’ll build a report that pulls amounts from one table and names from another (without using VLOOKUP)
  • Build a report that allocates an amount over departments based on percentages
  • Build a report that uses budget data from one table, forecast data from another, and actuals from another … then compute a variance

And, we’ll do all of them all with Power Pivot 🙂

I’ll then talk about how to learn more about Power Pivot and earn 20 CPE credits while doing so.

Free e-book! Attendees will receive a free e-book to keep as a reference.

Have you decided to skip the webinar?

If so, no worries … but while you are here, please subscribe to our blog to learn Excel free via email. You’ll be notified of new Excel articles and blog posts.