Course Information
- 3 Dec 2024 (Tue) 9:30 AM - 5:00 PM
- 4 Feb 2025 (Tue) 9:30 AM - 5:00 PM
- 7 Apr 2025 (Mon) 9:30 AM - 5:00 PM
- 26 Jun 2025 (Thu) 9:30 AM - 5:00 PM
- 15 Aug 2025 (Fri) 9:30 AM - 5:00 PM
Course Overview
Power Pivot 是 Excel 的擴展,您可以使用它來執行更強大的數據分析並創建複雜的數據模型。它可以處理來自各種來源的大量數據,但仍然可以快速生成、分析相關數據。本課程包含從安裝 Power Pivot 的基礎知識到 Power Pivot 的高階應用。
Power Pivot is an extension to Excel whereyou 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