EA101 -
Basic Excel AI and Basic Data Automation
Course Outline (no-coding approach):
1. Excel AI Functions
2. Excel Tables and Data Transformation
3. Quick Practice Session
4. Report Transformation
5. Data File Consolidation
(Consolidating 100 data sets in less than 15 seconds)
6. Management Report Automation
Course Description
Course Objectives:
Empower yourself with essential skills in Excel AI and data automation without the need for coding expertise. This course provides a practical, hands-on approach to leveraging Excel's powerful features to automate data processes, transform reports, and streamline workflows effectively.
Target Audience:
-
This curriculum is designed for beginners and intermediate users seeking to enhance their Excel proficiency and productivity.
-
Anyone who would like to learn more about the AI functions within Excel, manipulate data efficiently using tables and transformation tools, and automate routine tasks to save time and improve accuracy.
Advancement:
Participants who have completed this fundamental course can enhance their knowledge and skills by enrolling in EA102 - Advanced Excel AI and Report Automation.
Features
1. No-coding approach
2. No formula function (i.e. VLOOKUP)
3. Pre-requisite: requires basic Excel operation skills (3-month of experience)
4. Pure Excel (No add-in software)
Date, Time & Duration
Options: (Choose one of the following dates)
-
TBC
Time:
-
TBC
Duration:
-
7 hours (1-Day) or
-
3.5 + 3.5 hours = 7 hours (2-Days)
Medium of Instruction
Cantonese, supplemented with English
Pre-requisites
1. Basic Excel Operation Experience
(about 3 months)
2. No programming experience is required.
Required Software
-
Excel (Version 2016 or later, and Excel 365 is the best version) on Windows 10 or 11 (Excel on Mac is not compatible)
-
Excel menu ribbon in English
Mode of Instruction
Online: By Zoom (Zoom link will be provided upon successful enrolment)
Course Fee
Course Price: $2,200 HKD
Early Bird Discount: -$200 HKD per student
(7 days before the class starts)
Data Files & Course Materials
The organizer will provide an URL for downloading the required items before the course commences.
If you’d like more information about this course, get in touch today.
