|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-sorting-and-filtering-pivottables-in-excel/
课程评论：没有评论
**课程名称：Excel高级数据透视表：排序与筛选** **课程概述：** 本课程旨在帮助您精通Excel数据透视表的高级排序和筛选技巧，从而提升数据分析能力。课程提供可下载的教学文件和练习文件，方便您跟随学习。 **您将学到：** * **高效汇总数据：** * 使用“汇总方式”功能，通过求和、平均值、最大值、最小值等多种函数对数据进行聚合。 * **动态比较数据：** * 计算总计的百分比。 * 显示值的累积汇总。 * 将值与前一项进行比较。 * 对值进行排名（从小到大）。 * **掌握多种排序方法：** * 按升序、降序对数据进行字母或数字排序。 * 根据不同字段进行排序。 * 运用手动拖放的方式进行自定义排序。 * 应用自定义排序顺序以满足特定需求。 **课程特色：** * 包含51分钟的视频教程，共8个独立视频讲座。 * 提供课程和练习文件，支持实践操作。 * 每章节均配有视频演示和实践练习，确保知识的掌握。 * 完成课程后可获得证书。 **课程目标：** 无论您是想优化数据分析流程，还是希望更清晰地展示分析结果，本课程都将为您提供必要的工具和知识，助您将数据透视表技能提升到新的高度。
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 explore techniques to summarize values efficiently and compare data dynamically. You'll learn how to utilize the Summarize Values By option to aggregate data using various functions like sum, average, min, max, and more. You'll also explore sorting methods to arrange your data alphabetically or numerically, ascending or descending, based on various fields. Gain insights into custom sorting orders tailored to your specific needs.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. Join us and take your PivotTable skills to the next level.In this course, you will learn how to:Calculate the percentage of grand totals.Display running totals for values.Compare values with previous items.Rank values from smallest to largest.Perform basic sorting in PivotTables.Utilize manual sorting by dragging items.Apply custom sorting orders in PivotTables.This course includes:51 minutes of video tutorials8 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion
