Ready to take your Excel experience to a whole new mind-blowing level? Power Query is one of the smartest and most powerful tools ever developed for Excel. Power Query automates – yes, automates -- routine data transformation (e.g. merging/splitting/removing columns, filtering data, replacing data, rounding, sorting, converting text to numbers and dates).
Excel guru Dianne Auld will discuss how Power Query works, how to add it into earlier versions of Excel and the difference between Power Query, Power Pivot and Power BI. Standard in Excel 2016/2019 and easily installed as a free add-in to Excel 2010 and 2013, Power Query has astonishing capabilities for extracting, transforming and loading data. Power Query can merge and transform multiple files in a folder, then add / transform another file from the folder simply by clicking Refresh. It can scrape data from web tables, transform the data for use in an Excel file, then update it with a single click. Learn how to use Power Query to automate the transformation of routine payroll/HRIS data, fix problem source data for use in analyses and calculate medians per gender/job title.
In this class, Dianne will demonstrate four applications of Power Query:
Bonus: Attendees will be given all the Excel spreadsheets demonstrated and detailed instructions for replication of the Power Query functions.
Note: The instructor will demonstrate the functionality using Excel 2019 and the Data, Get and Transform menu.
Please consider a different learning method or contact our Customer Experience Team to learn about other classes and schedules.
877-951-9191 (United States and Canada)
+1 480-951-9191 (other countries)
Monday-Friday: 8:00 a.m. - 7:00 p.m. EST
Email our Customer Experience Team: email@example.com