Excel Power Pivot: Take Your Pivot Tables to the Next Level

Wednesday, June 12, 2019 at 3pm ET           Duration: 60 minutes

If you had to cut one piece of wood you might use a handsaw. If you had to cut a thousand pieces, you’d be wise to use a power saw. The right tool makes all the difference. So why, when working with large amounts of data, do so many smart professionals use manual processes? Why do they put up with the limitations of standard Pivot Tables when Excel Power Pivot is sitting in their Excel toolbox? This webinar will show you how to use Excel Power Pivot to make you data projects easier, faster and more actionable. (more details below)


WHY ATTEND

If you’re responsible for reporting financial or other performance metrics you likely rely on MS Excel to get the job done. And if you’re a more advanced user, you know that Pivot Tables can help you crunch and present your data in a more powerful way. But you also know its limitations - like how much data you can work with and the inability to easily enter data from multiple sources.

But if you’re looking to take your Excel skills to an even higher level, you should know about Excel Power Pivot. With imports of a million-plus rows of data sets from virtually any source and the ability to save query definitions, you can completely overhaul your reporting and analysis workflow.
Power Pivot, a free add-in for Excel, puts the "power" into Pivot Tables.

LEARNING OBJECTIVES

You will learn how to:

  • Use Power Pivot for business intelligence functionality and reporting within the familiar environment of Excel
  • Create Pivot Tables from multiple Excel-based lists without using VLOOKUP
  • Access large datasets without worrying about file size or performance
  • Combine related data from multiple data sources (Excel, database, text file etc) into a single Pivot Table
  • Create powerful calculations on the data in your Pivot Tables
  • The easiest way to import data into Power Pivot - and why you should do it
  • The benefits of using the Data Model to create and manage relationships

Who should attend
This training is aimed at users of Excel (2010 and above for Windows) who wish to learn about Power Pivot. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot tables.

Important:
Power Pivot is only available for Excel 2013 and 2016 for Windows in Office Professional Plus, Office 365 Professional Plus or the standalone editions of Excel 2013 & 2016. If you don’t currently have access to these versions of Excel, you are still encouraged to attend, but you’ll need to upgrade your version of Excel after the webinar to utilize what you’ve learned.

                                                      ABOUT THE SPEAKER

                                                      Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.

                                                      Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

                                                      What You Get With Each Option

                                                      Live Recording

                                                      Live Only

                                                      Participation in the live upcoming webinar

                                                      Recording

                                                      Recording Only

                                                      Full MP4 recording of webinar, including Q&A (digital download).

                                                      Live and Recording

                                                      Live + Recording

                                                      Participation in the live webinar + Full MP4 Recording (digital download).

                                                      Event Package

                                                      Event Value Pack

                                                      Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. (digital download)

                                                      What You Get With Each Option close

                                                      Live Recording

                                                      Live Only

                                                      Participation in the live upcoming webinar

                                                      Recording

                                                      Recording Only

                                                      Full MP4 recording of webinar, including Q&A (digital download).

                                                      Live and Recording

                                                      Live + Recording

                                                      Participation in the live webinar + Full MP4 Recording (digital download).

                                                      Event Package

                                                      Event Value Pack

                                                      Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. (digital download)

                                                      About Webinar Connections close

                                                      Each purchase is for ONE computer to access the session.
                                                      A group may participate in a room together as long as only 1 computer is logged in.
                                                      If you need more than one computer to access the webinar, please call customer service at 888-479-2777.
                                                      A charge will apply for each connection.