Excel – Power Query (2023)

Excel - Power Query (2023)

 

ดาวน์โหลดคอร์สเรียน Excel - Power Query (2023) ฟรี

หมวดหมู่ (Category) : Office Productivity

 

รายละเอียด (Details) : 

 

Published 6/2023
Created by Bigger Brains
MP4 | Video: h264, 1280×720 | 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.

 

 

📋 More Info


 

ตัวอย่างหลักสูตร
(Course Preview)

Excel - Power Query (2023)

 

File Info

Official Website : https://www.udemy.com/course/excel-power-query-j/
License : FOR EDUCATIONAL PURPOSES ONLY
File Name : Excel - Power Query.rar
File Size : 1.39 GB
File Type : *.rar
Server : Google Drive
Upload date : 9/6/2023
Last modified : 9/6/2023
Password : sbz

Warning! This file is for educational and non-commercial use only. Downloading copyrighted material is illegal and all the files here are only for educational uses. To support creators/developers Please purchase a genuine version from the official website. We don’t own and resell this product, we got this from a free source. Developers/creator/maker made it with difficulty. Please purchase a genuine license from the official website.
📜 Buy

💾 ดาวน์โหลด 
 
รหัสแตกไฟล์คือ sbz  


วิธีดาวน์โหลด |  วิธีแก้ลิ้งค์เกินโควต้า


🗨  JOIN OUR COMMUNITY