Certificate for Microsoft Excel in Business - Feva Works IT Education Centre

Certificate for Microsoft Excel in Business CEFEXCEL
課程介紹










Microsoft Excel 是一個萬用的應用程式,它能將資料記錄下來,例如:客戶資料、學生資料、學生成績或是貨物數量資料等等;它又能用作編制財務預算,貸款計算表;又或是製作報價表及發票等;甚至用作資料數據分析,圖表製作等等,功能之多,實在不能一一盡錄。

由於 Excel 的應用非常普及,所以坊間亦有超過 1,000 個不同款式的 Excel 課程提供。

為令你有最正統,最全面的 Microsoft Excel 知識,Feva Works 特別開設 Certificate for Microsoft Excel in Business。

課程設計由淺入深,適合所有對 Microsoft Excel 應用有需要的人士報讀。

 

免費課程首堂試讀體驗,立即報名 






FevaWorks 為香港微軟認可培訓方案合作伙伴

若想更了解以上資訊,歡迎致電 3106 8211 查詢。
課程內容
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
     

 

課程時數及費用

合共: 30小時

課程費用: $6000

繳費方法及退款安排

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

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

請按此查閱付款方法

退款安排: 本中心備有完善之退款政策及程序。學生將會於報讀課程前獲發有關之文件,學員亦可按此閱讀。

質素保證及卓越成就

本中心備有完善之免費補堂,免費重讀及彈性上課安排 (攝影課程除外),令學員更有保障。

本中心榮獲各大國際機構 (Adobe, Autodesk, Microsoft, H3C, Lenovo, Corel, Prometric, VUE, Certiport, Wacom 等等) 邀請成為香港區指定的認可教育中心及連續15+ 年榮獲香港社會服務聯會嘉許為「商界展關懷」公司,以表揚 Feva Works 對社會的貢獻。

除此之外,Feva Works 更連續 10 年獲 Microsoft 頒發全港最佳 Microsoft 授權培訓中心 (Best Microsoft Certified Partner for Learning Solutions of the Year) 及被 Adobe 選定為 Adobe CS4 & CS5 & CS6 & Creative Cloud 指定認可培訓中心。最近,Feva Works 更連續 10 年獲e-zone 電腦雜誌頒發最佳IT培訓中心。

自訂課程
本中心歡迎各公司、機構或團體包團報讀課程,安排公司活動或同事培訓。想進一步查詢詳情,可致電熱線 3748 9826。
課程時間表
 
CEFEXCEL2306001A 
日期 2023/06/06 - 2023/08/15
時間 19:00-22:00 (TUE)
合共 30小時
地點 北角分校
費用 $ 6000


 
CEFEXCEL23070022 
日期 2023/07/10 - 2023/09/18
時間 19:00-22:00 (MON)
合共 30小時
地點 長沙灣分校
費用 $ 6000


 
CEFEXCEL23070012 
日期 2023/07/15 - 2023/09/23
時間 14:30-17:30 (SAT)
合共 30小時
地點 長沙灣分校
費用 $ 6000


 
CEFEXCEL23070031 
日期 2023/07/16 - 2023/08/20
時間 10:30-17:30 (SUN)
合共 30小時
地點 長沙灣分校
費用 $ 6000


 
CEFEXCEL23080012 
日期 2023/08/19 - 2023/11/04
時間 10:30-13:30 (SAT)
合共 30小時
地點 長沙灣分校
費用 $ 6000