|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-complete-excel-pivot-tables-course-beginner-to-advanced/
课程评论：没有评论
**课程名称：** Excel 数据透视表从入门到精通 **课程概述：** 本课程旨在帮助您掌握 Excel 数据透视表这一强大的数据分析工具，从基础概念到高级应用，助您高效处理和分析海量数据。课程包含可下载的讲师文件和练习文件，方便您同步学习和实践。 **核心内容：** * **数据清洗与准备：** 学习在创建数据透视表前进行数据清洗和准备的重要性与方法。 * **创建数据透视表：** 掌握数据透视表的创建步骤，熟悉字段列表、添加字段及计算字段。 * **值字段设置与格式化：** 学习如何设置值字段，对数字进行格式化，以及多种数据汇总方法。 * **数据分组与错误处理：** 了解如何对数据透视表数据进行分组、取消分组以及处理常见错误。 * **多字段与维度应用：** 学习使用多个字段和维度进行更深入的数据分析。 * **聚合方法与报表布局：** 掌握不同的聚合方法，选择并锁定报表布局。 * **数据透视表格式化与样式：** 学习如何美化数据透视表，应用各种样式。 * **排序与筛选：** 掌握从基础到高级的排序和筛选技巧。 * **创建数据透视图：** 学习创建数据透视图，添加迷你图和切片器，并选择合适的图表类型进行数据呈现。 * **切片器与时间轴：** 掌握切片器的使用，及其在多个数据表中的应用，以及时间轴的添加和应用。 * **多工作表数据整合：** 学习如何整合来自多个工作表的数据创建数据透视表。 * **GETPIVOTDATA 函数：** 深入了解 GETPIVOTDATA 函数的使用。 * **3D 地图应用：** 学习如何通过数据透视表创建 3D 地图。 * **数据更新：** 掌握向原始数据源添加新数据以及更新数据透视表和数据透视图的方法。 * **条件格式：** 学习在数据透视表中应用条件格式。 * **创建仪表板：** 指导您创建具有吸引力的数据仪表板。 **课程亮点：** * **超过 13 小时的视频教程** * **超过 100 个独立的视频讲座** * **提供课程和练习文件，助您同步学习** * **完成课程可获得结业证书** **目标学员：** 本课程适合对数据透视表完全陌生的初学者，以及希望扩展 Excel 技能的进阶用户。
**This course includes downloadable course instructor files and exercise files to work with and follow along.**Data analysis is essential in today's data-driven world. Data is crucial in understanding businesses, analyzing trends, and forecasting your business needs. It is crucial that you have the relevant skills to handle and analyze data efficiently.PivotTable is a vital Excel skill for big data analysis and visualization jobs. PivotTables are an interactive way of quickly summarizing large amounts of data by grouping and aggregating datasets, letting you analyze the information in a clear and effective manner.This course will discuss the importance of cleaning your data before creating your first PivotTable. You will also learn how to create PivotCharts and format your PivotTables and charts. We teach you how to make the most of this powerful data analysis tool by using some of its advanced features, including advanced sorting, slicers, timelines, calculated fields, and conditional formatting.This course is aimed at those brand new to PivotTables and also intermediate users looking to expand their Excel skills. You can download the Excel data files that the instructor uses in the tutorials so you can readily follow along.This course covers:Cleaning and preparing your dataHow to create PivotTablesUsing the fields pane and adding fields and calculated fieldsHow to use the value field settingsFormatting numbers in PivotTableDifferent ways to summarize dataGrouping and ungrouping PivotTable data and dealing with errorsUsing multiple fields and dimensionMethods of aggregationChoosing and locking the report layoutHow to format PivotTables and apply stylesBasic to advanced sorting and filteringCreating PivotCharts and adding sparklines and slicersSelecting the right chart to present your dataAdding slicers and timelines and applying them to multiple tablesCombining data from multiple worksheets for a PivotTableAll about the GETPIVOTDATA functionHow to use 3D maps from a PivotTableAdding new data to the original source datasetUpdating your data in a PivotTable and PivotChartUsing conditional formatting in a PivotTableHow to create amazing dashboardsThis course bundle includes:13+ hours of video tutorials100+ individual video lecturesCertificate of completionCourse and exercise files to follow along
