Form.Welkin

Mastering Excel Pivot Tables

Enquire Now

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
1 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

Learning Insight

  • 【2024更新│行政人員│自我增值】Admin工作內容是?月薪有幾多?行政人員職責、發展前景、薪酬及建議進修課程一覽!
  • 【2024更新│行政助理│自我增值】Admin等於公司打雜?即睇行政助理職責、工作要求及晉升階梯
  • 【自我增值】做老闆背後的靈魂人物?有課程幫你晉升至公司秘書管治行列

Jobs related to this course

  • Finance Officer

    Chi Heng Foundation Limited
  • Senior Clerk / Clerk (Hong Kong Island District)

    SINO PROPERTY SERVICES
  • Assistant Clubhouse Officer (Tsuen Wan District)

    SINO PROPERTY SERVICES
Using Excel Functions Effectively Chinese Input Method – Changjie

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