
Live Only
Participation in the live upcoming webinar
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)
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.
You will learn how to:
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.
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.
Participation in the live upcoming webinar
Full MP4 recording of webinar, including Q&A (digital download).
Participation in the live webinar + Full MP4 Recording (digital download).
Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. (digital download)
Participation in the live upcoming webinar
Full MP4 recording of webinar, including Q&A (digital download).
Participation in the live webinar + Full MP4 Recording (digital download).
Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. (digital download)
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.