Course Information
Schedules
- 2 Apr 2025 (Wed) 9:30 AM - 5:00 PM
- 7 May 2025 (Wed) 9:30 AM - 5:00 PM
- 20 Jun 2025 (Fri) 9:30 AM - 5:00 PM
Registration period
8 Nov 2024 (Fri) - 19 Jun 2025 (Thu)
Price
HKD 1,100
Course Level
Study Mode
Duration
6 Hour(s)
Language
Cantonese
Location
Mong Kok
22 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.
Start FollowingSee all
Courses that Might Interest You
- Certificate In Search Engine Optimization Form.Welkin
- Microsoft Office 綜合應用證書 (資歷架構第 3 級 及 CEF 資助課程) Excel Pro Education
- BUSINESS INTELLIGENCE WITH POWER BI DESKTOP Computer Academy
【2024更新│行政人員│自我增值】Admin工作內容是？月薪有幾多？行政人員職責、發展前景、薪酬及建議進修課程一覽！
【2024更新│行政助理│自我增值】Admin等於公司打雜？即睇行政助理職責、工作要求及晉升階梯
【自我增值】做老闆背後的靈魂人物？有課程幫你晉升至公司秘書管治行列
