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

Data Wrangling with MongoDB
MongoDB via Udacity Getting and Cleaning Data
Johns Hopkins University via Coursera 软件包在流行病学研究中的应用 Using software apps in epidemiological research
Peking University via Coursera Creating an Analytical Dataset
Udacity Implementing ETL with SQL Server Integration Services
Microsoft via edX