|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dominate-microsoft-excel-pivot-tables-for-data-analysis/
课程评论：没有评论
**课程名称：** Master Microsoft Excel 2023 Pivot Tables for Data Analysis **课程概述：** 本课程旨在帮助学员掌握Microsoft Excel 2023中的数据透视表功能，以高效地分析组织活动数据，发现趋势、优势、劣势等，从而更好地了解业务状况。课程由一位拥有超过25年Excel培训和商业管理经验的导师授课，内容丰富且实用，旨在帮助学员快速、顺畅、全面地掌握数据透视表的核心知识。 **课程内容亮点：** * **表格基础：** 学习表格的概念、优势、创建、去重，以及表格的自动化设置和结构化引用。 * **数据过滤：** 掌握文本、数字和日期过滤的多种方法，高效筛选数据。 * **数据透视表创建与重配置：** 学习数据透视表的创建、筛选字段、重配置布局、样式以及总计的设置。 * **字段设置与计算：** 深入理解值字段和项字段的设置，学习创建计算字段和计算项，进行更复杂的分析。 * **数据分组：** 掌握日期分组、通用分组和列分组，对数据进行多维度统计。 * **特殊过滤器：** 学习使用切片器（Slicer）和时间线（Timeline）过滤器，实现交互式数据筛选。 * **数据透视图：** 学习创建和编辑数据透视图，将数据分析结果可视化。 * **Power Pivot：** * **安装与基础：** 学习Power Pivot的安装，以及数据库和关系数据库的基本概念。 * **数据模型：** 将列表定义为表，并学习创建数据模型、添加表到模型以及建立表间关系。 * **数据模型中的数据透视表：** 基于数据模型创建数据透视表。 * **Power Pivot计算字段：** 学习创建和使用Power Pivot中的计算字段。 * **KPIs（关键绩效指标）：** 学习KPIs的概念、创建KPI指标，并在数据透视表中应用KPIs。 **适合人群：** 任何需要分析数据以做出明智商业决策的经理人士，以及希望快速、深入学习Excel数据透视表功能的学员。
All organizations need to analyze data on their activity to find out trends, strengths, weaknesses, and other aspects to understand the waters they sail on, and Pivot Tables is an excellent tool for this purpose. A must to learn for any manager.If your aim is to learn quickly, smoothly, and thoroughly Pivot Tables, going directly to the point, you have come to the right place.Based on more than 25 years of experience as an Excel trainer and business manager, this course reflects this wide and versatile knowledge, delivered to you in a tray with juicy content.You'll acquire proficiency in Excel Pivot Tables by dominating matters such as notions about tables and the advantages of their formal definition, creation, and reconfiguration of Pivot Tables, diverse types of filtering data, defining calculated fields and items, grouping data and subtotals, Pivot Charts and Power Pivot, amongst others.Course content:Tables: - Notions and ConceptsIntroduction to TablesDefining as Formal TableRemoving DuplicatesBasic Features of a Formal TableAutomation SettingsStructured ReferencingTables: Filtering DataFiltering Data - IntroductionText FiltersNumber FiltersDate FiltersPivot Tables - Creation and ReconfigurationIntroduction to Pivot TablesCreating a Pivot TableFilter FieldReconfiguring a Pivot TableTotals and Grand TotalsLayout and StylesPivot Tables - Fields Settings and CalculationsValues Fields SettingsItem Fields SettingsCreating Calculated FieldsCreating Calculated ItemsPivot Tables - GroupingDate GroupingGeneral GroupingColumns GroupingPivot Tables - Special FiltersSlicer FilterTimeline FilterPivot ChartsInserting a Pivot ChartGeneral Tasks with Pivot ChartsPower Pivot - Installation and IntroductionPower Pivot - Add-In InstallationPower Pivot - Database Notions - IntroductionPower Pivot - Database Notions - Relational DatabasePower Pivot - Definining Lists as TablesPower Pivot - Data Model and Pivot TablesAdding Tables to the Data ModelCreating RelationshipsCreating a Pivot Table of a Data ModelPower Pivot - Calculated FieldsCalculated Fields - IntroductionCreating Calculated FieldsCalculated Fields - Using in Pivot TablePower Pivot - KPIs - Key Performance IndicatorsKey Performance Indicators - IntroductionCreating KPIs MetricsApplying KPIs in a Pivot Table
