Master in Microsoft Excel

Excel 高級商務課程，需要學員有一定的Excel相關經驗。我們的導師由樞紐分析表(Pivot Table)開始解釋如何使用Excel製作大量的報告 ，以及如何在日常工作中快速處理大量的數據，並且完成檢查的工作確保資料的準確性 (完成公司中的Do-check-review工作流程)。所有學員完成課程後將能夠熟練地操作Excel 製作出樞紐分析表, 樞紐分析表圖表 (Pivot Table, Pivot Charts), 更加深入地運用邏輯函數，同時使用多個If 函數，完成大量檢查數據的工作。例如: If + Iserror + Vlookup組合。

本課程融合了多年的實戰經驗，令各位學員能夠充分利用及了解MS Office各版本的特點。由1997年的紮實基礎到2016年版本的最新技術，都能夠靈活運用。

歡迎到本電腦中心的網上報名系統報讀以上課程，網站連結：https://www.ExcelProEdu.com.hk/

如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵到 info@ExcelPro.hk 與我們聯絡！

課程內容：

Standardizing Excel data

• Creating Data with Standard Format
• Using data with Define Name Function
• Calling the Name with Name Manager
• Excel Name as opposite to Object Name
• Doing Calculation in Table Cells
• Calling Cells in Table Ranges
• Advance Tabling and Formatting
• Using Advance Filtering with Conditional Formatting
• Applying Text to columns with CSV or TEXT files
• Using remove duplicate for data validation
• Class practice and Homework

Pivot Table Reports

• Introduction to Pivot Table
• Reporting using Pivot Table in Office documents
• Creating Pivot Table Standard Data Format
• Pivot Table Data validation
• The 4 Major sections in using Pivot Table
• Managing Pivot Table Fields
• Error Handling with Pivot Table
• Understanding the Main group and Sub group of Data Structures
• Advance Filtering in Pivot Table
• Understanding the limitation of Pivot Table
• Grouping data by values, currencies and data values
• Applying 3 Major layout and reports in Pivot Table
• Refreshing and Updating original data in Pivot Table
• Major Business application casestudies
• Class Practice and Homework

Visualizing Excel Data Information

• Applying standard Format data for SubTotal
• Creating summarized reports with SubTotal
• Using Total to conditional adding data
• Generating conditional Total using SubTotal
• Structuring Data using Advance Formatting
• Applying visual effects with Conditional Formatting
• Advance application of Conditional Formatting Rules
• Reverse direction of Conditional Formatting
• Class Practice and Homework

Advance Application of Excel Functions

• Introduction to Excel Functions and Library
• 3 Major ideas of Excel Functions
• Automation of Excel worksheet with functions
• Application of VLOOKUP and HLOOKUP combination
• Referencing data with VLOOLUP function
• Cross Worksheets VLOOKUP application
• Handling ID numbers and invoice numbers data
• Create Work Schedule using Date Time functions
• Using IF, AND, OR logical functions for automation
• Advance application of Nesting multiple functions
• Class Practice and Homework

Managing Excel Data Information

• Applying standard Format with Data Validation
• Using Data Validation as work
• Learning Data Validation types and rules
• Duplicating Data Validation in worksheets
• Reference of Data Validation alerts
• Advance cell locking with Data Validation
• Create custom Data Validation rules with Formula
• Class Practice and Homework

歡迎到本電腦中心的網上報名系統報讀以上課程，網站連結：https://www.ExcelProEdu.com.hk/

如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵到 info@ExcelPro.hk 與我們聯絡！