Supercharge Your Excel Reporting With PowerPivot and Power Query

Duration: 90 minutes

If you work with data, you’re likely already familiar with common frustrations with Microsoft Excel like size limitations and manually entering data from multiple sources.

Luckily there are two Microsoft tools- PowerPivot and PowerQuery—that solve ALL of these issues, right inside Excel. No Access databases or IT department help needed.

With imports of 1-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. (more info below)


WHY ATTEND

Microsoft Excel Power Pivot and Power Query are game-changing tools if you’re familiar with any of these frustrations when working with data in Excel:

  • Size limitations
  • Pivot tables and Vlookup not working across multiple tables
  • Having to rely on Access for advanced data analysis and reporting
  • Manually getting data into Excel from external sources (copy, paste, copy, paste, repeat), or perhaps worse…spending hours “cleaning” imported data (trim this row, concatenate that column, reformat this section)

And, here’s the best part….they are FREE! In fact, most 2013 and 2016 Excel users already have access to PowerPivot and PowerQuery, but need to take steps to enable them.

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.

This webinar assumes a basic understanding of Excel formulas and Pivot tables.

LEARNING OBJECTIVES

What you will learn about:

  • How to activate/install PowerPivot and PowerQuery—free tools from Microsoft
  • Creating relationships between different datasets in PowerPivot
  • Importing data into excel from an array of external sources
  • Cleaning, transforming and merging data with PowerQuery (goodbye, Access)
  • Practical applications for different data models you can create with these tools 

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. Choose digital download or CD-ROM by mail.

Live and Recording

Live + Recording

Participation in the live webinar + Full MP4 Recording. For recording, choose digital download or CD-ROM by mail.

Event Package

Event Value Pack

Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. For recordings, choose digital download or CD-ROM by mail.

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. Choose digital download or CD-ROM by mail.

Live and Recording

Live + Recording

Participation in the live webinar + Full MP4 Recording. For recording, choose digital download or CD-ROM by mail.

Event Package

Event Value Pack

Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. For recordings, choose digital download or CD-ROM by mail.

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.