|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-training-power-pivot-power-query-dax/
课程评论：没有评论
课程名称: Microsoft Excel培训 - Power Pivot、Power Query与DAX 课程概述: 本课程包含实践练习和终身访问权限。在这个高级Excel课程中，我们将探讨三个关键的高级Excel功能：Power Pivot、Power Query和DAX。这一套Excel功能可让您处理、分析和评估来自Excel或其他数据库的数百万行数据。我们首先学习如何使用Power Query将数据汇集、合并和清理，然后建立数据表之间的关系并构建数据模型。接下来，我们将使用DAX对数据模型进行计算，最后使用数据透视表和数据透视图展示我们的分析成果。如果您需要使用Excel处理大规模数据，这些工具将为您解锁这种能力。本课程还包括实践练习和随堂文件，以便您在学习的过程中建立自己的数据模型。 您将学习到： - 如何开始使用Power Query - 如何将Excel连接到多个工作簿 - 如何从网络和其他来源获取数据 - 如何使用Power Query合并和追加查询 - Power Pivot窗口的工作原理 - 如何在数据模型中设置和管理关系 - 如何创建数据透视表以展示来自Power Pivot数据模型的数据 - 如何使用DAX添加计算列 - DAX中的CALCULATE、DIVIDE、DATESYTD等函数的使用 - 如何创建数据透视图和数据透视表并利用您的数据模型 - 如何使用切片器调整显示的数据 课程包括： - 3小时以上的视频教程 - 44个独立视频讲座 - 练习文件以实践所学知识 - 完成证书 本课程是使用Office 365的Excel录制的，也适用于使用其他较新版本Microsoft Excel的用户。 学生反馈： “讲师的表述非常清晰，将概念简单明了地分解。我非常喜欢这个课程!” - Kamal Yusuf “这真是一次惊人的体验！值得一试。有很多我之前不知道的内容，也是复习一些基本步骤的好机会。非常好！强烈推荐！” - Andriana 你知道吗？Simon Sez IT教授各种软件，包括： - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - 网络开发语言 - 以及更多！
**This course includes practice exercises and LIFETIME access**In this advanced Excel course, we look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases.We first look at how to bring your data together, merge, and clean it using Power Query before moving onto creating relationships between our data tables and building out a data model. We then look at performing calculations on our data model using DAX, and finally, we look at displaying our analysis using PivotTables and PivotCharts.If you've reached a point where you need Excel to work with data at scale, then these tools will unlock that capability. This course also includes practice exercises and follow-along files so you can build your data models as we go.In this course you will learn:How to get started with Power QueryHow to connect Excel to multiple workbooksHow to get data from the web and other sourcesHow to merge and append queries using Power QueryHow the Power Pivot window worksHow to set up and manage relationships in a data modelHow to create a PivotTable to display your data from the Power Pivot data modelHow to add calculated columns using DAXHow to use functions such as CALCULATE, DIVIDE, DATESYTD in DAXAll about creating Pivot Charts and PivotTables and using your data modelHow to use slicers to adjust the data you displayThis course includes:3+ hours of video tutorials44 individual video lecturesExercise files to practice what you learnedCertificate of completionThis course was recorded using Excel from Office 365. It's also relevant to those using other, recent versions of Microsoft Excel.Here's what our students are saying…"The instructor speaks with a great deal of clarity and breaks down the concept in a simple manner. Enjoying the course so far!:-)"- Kamal Yusuf"It's been an amazing experience! Worth to try it.There are so many things I didn't know about, and it's a good opportunity to remind some basic steps. EXCELLENT WORK!!! HIGHLY RECOMMEND IT!!!"- AndrianaDid you know?Simon Sez IT teaches all sorts of software, including:- Microsoft Excel- Microsoft PowerPoint- Microsoft Word- Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements- Web Development Languages- And so much more!
