Event Information
Event code CMAI19091803 Closed Language English
Event name Advanced Excel: Practical Applications for Accounting Professionals
Enrolment restrictions Members only CPD hours 5.00
Competency Information Technology Sub-Competency Data management and analysis
Contact 2287 7435
Description

Enrolment

Author

Jeff Lenning, CPA, CITP

Overview

Written by a CPA and Excel expert, this course will help you be more efficient and productive. This course covers topics including Advanced PivotTables, External data ranges (ODBC), and Visual basic: macros and user-defined functions.

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

Topic discussed

  • Advanced pivot tables
  • External data ranges (ODBC)
  • VIsual basic: macros and user defined functions
  • Digital working papers
  • Securing worksheets and workbooks
  • Named ranges
  • Vlookup and related functions such as, Nest offset, Text, and Match
  • IF function and other efficiency gains
  • Encryption and data validation

Learning Objectives

  • Automate recurring processes
  • Use the most powerful features of Excel
  • Know which features and functions should be used for various high-level tasks
Event Date
Date / Time CPD hours
11 Oct 2019 5.00
Fee Information
Type Fee (HKD)
Enrolment Member 1,115.00
Student 1,115.00
Full Hot and limited seat Promotion
Closed e-Learning Continuing Education Fund
  Choose Skin