Course Information
- 15 Apr 2025 (Tue) - 22 Apr 2025 (Tue) 7:00 PM - 10:00 PM
- 10 May 2025 (Sat) - 17 May 2025 (Sat) 10:00 AM - 1:00 PM
- 21 May 2025 (Wed) 10:00 AM - 5:00 PM
- 19 Jun 2025 (Thu) 10:00 AM - 5:00 PM
Course Overview
Excel PivotTable is one of the most useful and powerful feature in Excel. Transforming your massive data into a report just requires only a few steps.
The Excel PivotTable course will teach you everything from start to finish, including preparing data suitable for Excel PivotTables, choosing the right PivotTable layout for presentation, protecting the data, using Excel formulas and functions in calculated fields or calculated items and consolidating data from different tables. The final result can be presented interactively using Excel PivotCharts.
Practical exercises are used throughout the class which allows students apply what have been learnt to analyse and generate reports, the adoption of small class size teaching approach can further enhance the overall learning experience of our students.
What You’ll Learn
- Understanding Pivottables
- Building A Pivottable
- Manipulating Your Pivottable
- Changing The Pivottable View
- Customizing Pivottable Fields
- Setting Pivottable Options
- Performing Pivottable Calculations
- Creating Custom Pivottable Calculations
- Creating A Pivotchart
- Disperate And External Data Sources
Skills covered in this course
Start FollowingSee all
Courses that Might Interest You
- DATA ANALYSIS USING EXCEL AND ACCESS Computer Academy
- Microsoft Office 綜合應用證書 (資歷架構第 3 級 及 CEF 資助課程) Excel Pro Education
- 創意數碼媒體設計及製作助理證書 (全日制) Hong Kong School of Commerce