My Shopping Cart
There are no items in your shopping cart.

Excel Power Tools - Power Pivot and Power Query (IME961R)

Presented by: Mike Thomas
This conference is no longer available
But don't worry, our customer care representatives will help you find an event that meets your needs!
Call on (800) 223-8720
Event Description
1.0 CPE

Use Power Query and Power Pivot to Analyze Large Amounts of Data With Ease.

Power Query and Power Pivot are the two important tools you must have if you use Excel for analyzing large datasets – and best of all they are free (Power Query is actually built right into Excel 2016 for Windows!)

Power Pivot takes Pivot Tables and data analysis to the next level. If you’re a fan of Pivot Tables, you’ll love Power Pivot. Power Pivot lets you quickly and easily create Pivot Tables from multiple data sets (no VLOOKUP required). Power Pivot lets you analyze your data in ways that you’ve never been able to do before thanks to some new Power Pivot functions (known as DAX functions). Power Pivot lets you work with datasets that span millions of rows.

Power Query allows you to connect to data sources so that you can shape, transform, clean and refine your data so that it is ready to meet your analysis requirements. Something that once took days to do can now be done in seconds – without a single line of VBA coding!

In this webinar, by Mike Thomas, you’ll learn about how the functionality of Power Pivot and Power Query can help you to analyze data. Understand how to optimize their use and explore the power of these power tools.

Session Highlights:

  • Installing Power Pivot
  • Importing data into Excel from external sources
  • Creating relationships in Power Pivot
  • DAX formulas in Power Pivot
  • Power Query data sources
  • Cleaning data
  • Transforming data
  • Merging data
  • Unpivoting data

Who Should Attend

  • C Level Executives
  • Executive Assistants
  • Accountants
  • Administrators
  • Office Managers
  • Attorneys
  • CPA
  • Finance Professionals
  • Business Analyst
  • Accountants
  • Bookkeeper
  • HR Professionals

IMPORTANT NOTE: Power Pivot is only available in Excel 2013 and 2016 for Windows in Office Professional Plus, Office 365 Professional Plus or the standalone editions of Excel 2013 & 2016.

About Our Speaker(s)

Mike Thomas | Microsoft Excel Technology Training SpeakerMike Thomas
Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Excel Power Tools - Power Pivot and Power Query
    Presenter(s): Mike Thomas Protection Status