Course Information
Schedules
- 8 Oct 2025 (Wed) 9:30 AM - 5:00 PM
- 3 Dec 2025 (Wed) 9:30 AM - 5:00 PM
Registration period
14 Oct 2024 (Mon) - 3 Dec 2025 (Wed)
Price
HKD 1,400
Course Level
Study Mode
Duration
6 Hour(s)
Language
Cantonese
Location
Mong Kok
2 views
Course Overview
Power Pivot 是 Excel 的擴展，您可以使用它來執行更強大的數據分析並創建複雜的數據模型。它可以處理來自各種來源的大量數據，但仍然可以快速生成、分析相關數據。本課程包含從安裝 Power Pivot 的基礎知識到 Power Pivot 的高階應用。
Power Pivot is an extension to Excel whereb you use it to perform more powerful data analysis and create sophisticated data models. It can go through large amounts of data from various sources but still produce nalysis quickly and share insights easily.
This course will go through from the basics of installing Power Pivot to more advanced topics of Power Pivot usage.
What You’ll Learn
課程涵蓋：
準備和安裝 Power Pivot在 Power Pivot 中管理數據創建和管理關係使用數據表視圖構建數據透視表數據透視表和 Power Pivot 的提示和技巧
The course covers:
Preparing and installing Power Pivot
Managing data in Power Pivot
Creating and managing relationships
Using data sheet view
Building Pivot Tables
Tips and tricks for Pivot Table and Power Pivot
