Sara Beattie College

Microsoft Excel - Pivot Tables 會計及財務 / 電腦, 資訊科技及設計

Enquire Now

Course Information

  • 15 Dec 2021 (Wed) - 4 Feb 2022 (Fri) 12:00 PM
  • 12 Jan 2022 (Wed) - 4 Mar 2022 (Fri) 12:00 PM
Registration period
3 Sep 2021 (Fri) - 5 Feb 2022 (Sat)
HKD 2,500
($300 Cash rebate upon successful completion)
Course Level
Study Mode
6 Week(s)

Course Overview

Microsoft Excel - Pivot Tables 會計及財務 / 電腦, 資訊科技及設計

Wouldn't it be great to learn how to effectively use all the advanced Excel pivot table features? In this practical hands-on and information-packed course, you will learn how to maximize this program's functions and capabilities using different layout, subtotaling, and filtering options and a variety of advanced techniques for pivot tables, including Pivot Charts, Timelines, and Slicers. You will also master data analysis by learning how to quickly and easily summarize your data
This course will teach you how to utilize the numerous pivot tables to develop useful analysis models and reports within your company. Impress your coworkers by learning how to create functional and eye-catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers. You will discover advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items. You will learn how to use Excel's Table function to efficiently manage changes to the pivot table's source data in order to avoid making mistakes when data is added or deleted.

Most organizations rely heavily on Microsoft Excel pivot tables to analyze and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization.

What You’ll Learn

• Pivot Table Concepts
• Creating a Pivot Table
• Pivot Table Analyze and Design Tabs
• Pivot Table Formatting Inside and Out
• Pivot Table Options and Field Settings
• Value Field Settings
• Grouping Pivot Table Fields
• Data-Integrity Checks and Report Filters
• Cloning a Pivot Table and the Wonderful World of Slicers
• Calculated Fields and Items
• Working With Slicers and Pivot Charts
• Timelines and Dashboard Development

Skills covered in this course

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