Zurich, Switzerland: +41 - 43 434 80 33   |   US: (510) 954-3145   |   support@traininng.com

Webinar Price Details

Overview

This is a high-level introduction overview to Excel’s Power tool called Power Query. See how it can transform large volumes of data by cleaning it, manipulating it and transforming it into a completed query that can then be loaded to an Excel Table or PivotTable for reporting.

Areas Covered in the Session

  • How to import data into the Power Query Editor
  • Command oveview to Prepare, Clean and Transform data
  • Learn how to combine and join different data sets
  • Get an introduction to Power Query formulas
  • Load a complete Query into an Excel Table and PivotTable for reporting

Who Will Benefit

  • Managers
  • Business professionals
  • Administrative Personnel
  • Legal Professionals

Speaker Profile

Craig Brody runs Craig Brody, LLC, a software training and consulting business. Craig has trained thousands of employees, managers, executives and students in application software including Microsoft 365 and Adobe Acrobat Pro. Conducts and facilitates in person and online training workshops for professionals in the fields of Accounting, Business, and Law. Conducts workshops, classes and consulting services for the University of Pennsylvania’s Wharton Business School and Penn Carey Law School. Provides clients with spreadsheet analysis and design, software programming, consulting services and course curriculum including videos, reference guides and related materials