Event Information
Event code CMAI24112703 Language English
Event name Advanced Excel: Practical Applications for Accounting Professionals
CPD hours 6.50
Competency Information Technology Sub-Competency Data management and analysis
Level 3 - Advanced
Contact online@hkicpa.org.hk / 2287 7435
Description

​

Offline enrolment form

 

Overview

If you're comfortable using Excel, but want to take your skills to the next level, you've found the right course.

Written by a CPA and Excel expert, this self-study course will help you be more efficient and productive. This course covers topics including:

  • Advanced PivotTables
  • External data ranges (ODBC)
  • Visual basic: macros and user-defined functions.

Once you know how to tap the software's full potential, you'll be able to quickly and easily perform accounting and finance tasks in Excel.

Key topics

  • Advanced PivotTables
  • External data ranges (ODBC)
  • Visual basic: macros and user-defined functions
  • Digital workpapers
  • Securing worksheets and workbooks
  • Named ranges
  • VLOOKUP and related functions, Nest Offset, Text, Match
  • "IF" function and other efficiency gains
  • Encryption and data validation

Learning Objectives

  • Understand how to automate recurring processes.
  • Utilize the most powerful features of Excel.
  • Identify which features and functions should be used for various high-level tasks.

(This is a re-launch programme. No CPD hours will be granted if a member has previously enrolled for CMAI21022601 & CMAI23080122 Advanced Excel: Practical Applications for Accounting Professionals) 
Event Date
Date / Time CPD hours
27 Nov 2024 00:00 - 31 Dec 2099 23:59 6.50
Fee Information
Type Fee (HKD)
Enrolment IA 1,200.00
Member 1,200.00
Student 1,200.00
Non-member 1,450.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