|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-t/
课程评论：没有评论
**课程名称：** 学习 Microsoft Excel：职场进阶策略 **课程概述：** 本课程将为您提供对 Excel 数据透视表和数据透视图的深入、全面理解。课程将详细讲解如何以及为何使用数据透视表，介绍高级排序、筛选和计算工具，并通过互动式实践演示和练习，引导您一步步掌握这些功能。 课程旨在帮助您熟练掌握 Excel 中许多高效且节省时间的公式和功能。通过本课程的学习和练习，您将能够更高效地解决工作中的各项 Excel 任务。 **课程内容将涵盖：** * Excel 中原始数据的结构 * 数据透视表的布局和样式 * 设计和格式化选项 * 排序、筛选、计算字段、计算项和计算值 * 数据透视图、切片器和图表 **学习目标：** 完成本课程后，您将能够熟练掌握 Excel 中最常用的工具，并自信、高效、优雅地完成任何 Excel 相关任务。您将掌握的关键技能包括： * 创建高效的电子表格 * 管理大型数据集 * 熟练运用 Excel 中最受欢迎且需求度高的函数（如 SUM, VLOOKUP, IF, AVERAGE）
This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way.There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don't use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.__________We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:Raw data structure in ExcelPivot Table layouts & stylesDesign & formatting optionsSorting, filtering, Calculated fields, items & valuesPivot Charts, slicers & ChartAt the completion of this course, you will have mastered the most popular Excel tools and come out with the confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:Creating effective spreadsheetsManaging large sets of dataMastering the use of some of Excel's most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE)
