Course Information
Schedules
- 19 Dec 2024 (Thu) 9:30 AM - 5:00 PM
- 15 Jan 2025 (Wed) 9:30 AM - 5:00 PM
- 11 Feb 2025 (Tue) 9:30 AM - 5:00 PM
- 5 Mar 2025 (Wed) 9:30 AM - 5:00 PM
Registration period
8 Nov 2024 (Fri) - 4 Mar 2025 (Tue)
Price
HKD 1,100
Course Level
Study Mode
Duration
6 Hour(s)
Language
Cantonese
Location
MongKok
16 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.
