Workshop on Intermediate Excel of AI Function and Data Automation

Workshop on Intermediate Excel of AI Function and Data Automation

Overview

A large percentage of business users are preparing regular reports for operation or management. The processes repeat indefinitely and are mainly manual ones. People who are thinking about automation may have no idea of how to automate data preparation and reporting. People tend to relate automation with programming, but few people know that Excel can actually enable automation with the following features:

  • No VBA programming/macro recording is required
  • No need to use any Excel formula function such as VLOOKUP or SUMIFS
  • No need to copy and paste data
  • No add-in Software is required to install
  • Only pure Excel is required. No need to invest hugely in Robotics Process Automation (RPA) software

Objectives

Upon completion of this workshop, participants are expected to:

  • Get data and reports automated with less-known Excel techniques
  • Get hands on practice on data cleansing, data transformation, file consolidation with automation using popular business use cases
  • Learn advanced pivot table techniques for quick management reporting
  • Learn AI functions of Excel which can be 1000+ times faster than a manual process

Jan 16
鮮為人知的Excel AI功能 - 如何令你的工作效率提升一百倍?
Time:
19:00 - 20:00

Add to Calendar:


Early Bird Discount

Deadline for Discount:

Information at a Glance

Code:

TS-06737-2023-1-P

Commencement Date:

Tuition fee for Members:

HKD$2,800

Tuition fee for Non-members:

HKD$3,000

Medium of Instruction:

Cantonese

Mode of Instruction:

Face-to-face

Due to current COVID-19 situation, the mode of instruction might be changed from face-to-face to online teaching if necessary in the event that face-to-face classes cannot be held. The Association will contact the students concerned with details of such arrangements as necessary.

Brochure

Enquiry

Course Details

Mr Nick Lo
Phone: 3958 4803
Email: nicklo@hkma.org.hk

General Enquiry / Course Enrolment / Membership Information

Phone: 2774 8500 or 2774 8501
Email: hkma@hkma.org.hk
Fax: 2365 1000

Payment Methods