|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-pivot-table-with-dashboard-in-excel-365/
课程评论：没有评论
**课程名称：** Excel 365 高级数据透视表与仪表盘 **课程概览：** 本课程旨在教授学员如何利用 Excel 365 中的数据透视表功能创建功能强大且视觉效果出色的仪表盘。课程涵盖了数据透视表的快速回顾，并深入讲解了高级的数据透视表创建方法，包括使用动态范围创建数据透视表。 学员将学习到高级的数据分析技巧，例如： * 计算列之间的差异 * 智能自定义数字格式 * 双击查看明细数据 * 创建自定义分组 * 分组日期字段 课程还将介绍一些高级数据透视表应用技巧，例如： * 使用快捷键 `Alt + D + P` 打开数据透视表和数据透视图向导 * 使用快捷键 `Alt + N + V` 快速创建数据透视表 * 双击数据透视表中的数值以查看其背后的详细数据 * 链接多个数据透视表，实现统一筛选 此外，课程强调了 Excel 的“数据模型”功能，该功能允许连接多个表格并基于其创建数据透视表，这对于处理复杂数据至关重要。 **学习目标：** * 掌握创建美观数据仪表盘的技巧 * 精通数据透视表的进阶创建与应用 * 运用高级数据分析技术深入洞察数据 * 提升 Excel 在数据分析和任务自动化方面的能力 （课程包含3小时以上的视频教程和练习文件，适用于 Excel 365 及近期版本（如 Excel 2013, 2016, 2019）的用户。）
What you'll learnHow to create amazing looking dashboards using Pivot TablesHow to do a PivotTable (a quick refresher)Advanced Pivot Table MethodCreate Pivot Table with Dynamic RangeAdvanced data analysis techniquesAdvanced data analysis techniquesPivot tables are a data processing technique that use statistical functions to summarize data from other tables. They allow users to expand, isolate, sum, and group data. The pivot function rotates a column into a row, aggregates values, and allows users to filter, sort, group, and create custom calculations Some advanced features of Excel pivot tables include:Calculating the difference between columnsSmart custom number formattingDouble-clicking to view detailsCreating custom groupingsGrouping date fieldsHere are some tips for using pivot tables in Excel:Use the keyboard shortcut Alt + D + P to open the PivotTable and PivotChart WizardUse the keyboard shortcut Alt + N + V to quickly create a pivot tableDouble-right click on a value inside a pivot table to see the data behind that aggregated valueAn advanced pivot table in Excel is a way to link multiple pivot tables together so that you can filter all of them at once. This is instead of having to change the filter on each pivot table individuallyAdvanced Pivot Table Techniques You Should Know in 2024You can use "Data Model" feature of Excel to connect multiple tables and create pivots from themMaster the skills of advanced Excel including Pivot Tables with our comprehensive course. Learn to analyze, visualize data and automate tasksThis course includes:3 + Hours of Videos TutorialsExercise files to practice what you learnedThis 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.
