Live Virtual Training on Excel Power Query Crash Course
Training TypeLive Training
About the Course
When the daunting task of cleaning up data' comes across your desk, are you using the amazing features of Excel's Power Query? This is a somewhat new feature, it first made its entrance in Excel 2010, and now is a standard part of Excel 2016 and 2019.
In this Power Query crash course, you will learn how to find Power Query, load data into it, begin the process of transforming your redundant tasks (one last time!), and then how to Save and Load the Query to Excel to finish your reports.
Overview Power Query interface
Review the Ribbons
Observe a data extract and transformation
Learn how to back up the Power Query
Learn how to edit Power Queries as needed
Who is the Target Audience?
Any Excel user who is tasked with preparing data for further analysis and charts
Must have Microsoft Excel 2013, 2016, 2019 or Ofc 365