Blog
Library

Excel Power Query Crash Course

Features Includes:
  • Self-paced with Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App

Course Preview Video

  • Categories

    Productive Expertise & Efficiency

  • Duration

    00:37:46

  • 3 Students Enrolled

Description

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 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.


Basic knowledge
  • This is an advanced level course for Excel users that find themselves repeating data-clean-up tasks

What will you learn
  • How to begin a Power Query
  • How to Extract data from your Source files into the Power Query
  • How to Transform the data (clean it up)
  • View a few examples of the Transform process
  • Learn the power of the Query Settings and the Advanced Editor
  • How to Load the data and Save the Excel file
  • And finally, how to re-open and edit the Power Query Settings
Course Curriculum
Number of Lectures: 12 Total Duration: 00:37:46
Reviews

No Review Yet