課程資料
CEF 認可 Certificate for Microsoft Excel in Business
CEFEXCEL
 
若想更了解以上資訊,歡迎致電 3106 8211 查詢。
 
課程費用: $6000

 
繳費方法:

一般課程:按月等額收取列明的課程費用。本中心將不早於課程開始的一個月前收取第一期費用。除第一期的費用外,每期的費用會在課程進行期間每月的首個上學日或之後收取。

組合課程:若該課程為組合課程,本中心將按該組合課程分科收費,直至所收學費為該組合課程的等額費用為止。

 
退款安排: 本中心備有完善之退款政策及程序。學生將會於報讀課程前獲發有關之文件,學員亦可按此閱讀。
 
質素保證: 本中心備有完善之免費補堂,免費重讀及彈性上課安排,令學員更有保障。
 
   
理論: 0小時 實習: 30小時 示範: 0小時

合共: 30小時

 


課程內容:
Certificate for Microsoft Excel in Business

Module 1: Get started with Excel Tools
  • Using Excel Template for quick tasks
  • Modify Templates for future use
  • Locating Data in cells
  • Identify and control cell formats
  • Sheets Pagination, Printing and Views
  • Sort data in multi-levels

 

Module 2: Defining group of data

  • Select data using Define Name function
  • Creating Name using Name Manager
  • Reusing Name by Excel Name Box
  • Formatting cells using Tables
  • Referencing cells in Tables
  • Calculating cells in Tables
  • Removing data duplication using Tables
  • Filtering data in Tables
  • Creating Excel Formula by naming a table
  • Summarizing data using Tables & Names
  • Collaborating Tables & Name with Excel Functions Library
  • Importing Data from different source
  • Linking Data from cell, sheets and files understanding the prerequisites of Subtotal
  • Using Subtotal to summarize data
  • Applying multi-level subtotal
  • Creating a Total row
  • Using outline to control Subtotal
  • Generating subtotal using SUBTOTAL()

 

Module 3: Visualizing Information

  • Creating Cell Styles
  • Using Customized Cell Style
  • Categorizing data using Conditional Formatting Rules
  • Visualizing data by Data Bar, Color Scales and Icon Sets
  • Customizing Conditional Formatting Rules
  • Writing formulas and cell references for Conditional Formatting
  • Building Conditional Filtering
  • Managing Conditional Formatting Rules

 

Module 4: Validating Information

  • Understanding the prerequisites of Data Validation
  • When and Where should we use Data Validation
  • Applying Data Validation rules
  • Adding cell tip
  • Controlling levels of Data Validation alerts
  • Understand the different of levels of Data Validation
  • Using Data Validation in business environment
  • Create custom Data Validation rules using Excel Formulas
  • Understanding the role of reference in Data Validation
  • Copying Data Validation from one cell to another
  • Integrating Name and Table with Data Validation


 

Module 5: Generating Reports with Pivot Tables

  • What is a Pivot Table?
  • Where and when to use Pivot Table?
  • Preparing data for Pivot Table
  • Top 3 Important guidelines for creating Pivot Table
  • Understanding Pivot Table Fields
  • Modifying layout and appearance of Pivot Table
  • Handing NULL and ERROR in Pivot Table
  • Filtering data in row and column
  • Grouping data by Data, Time or Values
  • Handling with Subtotals, Grand Totals in Pivot Table
  • Using Timeline on Pivot Tables
  • Using Slicer on Pivot Charts
  • Creating Calculated Fields
  • Changing Data Source in Pivot Table
  • Updating Data Source in Pivot Table
  • Case Study in Pivot Table in business

 

Module 6: Composing Formula using Excel Functions

  • What is Excel Function?
  • Rules of using Excel Functions
  • Tracking cell Dependents and Precedents
  • How Data and Time Functions help in Project Management
  • Retrieving data by Lookup and Reference Functions
  • Controlling content by Text Functions
  • Using IS function for Error Handling
  • Automating formula using Logical function
  • Integrating List, Name and Function Library
  • Creating Macro using Recorder
  • Modifying Macro by Developer tools

 

Module 7: Designing Charts

  • Understanding different types of Chart
  • Handling perquisites of Chart
  • Designing Column Chart, Bar Chart and Line Chart
  • Building Graphical Column Chart using imported images
  • Customizing Chart styles and layout
  • Configuring Chart bounding and scale
  • Designing Radar Chart, Combo Chart
  • Adding Shapes and Arrows on Chart
  • Saving Chart Templates
  • Reusing Chart Templates

 

Module 8: Reading data by analytical tools

  • Reading data from Freeze Pane, Split and Switching window
  • Using Goal-seek for cost estimation
  • Generating forecast report by Scenario Manager
  • Preforming quick calculation by Data Table
  • Managing Comments in cells
  • Tracking Data history
     
Assessment Methods


The overall contributions to the final results are 50% for Continuous Assessments and 50% for Final Assessment.

Certificate for Microsoft Excel in Business will be awarded to those who have:

 

  • Must be at least 50% or such higher passing mark for both Continuous Assessments and Final Assessment; AND
  • Attended at least 70% of the total contact hours.
     
Admission Requirements


Applicants should fulfil the following admission requirements:

 

  • Completion of F.5 (under the HKCEE academic structure) or equivalent; OR
  • Completion of Secondary 6 (under the HKDSE academic structure) or equivalent; OR
  • Aged 18 or above at the time when the course commenced, plus 2 years of work experience
     

 

 
 
如有任何有關課程之查詢,歡迎致電 3106 8211 與我們的客戶關係主任聯絡。
 
CEFEXCEL25010016 
日期 4/1/2025~15/3/2025 (SAT)
時間 10:30~13:30 
合共 30 小時
上課地點 長沙灣分校
課程費用 $ 6000

 
CEFEXCEL25010031 
日期 12/1/2025~16/2/2025 (SUN)
時間 10:30~17:30 
合共 30 小時
上課地點 長沙灣分校
課程費用 $ 6000

 
CEFEXCEL2501005A 
日期 15/1/2025~26/2/2025 (MON,WED)
時間 19:00~22:00 
合共 30 小時
上課地點 北角分校
課程費用 $ 6000

 
CEFEXCEL25010021 
日期 22/1/2025~9/4/2025 (WED)
時間 19:00~22:00 
合共 30 小時
上課地點 長沙灣分校
課程費用 $ 6000

 
CEFEXCEL25010041 
日期 27/1/2025~7/4/2025 (MON)
時間 19:00~22:00 
合共 30 小時
上課地點 長沙灣分校
課程費用 $ 6000

 
CEFEXCEL25020016 
日期 8/2/2025~26/4/2025 (SAT)
時間 14:30~17:30 
合共 30 小時
上課地點 長沙灣分校
課程費用 $ 6000