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

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.