|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/working-with-excel-pivot-tables/
课程评论：没有评论
【课程名称】Excel透视表实操 【课程概述】 本课程旨在帮助学员从Excel透视表的入门基础，进阶到熟练掌握，全面了解这一强大的Excel工具，轻松地汇总和总结Excel数据库数据。我们将通过引人入胜且高效的学习体验，让您轻松掌握。 Excel透视表曾被视为Excel的附加功能，但如今情况已截然不同。近年来，Excel透视表环境得到了极大的增强，其带来的效率提升使其成为数据分析专业技能不可或缺的一部分。因此，它已成为当今市场上需求最旺盛的技能之一。 本课程的一大特色是高度关注透视表的数据输入（Excel数据库）。只有提供结构良好的数据，才能充分发挥透视表的作用，在几秒钟内生成汇总和总结的数据表格，只需点击一下鼠标。 【课程主要内容】 * Excel数据库：理解行列式表格的区别 * 透视表的主要功能 * 如何在几秒钟内聚合、汇总和筛选复杂的Excel数据库，并生成专业报告 * 基础Excel/透视表仪表板制作 * 计算字段的使用
Starting from the basis of Excel Pivot environment up to a good intermediate level, this is the main target of this course, where you learn all what you need to use the most powerful Microsoft Excel tool to easly aggregate and summarize your Excel Database Data. And you will achieve that through a learning experience very compelling and efficient learning experience. Guaranteed.Excel Pivot skills was considered something like an extra-chapter vs. standard Excel for a long time.Today the scenario is absolutely different. In the last years Excel Pivot environment was very much enhanced and thank to the drastic acceleration which this flow is able to produce, this methodology is to be considered absolutely an integral portion of your Data Analysis expertise. This is the reason why it is considered as one of the most required skill in today marketplace.There is a very important topic which characterizes this course: high focus on Pivot data input (Excel Databases), because only if we provide properly "structured" set of data we can get back the most by this Excel tool which will provide aggregated ans summarized table of data in seconds, at the click of a mouse.Summary of main course topics:Excel Database, understanding the difference between Horizontal and Vertical TablesPivot Table main featuresHow to aggregate, summarize and filter complex Excel Database and achieve professional reports IN SECONDSThe basis Excel/Pivot DashboardingUnderstanding Calculated Fields
