Excel - Power Query

Save time cleaning up and managing your data with Excel’s popular power tool

What you'll learn

Describe the purpose of Power Query

Connect to data in Excel, databases, and other sources

Clean up and transform data

Add new columns

Sort, filter, and unpivot data

Manage applied steps

Manage multiple queries

Create append and merge queries

Create a web query

Requirements

Mastering Microsoft Excel 365 Intermediate course or strong Excel skills

Description

Save time cleaning up and managing your data with Excel’s popular power toolHave you spent a lot of time performing repetitive cleanup tasks on your data, using multiple VLOOKUP functions to merge data, or trying to combine multiple datasets? If so, then Excel’s Power Query tool will transform how you work. You’ll learn how to connect to multiple data sources, and set up queries to remove unneeded data, manipulate existing data, and even create new columns. And the best part is, once you’ve set up your query, you’ll just refresh it when you need to perform those tasks. Microsoft-certified trainer Kathy Jones will show you how to use the Power Query Editor to perform all of these functions and streamline your workflow in the process.Topics covered include:Connecting to data in Excel, databases, and other sourcesCleaning up and transforming dataAdding new columnsSorting, filtering, and unpivoting dataManaging applied stepsManaging multiple queriesCreating append and merge queriesCreating a web queryDescribe the purpose of Power QueryHigh-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!Course Goal: By the end of this course, you will be able to describe the purpose of Power Query, link to multiple types of datasets, transform data, and manage queries.

Overview

Section 1: Getting Started

Lecture 1 Introduction

Lecture 2 Purpose of Power Query

Section 2: Connecting to Data

Lecture 3 Connecting to Excel

Lecture 4 Connecting to Other Sources

Section 3: Transforming Data

Lecture 5 Cleaning Up Data

Lecture 6 Working with Rows and Columns

Lecture 7 Manipulating Data

Lecture 8 Adding New Columns

Lecture 9 Managing Applied Steps

Section 4: Queries

Lecture 10 Managing Queries

Lecture 11 Using Append Queries

Lecture 12 Using Merge Queries

Lecture 13 Creating a Web Query

Intermediate to advanced Excel users who need to import, clean up, or manage data on a repeated basis.