|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/creating-excel-tables-and-pivottables-for-beginners/
课程评论：没有评论
**Coursera课程总结：Excel表格与数据透视表新手入门** 本课程是为Excel新手量身打造的数据分析入门课程，旨在帮助您掌握Excel中最强大的数据分析工具之一——数据透视表。 **课程亮点：** * **区分Excel表格与数据透视表：** 学习两者的核心区别，为高效数据分析奠定基础。 * **创建与管理Excel表格：** 掌握从原始数据创建Excel表格，并应用格式化和命名规范进行管理。 * **数据透视表应用：** * **快速分析：** 学习如何快速定位并应用推荐的数据透视表进行高效数据分析。 * **布局与定制：** 了解不同的数据透视表布局，并学会灵活manipulate字段以定制您的数据分析。 * **数据聚合：** 探索多种数据聚合方法，包括求和（sum）、计数（count）、平均值（average）、最大值（max）和最小值（min）等。 * **多维度分析：** 学习结合使用多种聚合方式进行全面分析。 * **分组与汇总：** 掌握在数据透视表中对数据进行分组和取消分组，创建自定义摘要。 * **实践导向：** 课程提供可下载的讲师文件和练习文件，方便您跟随学习和动手实践。 * **课程内容：** 包含79分钟的视频教程，共16个视频讲座。 * **成果认证：** 完成课程后，您将获得结业证书。 加入本课程，您将学习如何组织和操作数据，获得可指导决策的宝贵洞见，从而让您的数据分析更具活力和效率。
**This course includes downloadable course instructor files and exercise files to work with and follow along.**Welcome to PivotTables for Beginners, your gateway to mastering one of Excel's most powerful data analysis tools. In this beginner-friendly course, you'll discover the key distinctions between Excel Tables and PivotTables, which are essential for efficient data analysis. This course also teaches you how to easily organize and manipulate data, gain valuable insights that can inform decision-making processes, and explore various techniques, from creating basic PivotTables to customizing and refining your analysis. You'll explore the diverse methods of data aggregation and grouping available in Excel, and grasp how to aggregate data by summing, counting, averaging, and more.Join us and transform how you handle data with PivotTables, making your analysis more dynamic and efficient. Course files are included and available to download, allowing you to follow along and practice as you learn. Dive in and discover how PivotTables can enhance your data analysis skills today.In this course, you will learn how to:Identify differences between Excel Tables and PivotTables.Create an Excel Table from raw data.Apply formatting and naming conventions to tables.Identify the location of Recommended PivotTables.Apply Recommended PivotTables to analyze data efficiently.Differentiate between various PivotTable layouts.Manipulate PivotTable fields to customize data analysis.Identify different methods of aggregation in PivotTables.Apply aggregation functions such as sum, count, average, max, and min.Combine multiple aggregation methods for comprehensive analysis.Group and ungroup data in PivotTables for customized summaries.This course includes:79 minutes of video tutorials16 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion
