Course Information
Schedules
- 23 Jun 2025 (Mon) 10:00 AM - 5:00 PM
Registration period
5 Mar 2025 (Wed) - 26 May 2025 (Mon)
Price
HKD 1,980
Course Level
Study Mode
Duration
1 Day(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
3 views
Course Overview
Excel is highly favored by end users because of its rich set of features and ease of use. Access is a RDBMS (Relational Database Management System) with faster processing speed on massive data and better performance on managing multiple tables. It is also good for routine work as well. They can supplement to each other forming an ideal hybrid system for data analysts who are looking for speed and flexibility.
During the class, students can learn the advanced Excel techniques, such as data consolidation, advanced lookup and database functions. They will know how to import data into Access, and how to link up tables and to crunch data using Access’s queries. The result can then be exported back to Excel for the other processing such as plotting chart, creating pivot tables or constructing dashboards.
What You’ll Learn
- Data lookup in Excel
- Consolidation with multiple Excel worksheets
- Using Excel Database Functions
- Methods of sharing data between Excel and Access
- Setting Up Table with Existing Data
- Relational Database
- Analysing data using Access queries
Skills covered in this course
Start FollowingSee all
Courses that Might Interest You
- ACCESS TRAINING COURSE Computer Academy
- Microsoft Office 綜合應用證書 (資歷架構第 3 級 及 CEF 資助課程) Excel Pro Education
- SQL FOR DATA ANALYSIS Computer Academy
【自我增值】被譽為21世紀最性感職業？！數據分析師8個必備技能
【自我增值】IT創科行業職位逆市增長 自學進修有錢途！
【自我增值】想學好Microsoft Office？ 而家喺屋企都有得上堂！
