|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/master-pivot-tables-introduction-and-masterclass/
课程评论：没有评论
《Microsoft Excel 精通系列：数据透视表入门与大师班》课程概述 本课程旨在帮助学习者掌握Microsoft Excel中一项非常实用但听起来可能令人生畏的功能——数据透视表。尽管听起来复杂，但实际上只需点击几下即可完成。课程将以极快的速度，在几分钟内完成第一个数据透视表及其图表的创建。 完成课程初期部分后，学习者将能显著超越对数据透视表一无所知的人，充分认识到其重要性。 随后，课程将深入探讨如何设置数据透视表，包括初始数据的准备以及可用选项的详解。课程还将介绍许多鲜为人知但非常有用的高级功能。 课程结束时，学习者将成为数据透视表的高级用户，能够创建可靠的、可快速钻取分析的数据报告，并有能力指导他人进行数据分析。 **免责声明：** 本课程未获得Microsoft的官方认可、支持或赞助。
Review:"The knowledge of the teacher is impressive, and he knows how to teach. The speed of the course is just right. And going thru the exercises after each one is great. I only have one word for the teacher and the way he's presenting the course WOW!!!" - Daniel SandbergThis course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time.After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important.After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful.By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis.
