Excel - Power Query (2023)

[nieriorefasow63]

Excel - Power Query (2023)
Published 6/2023
Created by Bigger Brains
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 13 Lectures ( 1h 26m ) | Size: 1.32 GB


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.

Who this course is for
Intermediate to advanced Excel users who need to import, clean up, or manage data on a repeated basis

HOMEPAGE

[To see links please register or login]

DOWNLOAD

[To see links please register or login]