|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-pivots-dashboards-basic-to-super-advance/
课程评论：没有评论
Coursera 课程《Excel 数据透视表与仪表板（从基础到超级高阶）》内容总结： 本课程共包含7个部分，旨在提供Excel数据透视表、切片器、数据透视图和仪表板的全面培训，并辅以大量练习。 **核心内容与技能点：** * **数据透视表基础与精通：** * 深入理解数据透视表的运作机制，通过不同难度的练习进行实践。 * 掌握数据透视表的关键规则，包括数据标题和数据点布局。 * 熟悉数据透视表的设计选项，如小计、总计、重复标签、空白行等。 * 了解并运用不同的数据透视表布局形式（如表格型、紧凑型）及其优势。 * 学习数据透视表常用的快捷键，提高操作效率。 * 探索数据透视表右键菜单中的隐藏功能，如打开时刷新、显示无数据、错误处理、空白数据处理等。 * **数据分析与计算：** * 学习如何使用行或列字段汇总数据，分析其优缺点。 * 掌握在数据透视表中计算百分比、累计总计或进行总计比较的方法（例如，按单项汇总流程贡献）。 * 学习在数据透视表中进行排名计算。 * **交互式视图与仪表板构建：** * 学习创建和使用数据透视表切片器，并将其应用于仪表板。 * 掌握如何使用一个切片器连接多个数据透视表，并理解其重要性（报告连接功能）。 * 学习自定义切片器设计，摆脱预设样式，进行精细化格式设置。 * 了解如何利用筛选器和切片器，无需VBA代码或复杂公式，创建交互式数据视图。 * 学习在数据透视表中创建和使用公式。 * 掌握数据透视表中的条件格式化应用。 * 学习创建数据透视图。 * 综合运用以上功能，创建功能强大的Excel数据透视表仪表板。 * **实践与巩固：** * 通过15个数据透视表练习题来巩固所学知识，并提供详细的解决方案。 本课程适合所有希望深入掌握Excel数据分析和可视化技巧的学习者，从初学者到高级用户均可从中获益。
This course has 7 sections to give you a complete Training on Excel Pivots , Slicers , Pivot Charts and Dashboards, exercises and much more.Deep dive into Pivot functioning by doing different level of exercises.Rules to follow in Pivots - Data headers and data point layoutsKnow the Pivot Designs, subtotal feature, Grand Total Feature, Repeat labels, Blank lines and many more.Know the tabular form, compact form and others and their benefits. Shortcut keys to be used in PivotsWhat is there in right click on pivot options - Hidden features like refresh on open, No data show, errors handling, blank data handling and many more.How to summarize the data using Row or column fields - Benefits and disadvantages.How to create Pivot percentage numbers and cumulative totals or comparisons in totals like may be if you want to summarize the data on process contribution over single item.Ranking calculation in Pivots - its amazingHow to Create Slicers in Pivots and use in dashboards.How to link many pivots with one single slicer only and why we should know that. Introducing the report connection. Easy and powerful.How to customize the Slicers if you do not wish to use the ready made Slicer designs - its magnificent. Deep dive into slicer formatting.Learn how to use filters and slicers to make INTERACTIVE views of data without using any VBA Coding and formulas.How to create formula in Pivots and how to use that.Conditional Formatting in Pivots - Its amazingLearn how to create Pivot ChartsHow to create Pivot Dashboards in excel using all mentioned above features.I have given you assignments also on Pivots- There are 15 exercises in the series so we can always know how much we have learnt so far. Don't you worry, it has solutions as well explained in detail by me in the Pivot assignment section.
