|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-pivottables-and-pivotcharts-in-excel/
课程评论：没有评论
**课程名称：Excel 高级数据透视表与数据透视图** **课程概述：** 本课程专注于教授Excel中高级数据分析与可视化技术。学员将学习如何通过创建自定义样式、应用独有数字格式以及使用自定义列表排序数据来定制数据透视表。此外，课程还将深入讲解如何应用多重筛选器和调整切片器设置以实现精确的数据操作。您将掌握创建计算字段和计算项，以洞察复杂的数据关系。课程还涵盖GETPIVOTDATA函数，帮助您高效提取特定数据点。在数据透视图部分，您将学习如何创建动态标题和系列，并在堆积柱形图中添加总计。掌握这些Excel高级功能将显著提升您的数据分析能力，并优化决策流程。 **课程亮点：** * **自定义数据透视表：** 学习应用独特样式和格式。 * **自定义排序：** 使用自定义列表对数据进行特定排序。 * **多重筛选：** 掌握应用多个筛选器以进行精确分析。 * **切片器调整：** 学习调整切片器设置以增强数据可视化。 * **计算字段与项：** 创建用于高级数据分析的计算字段和项。 * **动态数据透视图：** 学习使用动态功能创建交互式可视化。 **课程内容包含：** * 130分钟视频教学 * 17个独立视频讲座 * 提供课程和练习文件，方便学员跟学 * 完成课程可获得证书
**This course includes downloadable course instructor files and exercise files to work with and follow along.**In this Advanced PivotTables and PivotCharts in Excel course, you'll explore advanced data analysis and visualization techniques. You'll learn to customize PivotTables by creating custom styles, applying unique number formatting, and sorting data using custom lists.Additionally, you'll master the art of applying multiple filters and adjusting slicer settings for precise data manipulation. You'll gain insights into complex data relationships by creating calculated fields and items.The course also covers the GETPIVOTDATA function, enhancing your ability to extract specific data points efficiently. In the PivotCharts section, you'll discover how to create dynamic titles and series and add totals to stacked column charts. Mastering these advanced Excel features will significantly enhance your data analysis skills and streamline decision-making processes.In this course, you will learn how to:Customize PivotTables with unique styles and formatting.Sort data using custom lists for specific ordering.Apply multiple filters to data for precise analysis.Adjust slicer settings to enhance data visualization.Create calculated fields and items for advanced analysis.Utilize dynamic features in PivotCharts for interactive visuals.This course includes:130 minutes of video tutorials17 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion
