精選 Microsoft Office 課程

Master in Microsoft Excel

課程編號: MME2001

完成課程後您能學會

所有學員完成大師級Excel 18小時的商務課程後,將能夠熟練地操作Excel 製作出樞紐分析表, 樞紐分析表圖表 (Pivot Table, Pivot Charts),Evaluation, Data Validation, 更加深入地運用邏輯函數,同時使用多個If 函數,令你在職場變得更強大,更專業!

Excel Advance2 Excel Advance3

Master in Microsoft Excel 商務課程簡介

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

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

 

課程特色:適合高速及集中的你,快速學習全部技術,投入日常工作中提升效率 

課程時數:18 小時 

課程堂數:6 堂  每堂 3 小時

課程材料:筆記一份,練習檔案一份。

上課模式:一人一機,真人導師教授課程。

公司培訓:本課程適用於公司團體培訓, 詳情可與我們職員聯絡。

報名資格:課程適合任何人士報讀

報名方法:1)網上即時報名  2)  銀行入數報名

上課地點:銅鑼灣

    立即報名:按此報名

    證書認可 : 完成課程後可以申領證書一份


    課程內容:

    Standardizing Excel data
    tick Creating Data with Standard Format
    tick Using data with Define Name Function
    tick Calling the Name with Name Manager
    tick Excel Name as opposite to Object Name
    tick Doing Calculation in Table Cells
    tick Calling Cells in Table Ranges
    tick Advance Tabling and Formatting
    tick Using Advance Filtering with Conditional Formatting
    tick Applying Text to columns with CSV or TEXT files
    tick Using remove duplicate for data validation
    tick Class practice and Homework
     
    Pivot Table Reports
    tick Introduction to Pivot Table
    tick Reporting using Pivot Table in Office documents
    tick Creating Pivot Table Standard Data Format
    tick Pivot Table Data validation
    tick The 4 Major sections in using Pivot Table
    tick Managing Pivot Table Fields
    tick Error Handling with Pivot Table
    tick Understanding the Main group and Sub group of Data Structures
    tick Advance Filtering in Pivot Table
    tick Understanding the limitation of Pivot Table
    tick Grouping data by values, currencies and data values
    tick Applying 3 Major layout and reports in Pivot Table
    tick Refreshing and Updating original data in Pivot Table
    tick Major Business application case studies
    tick Class Practice and Homework
     
    Visualizing Excel Data Information
    tick Applying standard Format data for SubTotal
    tick Creating summarized reports with SubTotal
    tick Using Total to conditional adding data
    tick Generating conditional Total using SubTotal
    tick Structuring Data using Advance Formatting
    tick Applying visual effects with Conditional Formatting
    tick Advance application of Conditional Formatting Rules
    tick Reverse direction of Conditional Formatting
    tick Class Practice and Homework
     
    Advance Application of Excel Functions
    tick Introduction to Excel Functions and Library
    tick 3 Major ideas of Excel Functions
    tick Automation of Excel worksheet with functions
    tick Application of VLOOKUP and HLOOKUP combination
    tick Referencing data with VLOOLUP function
    tick Cross Worksheets VLOOKUP application
    tick Handling ID numbers and invoice numbers data
    tick Create Work Schedule using Date Time functions
    tick Using IF, AND, OR logical functions for automation
    tick Advance application of Nesting multiple functions
    tick Class Practice and Homework
     
    Managing Excel Data Information
    tick Applying standard Format with Data Validation
    tick Using Data Validation as work
    tick Learning Data Validation types and rules
    tick Duplicating Data Validation in worksheets
    tick Reference of Data Validation alerts
    tick Advance cell locking with Data Validation
    tick Create custom Data Validation rules with Formula
    tick Class Practice and Homework


    Excel Advance course topics

    Excel Advance2

    Excel Advance3