|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/working-with-power-query-advanced-excel/
课程评论：没有评论
课程名称：使用 Power Query 的高级 Excel 课程概述：本课程包括可下载的课程讲师文件和练习文件，方便学习和跟进。欢迎参加我们的 "Microsoft Excel: Power Query" 课程。在这个全面的课程中，您将深入探索 Power Query 的强大功能，使您能够高效地处理和分析 Excel 中的数据。通过引人入胜的课程，您将学习如何使用获取和转换功能无缝导入数据，导航多功能的 Power Query 编辑器，并灵活地组合和转换文件，以满足您的分析需求。 您还将学习如何清理杂乱的数据，删除重复项，拆分列，并应用筛选器来准备数据集以便报告。您将掌握如何合并来自多个源的查询，创建自定义列，并应用支持准确和有序输出的转换。完成本课程后，您将具备将精炼的数据直接加载到 Excel 中的技能，从而提升您的生产力和决策能力。通过我们的实用方法，提升您的 Excel 技能，节省时间，提高分析能力。 课程目标：在本课程中，您将学习如何： - 高效地使用获取和转换导入数据 - 导航和利用 Power Query 编辑器 - 无缝组合和转换文件 - 直接将精炼的数据加载到 Excel 中 课程包括： - 42 分钟的视频教程 - 9 个独立的视频讲座 - 课程和练习文件以便跟进 - 完成证书
**This course includes downloadable course instructor files and exercise files to work with and follow along.** Welcome to our "Microsoft Excel: Power Query" course. In this comprehensive program, you will delve into the powerful world of Power Query, empowering you to manipulate and analyze data in Excel efficiently. Through engaging lessons, you will learn how to import data seamlessly using Get and Transform, navigate the versatile Power Query Editor, and adeptly combine and transform files to meet your analytical needs.You will also explore how to clean messy data, remove duplicates, split columns, and apply filters to prepare your datasets for reporting. Learn how to merge queries from multiple sources, create custom columns, and apply transformations that support accurate and organized outputs.By the end of this course, you should possess the skills to load refined data directly into Excel, enhancing your productivity and decision-making abilities. Elevate your Excel skills, save time, and improve your analytical capabilities with our hands-on approach to Power Query essentials. Course ObjectivesIn this course, you will learn how to:Import data efficiently using Get and Transform.Navigate and utilize the Power Query Editor.Combine and transform files seamlessly.Load refined data directly into Excel.This course includes:42 minutes of video tutorials9 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion
