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

Практики работы с данными средствами Power Query и Power Pivot
Saint Petersburg State University via Coursera Практики анализа экономических данных от простого к сложному
Saint Petersburg State University via Coursera Introduction to Power BI
DataCamp Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy Excel Básico Avançado 5 Cursos - Formação Especialista
Udemy