|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/pivottablesbyinstaexcel/
课程评论：没有评论
**课程标题:** 2小时学会Excel数据透视表 (Learn Excel Pivot Tables in 2 Hours with Dr. John Miko) **课程概述:** 本课程由Dr. John Miko教授，旨在帮助学习者在不足2小时的时间内，通过19个章节的教学，快速掌握Excel数据透视表这一强大的数据分析工具。数据透视表能够帮助用户从海量数据中快速提取有价值的洞察。尽管数据透视表常被认为是Excel的高级功能，但本课程通过系统地讲解其各项功能，使其变得不再难以理解。 **课程主要内容:** * **第一部分：引言与欢迎** * **第二部分：Excel数据透视表基础与创建第一个数据透视表** * **第三部分：整体表格设计** * **第四部分：字段设置与描述性度量** * **第五部分：排序、筛选与刷新** * **第六部分：项目分组、日期字段与计算字段** * **第七部分：数据透视图与仪表板构建** 本课程将全面介绍Excel数据透视表最实用和最强大的功能，让学习者能够高效地进行数据分析。
Excel Pivot Tables are an incredibly powerful feature of Excel that allows users to glean insights and understanding quickly from massive data files. While Pivot Tables are often thought of as an advanced feature of Excel because of the "Wow Factor", they are really not that difficult at all when broken down into their features and functions as done in this course. In 19 lectures, in under 2 hours, this course steps student through the most useful and powerful aspects of Excel Pivot Tables.Course SectionsSection 1: INTRODUCTION AND WELCOME TO THE COURSESection 2: EXCEL PIVOT TABLE BASICS and MAKING YOUR FIRST PIVOT TABLESection 3: OVERALL TABLE DESIGNSection 4: FIELD SETTINGS AND DESCRIPTIVE MEASURESSection 5: SORTING, FILTERING, AND REFRESHINGSection 6: GROUPING ITEMS, DATE FIELDS, AND CALCULATED FIELDSSection 7: PIVOT CHARTS AND BUILDING A DASHBOARD
