Form.Welkin

PowerPivot for Microsoft Excel

Enquire Now

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
Study Mode
Duration
6 Hour(s)
Language
Cantonese
Location
Mong Kok
4 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



Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed