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

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard