Event Information
Event code CMAI24112726 Language English
Event name Microsoft Power BI - Analyze Your Data with Excel Pivot Tables
CPD hours 4.00
Competency Information Technology Sub-Competency Data management and analysis
Level 1 - Foundation
Contact online@hkicpa.org.hk / 2287 7435
Description

 

 

Offline enrolment form

 

Overview

Improve your powers of analysis using a pivot table.
This course is the third in the Microsoft Power BI series and is designed to teach participants the importance of the PivotTable tool. This course demonstrates how to create pivot tables to make data analysis an easy task for all accountants. Participants will learn, step-by-step, the process for creating pivot tables and pivot charts for reporting. Set-up options will also be covered.

This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.

Key Topics

  • Pivot tables for data analysis
  • Pivot table creation
  • Pivot charts

Learning Objectives

  • Determine the advantages of using PivotTables to analyze data from multiple dimensions
  • Apply the step-by-step process to create PivotTables
  • Choose the PivotTable options that best fit your needs
  • Use Pivot Charts to present your data graphically for the most effective analysis

(This is a re-launch programme. No CPD hours will be granted if a member has previously enrolled for CMAI23080164 Microsoft Power BI - Analyze Your Data with Excel Pivot Tables) 
Event Date
Date / Time CPD hours
27 Nov 2024 00:00 - 31 Dec 2099 23:59 4.00
Fee Information
Type Fee (HKD)
Enrolment IA 900.00
Member 900.00
Student 900.00
Non-member 1,150.00
Enrolment Date
Enrolment from 27 Nov 2024 (00:00) to 31 Dec 2099 (23:59)
Full Hot and limited seat Promotion
Closed e-Learning Continuing Education Fund
  Choose Skin