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

Flex Your Data Management Muscle With Excel 2016 Power Pivot & Power Query (IME518A)

Presented by: Thomas Fragale
Request Replay Date:
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Thu, May 3, 2018
Event Description
See the sneak peek before you buy!
1.0 CPE

Do You Manage Your Data, or Does Your Data Manage You?

As you import and work with data, you may find Microsoft Excel’s basic tools holding you back—especially if you work with large and complex datasets. For instance, manually entering data from multiple sources is a significant chore, but import size limits can reduce your options. As you crawl through the pre-import process of cleaning up data and merging/splitting cells, you’re probably wondering: Isn’t there an easier way?

Yes! Learn directly from Microsoft-certified trainer Tom Fragale as he introduces you to the two free tools that will revolutionize—and optimize—the way you use Excel. Find out how to wield Power Query to find, connect to, and import data. And discover how Power Pivot allows you to overcome Excel’s size limitations when modeling your data. Combined, these tools will prepare you to completely overhaul your reporting and analysis workflow.

After attending this live webinar, you will be able to immediately apply Fragale’s techniques to your own data, in your everyday work, in your specific industry. You’ll use Power Query to clean, transform, and truly connect with your data. You’ll be ready to say goodbye to complicated Access databases, and you can stop requesting database help from the IT department! Power Pivot allows you to import datasets containing more than one million rows from virtually any source. It’s also a dream for creating PivotTables from multiple datasets.

Session Highlights

After attending this event, you’ll be able to:

  • Import data into Excel worksheets and PivotTables from an array of external sources
  • Create pivot tables from multiple datasets
  • Understand and use DAX formulas
  • Create relationships between different datasets in Excel
  • Stop resorting to creating Access databases to merge and manage large datasets
  • Enjoy an instant productivity boost from within your existing Excel worksheets

Who Should Attend

  • Business owners
  • CEOs, CFOs, CTOs
  • Managers
  • Administrators
  • Salespeople
  • Trainers
  • Bankers
  • Anyone who wants to be an Excel 2016 power user
About Our Speaker(s)

Thomas Fragale
Thomas Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel, and a Microsoft Certified Specialist in Access, Outlook, and PowerPoint. He has trained over 30,000 busin... More info

We Also Recommend
Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Flex Your Data Management Muscle With Excel 2016 Power Pivot & Power Query
    Presenter(s): Thomas Fragale

Our Accreditation Partners Protection Status