Computer Academy

ADVANCED EXCEL COURSE

Enquire Now

Course Information

Schedules
  • 15 May 2025 (Thu) 10:00 AM - 5:00 PM
  • 15 May 2025 (Thu) - 22 May 2025 (Thu) 7:00 PM - 10:00 PM
  • 30 May 2025 (Fri) 10:00 AM - 5:00 PM
Registration period
5 Mar 2025 (Wed) - 20 May 2025 (Tue)
Price
HKD 1,480
(Enrolling this course on or before 30th November can receive early bird discount of $200)
Course Level
Study Mode
Duration
2 Day(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
4 views

Course Overview

The advanced Excel training course targets intermediate Excel users they want to use Excel to analyze , calculate , manage data and prepare management reports.

The course covers a wide range of spreadsheet features including advanced search, consolidating multiple worksheets, database functions, lookup functions, what-if analysis, scenario analysis and data protection. With all these features, students can streamline the repetitive workflow and save a lot of time in their work.

The course is supplemented with lots of real world examples and the adoption of small class size teaching approach can further enhance the overall learning experience of our students.

 

What You’ll Learn


  • Naming cells and ranges
  • Database
  • Advanced data sorting and subtotal
  • Using database functions
  • Managing documents with workbooks
  • Consolidation with several worksheets
  • Data table
  • Lookup table
  • Document protection
  • File linking
  • Filter and advanced filter
  • Building A Pivottable
  • Manipulating Your Pivottable
  • Conditional format
  • Data validation
  • What-If Analysis
  • Inserting a hyperlink to a workbook
  • Creating and using Macros

 



Start FollowingSee all

Learning Insight

Jobs related to this course

  • Project Manager / Business Analyst 項目經理 / 業務分析師〔編號:CA/IT/PMBA/20250214-4〕

    Hong Kong Sheng Kung Hui Welfare Council Limited 香港聖公會福利協會有限公司
  • Assistant Business Analyst (Ref: SSO/IT/ABA/CT)

    Haven of Hope Christian Service 基督教靈實協會
  • Business Data Analyst - Supply Chain (eCommerce)

    AS Watson Retail (HK) Limited
  • Business Analyst - CRM System

    AS Watson Retail (HK) Limited
  • Manager - Commercial Insight & Analysis

    AS Watson Retail (HK) Limited
DATA ANALYSIS USING EXCEL AND ACCESS EXCEL TRAINING 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