Computer Academy

DATA ANALYSIS USING EXCEL AND ACCESS

Enquire Now

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
2 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

 



Start FollowingSee all

Learning Insight

  • 【中學文憑試】2018年DSE狀元曾陷情緒困擾 靠貓貓重生轉讀獸醫
  • 【職涯規劃】兩名校DSE尖子棄「神科」 唔讀醫科居然選讀…
  • 【自我增值】安老院保健員長期缺人 起薪點高達$18,350 仲有免費課程助入行

Jobs related to this course

  • Business Technology Analyst ( Open Platform )

    Bank of China (Hong Kong) Limited
  • Senior Finance Analyst/Assistant Finance Manager/Finance Manager (Business Analysis) (1-year Contract)

    DFI Retail Group
  • Data Centre Supervisor (Overnight shift is required)

    Automated Systems (HK) Ltd
EXCEL DASHBOARDS AND REPORTS ADVANCED EXCEL COURSE

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed