Course Information
Schedules
- 30 Oct 2024 (Wed) 9:30 AM - 5:00 PM
- 19 Nov 2024 (Tue) 9:30 AM - 5:00 PM
Registration period
16 Aug 2024 (Fri) - 19 Nov 2024 (Tue)
Price
HKD 1,100
Course Level
Study Mode
Duration
6 Hour(s)
Language
Cantonese
Location
Mongkok
8 views
Course Overview
樞紐分析表是 Microsoft Excel 中更高階、更複雜的功能之一，但許多人都注意到使用它來生成分析和數據摘要的好處。
Pivot Table is one of the more advanced and complicated features of Microsoft Excel, but many oversee the benefits of using it to generate analysis and data summaries.
參加者有基本的 Excel 操作經驗。
What You’ll Learn
課程主題包括：
創建樞紐分析表
自定義樞紐分析表中的字段
格式化樞紐分析表報告
使用樞紐分析表進行總結和展示
創建和使用樞紐分析圖
為樞紐分析表使用外部數據
利用 OLAP 多維數據集的強大功能
Course topics include:
Creating a Pivot Table
Customizing fields in a Pivot Table
Formatting Pivot Table report
Using Pivot Tables for summary and presentation
Creating and using Pivot Charts
Using external data sources for a Pivot Table
Leveraging the power of OLAP Cubes
樞紐分析表可用於以多種方式查看、匯總和分析信息，讓您深入了解數據。本課程中，您將學習樞紐分析表的工作原理以及有效使用這些工具的技能和技巧。
Pivot Table can be used for viewing, summarizing and analyzing the information in multiples ways to give you an insight into the data. In this course you will learn how a Pivot Table works and the skills and techniques to use the tools effectively.
