Excel: Power Query for Beginners

Go to class
Write Review

Free Online Course: Excel: Power Query for Beginners provided by LinkedIn Learning is a comprehensive online course, which lasts for Less than 1 hour of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Excel: Power Query for Beginners is taught by Dave Ludwig.

Overview
  • Get an intro to Power Query, a set of robust features in Microsoft Excel.

Syllabus
  • Introduction

    • What is Power Query in Excel?
    • What you should know
    1. Getting Data with Power Query
    • Getting data from another file
    • Getting data from an open workbook
    2. Cleaning and Transforming Data with Power Query
    • Common cleaning tasks
    • Filtering and sorting data
    • Splitting columns
    • Conditional columns
    Conclusion
    • Next steps