EA102 -
Advanced Excel AI and Report Automation
Course Outline (no-coding approach):
-
Data Transformation Techniques
-
Business Case - Consolidating Actual Sales, Budget Sales and Last Year Sales
-
Practical Excercise - Consolidating Actual Sales, Budget Sales and Last Year Sales
-
Advanced Pivot Table Techniques
-
Growth Indicators
Course Objective
Course Objectives:
Take your Excel skills to new heights with our advanced course in Excel AI and Report Automation, designed to empower you with professional skills without coding knowledge. This hands-on course provides a comprehensive exploration of Excel's advanced capabilities, enabling participants to harness AI functionalities and automate complex data and reports seamlessly.
Target Audience:
-
This course is designed for advanced users who have previously taken the course EA101 - Basic Excel AI and Basic Data Automation
-
Or any professionals who are seeking to enhance their proficiency and productivity with advanced AI functions within Excel, automate data efficiently using different reports, and automate routine tasks to save time and improve accuracy.
Features
1. No-coding approach
2. No formula function (i.e. VLOOKUP)
3. Pure Excel (No add-in software)
Medium of Instruction
Cantonese, supplemented with English
Pre-requisite
1. EA101 (Basic Excel AI and Report Automation)
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
Date, Time & Duration
Date: (Choose one of the following dates)
-
TBC
Time: TBC
Duration:
-
7 hours (1-Day) or
-
3.5 + 3.5 hours = 7 hours (2-Days)
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.