YoVDO

Excel: Power Query for Beginners

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Data Cleaning Courses Data Transformation Courses Power Query Courses ETL Courses

Course Description

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

Taught by

Dave Ludwig

Related Courses

Building Batch Data Pipelines on GCP auf Deutsch
Google Cloud via Coursera
Building Batch Data Pipelines on GCP en Français
Google Cloud via Coursera
Mastering Azure Data Factory: From Basics to Advanced Level
Udemy
Data Science de A a Z - Extraçao e Exibição dos Dados
Udemy
Building Batch Data Processing Solutions in Microsoft Azure
Pluralsight