EX001 -
Basic Excel Training
Course Outline (no-coding approach):
​
-
Flash Fill
-
Calendar Functions
-
Pivot Table
-
Conditional Formatting as Growth Indicator
-
Absolute and Relative Cell Addressing
-
Excel Table
-
Validation List
-
XLookup Function
-
Sorting, Filtering and Unique List for Data Validation
-
Data Automation
Course Description
Course Objectives:
The "Basic Excel Training" course is tailored for users with some familiarity with Excel seeking to expand their skill set. Participants will explore new and less-known Excel features to streamline workflows and enhance productivity. Key objectives include mastering useful tools and functions, improving data visualization techniques, optimizing data analysis methods, and increasing efficiency through automation. By the end of the course, participants will possess a comprehensive understanding of essential Excel functionalities, empowering them to tackle complex data tasks with confidence and efficiency.
​
Target Audience:
-
This curriculum is designed for beginners seeking to enhance their Excel proficiency and productivity.
-
Beginners who are interested in learning powerful Excel techniques for data management and analysis
Advancement:
Participants who have completed this fundamental course can enhance their data analytic knowledge and skills by enrolling in EA101 - Basic Excel AI and Basic Data Automation and EA102 - Advanced Excel AI and Report Automation.
Features
-
This course covers some new Excel features (useful and easy-to-use, but less known) that even experienced users may not have be aware of.
-
Those who are interested in learning new and powerful Excel functionality are also welcome.
Medium of Instruction
Cantonese, supplemented with English
Pre-requisite
-
General computer operating skills
-
No coding skills required
Date, Time & Duration
Date:
-
TBC
Time: TBC
Duration: 7 hours (to be delivered in one or two 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)
Required Software
-
Microsoft 365 Excel (on Windows 10/11)
-
Remark: As the training materials are to be delivered in English (text), the menu ribbon of Excel in your computer is advised to be set in English. That is, the screen text captured on the training materials is in English. If your computer displays Excel menu in Chinese characters, please adjust the appropriate regional language setting in Windows prior to the training lesson(s).
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.
