|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-data-analytics-power-query-and-pivottables/
课程评论：没有评论
**课程名称：** Microsoft Excel - 数据分析 Power Query 和数据透视表 **课程概述：** 本课程将深入介绍 Microsoft Excel 中一项革命性的新功能——Power Query，它被认为是自数据透视表以来 Excel 最重要的更新。Power Query 能够极大地节省您在检索、清理和转换数据以用于报告时的宝贵时间，轻松应对手动操作中的重复性任务和复杂公式，包括： * **数据查找：** 每次需要报告时都能快速找到数据。 * **数据清理：** 清理数据列，去除不必要的字符和多余空格。 * **数据转换：** 分割或合并列值，纠正数据格式，根据需要过滤数据。 * **数据整合：** 将多个数据集合并成一个主列表。 * **数据布局：** 调整数据布局以方便与 Excel 数据透视表和图表等其他工具配合使用。 课程将指导您通过**获取数据 (Get Data)**、**转换/清理数据 (Transform/Clean Data)**、**报告数据 (Report on Data)** 这三个简单步骤，即可快速生成可供演示的最终报告。一旦设置完成，您只需点击“刷新”按钮，Power Query 就会自动更新报告，无需重新进行所有操作。 **版本兼容性：** * Excel 2016、2019 和 Office 365：Power Query 作为“获取和转换”功能内置于“数据”选项卡中（**不适用于 Mac 版本**）。 * Excel 2010 和 2013：可通过 Microsoft 提供的免费下载安装。 **课程内容包括：** * 超过 6 小时的视频内容。 * 可下载的练习文件，以便您跟随学习。 * 通过问答区与讲师互动。 通过本课程，您将快速掌握使用 Excel Power Query 管理和报告数据的强大能力。
Microsoft Excel's Power Query tool is the biggest feature Microsoft has added to Excel since PivotTables. Seriously, no joke. Read on to learn more about Excel Power Query and how you'll save loads of time as you take advantage of this powerful feature.In Excel 2016, 2019 and Office 365, Power Query is built directly in the Excel interface through the GET AND TRANSFORM command on the Data tab. (Power Query is NOT available on the MAC release of Excel)Power Query is available on Excel 2010 and 2013 through a free download from Microsoft as described in the course.Lets face it, retrieving, cleaning and transforming data to report on can take hours of precious time. With Excel Power Query you can eliminate repetitive tasks freeing your time for other important tasks, like lunch and going home on time. Excel Power Query removes the hassle and complex formulas of manual tasks such as:Finding the Data each time you need a reportCleaning Columns of DataSplitting or Joining Column ValuesRemoving unnecessary characters and extra spacesFormatting data correctlyFiltering data needed for the reportCombining multiple Datasets into a master listManipulating the data layout to work with other tools, i.e. Excel PivotTables and ChartsIn just 3 easy steps, you'll have a final report ready for presentation and your next raise.Get DataTransform/Clean DataReport on DataOnce you've got it all setup with Excel Power Query all you need to do is hit the Refresh button to update the report with next weeks data. Microsoft Power Query remembers all the steps you performed to get, transform and clean the data all you do is refresh and your report is updated.Sounds all too easy, right? Enroll now and let me guide you through Excel Power Query and you'll quickly be on your way to harnessing the power of managing and reporting on data with Excel Power Query.This Excel Power Query Course Includes:6+ hours of video contentDownloadable exercise files to follow alongAccess to the instructor through the QA section
