|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-pivottables-in-excel-master-the-pivot-table/
课程评论：没有评论
课程名称：Excel 中高级数据透视表：掌握数据透视表！ 课程概述： 在本课程中，我们将教您如何充分利用 Excel 中强大的数据分析功能——数据透视表。数据透视表非常适合快速高效地进行数据分析。课程开始时会进行数据透视表的复习，随后深入介绍一些高级功能，包括高级排序、切片器、时间线、计算字段、数据透视图和条件格式设置。该课程针对对数据透视表操作比较熟练的中级用户，不适合 Excel 初学者。如果您是 Excel 的新手，建议先学习 Udemy 里的 Simon Sez IT 的初学者课程。 本课程内容包括： - 数据透视表的快速复习 - 如何将多个工作表的数据合并为一个数据透视表 - 分组、取消分组及处理错误 - 数据透视表的格式设置，包括样式调整 - 值字段设置的使用 - 数据透视表中的高级排序和筛选 - 如何在多个表上使用切片器和时间线 - 创建计算字段 - GETPIVOTDATA 函数的使用 - 如何创建数据透视图并添加迷你图和切片器 - 从数据透视表使用 3D 地图 - 更新数据透视表和数据透视图 - 数据透视表中的条件格式设置 - 创建出色的仪表板 课程包含： - 7+ 小时的视频教程 - 50 个独立视频讲座 - 练习文件以巩固所学知识 - 完成证书 课程录制使用的是 Office 365 的 Excel，也适用于其他较新版本的 Microsoft Excel，包括 Excel 2013、2016 和 2019。 学员反馈： 许多学生表示课程讲解清晰易懂，内容深入全面，适合希望扩展数据透视表知识的用户，课程非常值得推荐，极大地提升了他们使用数据透视表和图表的信心。
In this Advanced PivotTables in Excel course, we teach you how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel.In this course, we give a PivotTable refresher before moving onto some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting.This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function. We don't recommend this course for people brand new to Excel. If you are new to Excel, try out one of the Simon Sez IT Beginner Excel courses also available on Udemy.In this course, you will learn:How to do a PivotTable (a quick refresher)How to combine data from multiple worksheets for a PivotTableGrouping, ungrouping and dealing with errorsHow to format a PivotTable, including adjusting stylesHow to use the Value Field SettingsAdvanced Sorting and Filtering in PivotTablesHow to use Slicers, Timelines on multiple tablesHow to create a Calculated FieldAll about GETPIVOTDATAHow to create a Pivot Chart and add sparklines and slicersHow to use 3D Maps from a PivotTableHow to update your data in a PivotTable and Pivot ChartAll about Conditional Formatting in a PivotTableHow to create amazing looking dashboardsThis course includes:7+ hours of video tutorials50 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 including Excel 2013, 2016, and 2019.Here's what our students are saying…"Course is well presented with good explanations and is easy to follow. The Advanced Pivot Table course starts with a recap and goes on to a very thorough and in-depth look at advanced concepts and properties. Very useful if you can use Pivot Tables and want to expand your knowledge. Overall a very good and worthwhile course. I learned a lot and would thoroughly recommend it."- Robert"Very well conceived and well constructed course. Well explained and clutter free."- John"I liked her teaching, once trained skipped over simple items and didn't waste our time with repeating it. Dashboard courses I have taken two already and I always pick up new things - here spark lines. Thank You."- Duane"Excellent course delivery. Enjoyed every step and confident using pivot tables and charts."- Olatubosun
