|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/pivottables-in-excel-course-for-beginners/
课程评论：没有评论
Coursera 课程《Excel 数据透视表入门》为您提供一份全面的数据分析指南，特别侧重于 Excel 中的数据透视表这一强大工具。 **课程概述：** 在本课程中，您将学习如何高效地处理和分析大量数据，这在当今数据驱动的世界中至关重要。数据透视表是进行大数据分析和可视化的核心 Excel 技能，它提供了一种互动式的方法，可以快速地对数据集进行分组、汇总和分析。 **课程内容亮点：** * **数据准备：** 学习数据清理和准备的重要性，为创建有效的数据透视表打下坚实基础。 * **创建和使用数据透视表：** 从创建基础数据透视表开始，掌握使用“数据透视表字段”窗格进行字段添加和重排。 * **数据汇总与分析：** 探索不同的数据汇总方法，学习如何对数据进行分组，应用多个字段和维度。 * **格式化与布局：** 了解如何格式化数字、选择和锁定报表布局，以及应用数据透视表样式。 * **高级功能：** 学习排序、过滤数据，并基于数据透视表创建数据透视图。 * **可视化与仪表板：** 掌握如何选择合适的图表类型，应用条件格式，以及使用切片器和事件轴（Timelines）创建动态仪表板。 * **数据更新：** 学习如何向原始数据集添加新数据并更新数据透视表和图表。 **课程特色：** * **实践导向：** 课程包含可下载的讲师文件和练习文件，方便您跟随学习和实践。 * **内容丰富：** 提供超过 5 小时的视频教程，包含 64 个独立的视频讲座。 * **成果认证：** 完成课程后可获得结业证书。 **目标学员：** 本课程特别适合初次接触数据透视表的用户，或希望拓展 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. Due to such weight placed on data analysis, it is crucial for you to have 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 while letting you analyze data 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 Pivot Charts and format your PivotTables and charts.This course is aimed at those brand-new to PivotTables or for beginner Excel users looking to expand their skills. This course includes downloadable excel data files that the instructor uses in the tutorial so you can follow along.In this course, you will learn:How to clean and prepare your dataCreating a basic PivotTableUsing the PivotTable fields paneAdding fields and pivoting the fieldsFormatting numbers in PivotTableDifferent ways to summarize dataGrouping PivotTable dataUsing multiple fields and dimensionThe methods of aggregationHow to choose and lock the report layoutApplying PivotTable stylesSorting data and using filtersCreate pivot charts based on PivotTable dataSelecting the right chart for your dataApply conditional formattingAdd slicers and timelines to your dashboardsAdding new data to the original source datasetUpdating PivotTables and chartsThis course bundle includes:5+ hours of video tutorials64 individual video lecturesCertificate of completionCourse and exercise files to follow along
