課程資料
Certificate in Project Management and Data Analysis using Microsoft Excel
CEFEXCEL
 
若想更了解以上資訊,歡迎致電 3106 8211 查詢。
 
課程費用: $6000
若成功申請持續進修基金後:
 
$ 1200
課程已加入持續進修基金可獲發還款項課程名單內,符合申請資格的學員,可於完成課程後向持續進修基金辦事處申請發還 80% 課程費用,發還上限10,000港元。

繳費方法:

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

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

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

合共: 30小時

 


課程內容:
Certificate in Project Management and Data Analysis using Microsoft Excel
Module 1: Get started with Excel Tools 

Get started with Excel (3 hours)

> 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: Scope Management

Defining group of data (3 hours)

> 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: Time and Cost Management

Composing Formula using Excel Functions & Recording Macro (6 hours)

> 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 4: Quality Management

Visualizing Information (3 hours)

> 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

Validating Information (3 hours)

> 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: HR and Communications Management

Generating Reports with Pivot Tables (6 hours)

> 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: Integration Management

Designing Charts (3 hours)

> 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


Reading data by analytical tools (3 hours)

> 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


Module 7: Examination (1.5 hours)

Course Final Assessment
 

 

 
 
如有任何有關課程之查詢,歡迎致電 3106 8211 與我們的客戶關係主任聯絡。
 
CEFEXCEL22100021 
日期 23/10/2022~27/11/2022 (SUN)
時間 10:30~17:30 
合共 30 小時
上課地點 長沙灣分校
課程費用 $ 6000
減免後* $ 1200 

 
CEFEXCEL22100012 
日期 29/10/2022~7/1/2023 (SAT)
時間 14:30~17:30 
合共 30 小時
上課地點 長沙灣分校
課程費用 $ 6000
減免後* $ 1200 

 
CEFEXCEL2211002A 
日期 1/11/2022~31/1/2023 (TUE)
時間 19:00~22:00 
合共 30 小時
上課地點 北角分校
課程費用 $ 6000
減免後* $ 1200 

 
CEFEXCEL22110044 
日期 16/11/2022~21/12/2022 (WED)
時間 10:30~17:30 
合共 30 小時
上課地點 長沙灣分校
課程費用 $ 6000
減免後* $ 1200 

 
CEFEXCEL22110031 
日期 23/11/2022~8/2/2023 (WED)
時間 19:00~22:00 
合共 30 小時
上課地點 長沙灣分校
課程費用 $ 6000
減免後* $ 1200 

 
CEFEXCEL22110012 
日期 26/11/2022~4/2/2023 (SAT)
時間 10:30~13:30 
合共 30 小時
上課地點 長沙灣分校
課程費用 $ 6000
減免後* $ 1200 


*學員須成功申請
持續進修基金