|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/pivottable-calculated-fields-and-items-advanced-excel/
课程评论：没有评论
**课程名称：** Excel高级数据透视表：计算字段和计算项 **课程概述：** 本课程将帮助您提升Excel数据分析能力，专注于掌握数据透视表的高级功能——计算字段和计算项。通过本课程，您将学会如何在不修改原始数据的情况下，直接在数据透视表中进行复杂的计算，从而获得更深入的数据洞察。 **课程内容亮点：** * **计算字段：** 学习如何构建自定义计算字段，进行销售利润、成本百分比等分析。 * **计算项：** 掌握如何创建计算项，对数据子集进行分类和比较，例如计算不同季度的增长率。 * **求解顺序（Solve Order）：** 理解并运用求解顺序功能，确保在存在多个计算项时，公式计算顺序的准确性。 * **GETPIVOTDATA函数：** 学习如何使用GETPIVOTDATA函数从数据透视表中提取特定数据，用于自定义报告和摘要。 * **实操练习：** 课程提供可下载的讲师文件和练习文件，方便您动手实践，巩固学习成果。 * **学习形式：** 包含视频演示和实践练习，共计49分钟的视频教程，分为7个独立的视频讲座。 **课程目标：** * 理解计算字段和计算项的用途。 * 能够构建包含合适公式的计算字段。 * 能够创建计算项，分析数据子集。 * 能够利用求解顺序解决计算项之间的冲突。 **课程适合：** 希望通过Excel高效分析数据、优化报告的初学者及有一定Excel基础的用户。 **您将获得：** * 全程可下载的课程及练习文件 * 学习证明（Certificate of completion）
**This course includes downloadable course instructor files and exercise files to work with and follow along.**Welcome to Advanced PivotTables in Excel, designed to elevate your data analysis skills.In this course, you'll learn how to harness the power of calculated fields and items to perform complex calculations directly within your PivotTables. From creating calculated fields to manipulating grand totals and adding calculated items, you'll master the art of deriving meaningful insights from your data without altering the original dataset.You'll also explore the solve order feature, which helps manage the calculation sequence when multiple formulas are used, ensuring accurate results. Additionally, you'll be introduced to the GETPIVOTDATA function, allowing you to extract specific data from PivotTables for use in custom reports and summaries.Each module includes video demonstrations and practical exercises to ensure you master each concept. Whether you're looking to streamline your data analysis or present your findings clearly, this course will provide you with the necessary tools and knowledge.In this course, you will learn how to:Identify the purpose of calculated fields and calculated items.Construct a calculated field using an appropriate formula.Create a calculated item to analyze subsets of data.Utilize Solve Order to resolve conflicts between calculated items.This course includes:49 minutes of video tutorials7 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion
