Library

Course: Excel Power Query Crash Course

Excel Power Query Crash Course

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this 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 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 you will 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
Curriculum
Number of Lectures: 12
Total Duration: 00:37:46
Introduction To The Course
  • Lesson 01 - Introduction to Power Query  
  • Lesson 02 - Get Data and Screen Overview  
  • Lesson 03 - How To Change Source  
  • Lesson 04 - How To Fix Mistakes  
  • Lesson 05 - Introduction To Conditional Columns  
  • Lesson 06 - Edit Query Settings  
  • Lesson 07 - Close And Load To Save  
  • Lesson 08 - 10 Conditions in One Step  
  • Lesson 09 - Format Numbers And Dates  
  • Lesson 10 - Example of a Conditional Columns  
  • Lesson 11 - Advanced Editor  
  • Lesson 12 - Final Overview  
Reviews (0)