CTgoodjobs - Mastering Excel Pivot Tables | Form.Welkin

Form.Welkin

Mastering Excel Pivot Tables

Enquire Now

Course Information

Schedules
  • 11 Feb 2025 (Tue) 9:30 AM - 5:00 PM
  • 5 Mar 2025 (Wed) 9:30 AM - 5:00 PM
Registration period
8 Nov 2024 (Fri) - 4 Mar 2025 (Tue)
Price
HKD 1,100
Course Level
Study Mode
Duration
6 Hour(s)
Language
Cantonese
Location
MongKok
52 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.


Skills covered in this course


Start FollowingSee all

Learning Insight

  • 【2024更新│行政人員│自我增值】Admin工作內容是?月薪有幾多?行政人員職責、發展前景、薪酬及建議進修課程一覽!
  • 【2024更新│行政助理│自我增值】Admin等於公司打雜?即睇行政助理職責、工作要求及晉升階梯
  • 【自我增值】Google X 青協培訓數碼人才 送1000名16至35歲人士助學金

Jobs related to this course

  • Technical Specialist

    Primetech Technology Limited
  • Senior Business Strategy Manager-GM

    Bank of China (Hong Kong) Limited
  • Operation Manager / Officer - Compliance (RMB Clearing, Payments Operation)

    Bank of China (Hong Kong) Limited
Using Excel Functions Effectively Microsoft Word for Advanced Users

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