課程資料
Master in Microsoft Excel 高級證書課程
2013MASTERXLS
 
若想更了解以上資訊,歡迎致電 3106 8211 查詢。
 
課程費用: $2490

 
課程費用無須申請任何政府基金資助。

繳費方法:

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

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

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

合共: 18小時

 


課程內容:
Module 1: Defining Groups of Data (3 hrs)
Select data using Define Name function
Creating Name using Name Manager
Explaining scopes of Excel Name
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
  - Some Dos and Don’ts in Tables & Name
  - Collaborating Tables & Name with Excel Functions Library
Class Exercise
Module 2: Visualizing Big Data (2 hrs)
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
Categorizing data using Conditional Formatting Rules
Visualizing data by Data Bar, Color Scales and Icon Sets
Customizing Conditional Formatting Rules
Creating Conditional Formatting Rules by Formula
Using Conditional Formatting as Business Indicators
Copy cells only with Conditional Formatting
Managing Conditional Formatting
Some Dos and Don'ts in Conditional Formatting
Case Studying of Conditional Formatting in business
Class Exercise
Module 3: Validating Big Data (2 hrs)
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 Formula
Understanding the role of reference in Data Validation
Copying Data Validation from one cell to another
Some Dos and Don'ts in Data Validation
Integrating Name and Table with Data Validation
Case Studying of Data Validation in business
Class Exercise
Module 4: Generating Reports with Pivot Tables (5 hrs)
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
Advanced Filtering by Excel operators
Grouping data by Data, Time or Values
Using Calculated Field for forecasting
Handling with Subtotals, Grand Totals in Pivot Table
Filtering data using Slicer
Changing Data Source in Pivot Table
Updating Data Source in Pivot Table
Building Pivot Chart
Some Dos and Don'ts in Pivot Table
Case Study in Pivot Table in business
Class Exercise
Module 5: Composing Formula using Excel Functions (6 hrs)
What is Excel Functions?
Basic Rules of using Excel Functions
Understanding the Excel Function Library
- (SUM / SUMIF / SUMIFS / AVERAGE / AVERAGEIF / MEDIAN / MODE…)
How Data and Time Functions help in Project Management
- (DAY / DAYS / DATE / TIME / EDATE / NETWORKDAYS / WORKDAYS etc)
Retrieving data by Lookup and Reference Functions
- (LOOKUP / VLOOKUP / HLOOKUP / MATCH / INDEX etc)
Controlling content by Text Functions
- (LEFT / RIGHT / MID / SEARCH / UPPER / LOWER...)
Automating formula using Logical function
- (IF / NOT / AND / OR / TRUE / FALSE…)
Integrating List, Name and Function Library for business solutions
Case Study in Excel Function for business
Class Exercise

 

 
 
如有任何有關課程之查詢,歡迎致電 3106 8211 與我們的客戶關係主任聯絡。
 
2013MASTERXLS17050032 
日期 6/5/2017~10/6/2017 (SAT)
時間 10:30~13:30 
合共 18 小時
上課地點 長沙灣分校
課程費用 $ 2490

 
2013MASTERXLS17050012 
日期 17/5/2017~21/6/2017 (WED)
時間 19:00~22:00 
合共 18 小時
上課地點 長沙灣分校
課程費用 $ 2490

 
2013MASTERXLS17050041 
日期 20/5/2017~24/6/2017 (SAT)
時間 14:30~17:30 
合共 18 小時
上課地點 長沙灣分校
課程費用 $ 2490

 
2013MASTERXLS1705001F 
日期 23/5/2017~4/7/2017 (TUE)
時間 19:00~22:00 
合共 18 小時
上課地點 灣仔分校
課程費用 $ 2490

 
2013MASTERXLS17060012 
日期 29/6/2017~3/8/2017 (THU)
時間 19:00~22:00 
合共 18 小時
上課地點 長沙灣分校
課程費用 $ 2490