|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-pivot-tables-in-depth/
课程评论：没有评论
**课程名称：** Microsoft Excel 数据透视表 - 深度 Excel 培训 **课程概述：** 本课程由 Infinite Skills 提供，旨在教授学员 Excel 中最强大的功能之一——数据透视表。课程面向已具备 Excel 基本知识的用户。学员将从数据准备、手动创建数据透视表以及使用数据透视表工具的基础知识开始学习。随后，课程将深入探讨数据透视表数据的管理，包括理解和操作数据透视表缓存、处理数据源以及在数据透视表中进行数据透视。此外，课程还将教授如何正确格式化数据透视表，包括应用基本格式、重命名字段和格式化数字。最后，课程将涵盖数据透视表的排序和筛选、计算功能操作以及使用图表可视化数据透视表数据等主题。完成本视频课程后，学员将能够熟练运用各种方法创建数据透视表，并灵活地操控其结构和功能。课程包含配套的练习文件，方便学员跟随讲师进行实践。
This Microsoft Excel - Pivot Tables training course from Infinite Skills teaches you everything you need to know about pivot tables, one of the most powerful features in Excel. This course is designed for users that already have a basic understanding of Excel. You will start out by learning the basics of pivot tables, such as how to prepare your data, creating manual pivot tables, and using pivot table tools. You will then learn how to manage pivot table data, including understanding and working with the pivot cache, working with the data source, and pivoting data in a pivot table. This course will show you how to properly format pivot tables, teaching you how to apply basic formatting, rename pivot table fields, and format numbers. Finally, this video tutorial will cover topics such as how to sort and filter pivot tables, manipulate calculations, and visualize table data with charts. Once you have completed this video based training course, you will be comfortable with creating pivot tables using a variety of different methods and manipulating their structure and functionality. Working files are included, allowing you to follow along with the author throughout the lessons.
