精選 Microsoft Office 課程

Certificate in Excel Advance

課程編號: CEA1001

完成課程後您能學會

所有學員完成課程後將能夠熟練地操作Excel 製作出樞紐分析表, 樞紐分析表圖表 (Pivot Table, Pivot Charts), 更加深入地運用邏輯函數,同時使用多個If 函數,完成大量檢查數據的工作。Eg. If + Iserror + Vlookup組合

Excel Advance2 Excel Advance3

Certificate in Excel Advance 商務課程簡介

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

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

 

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

課程時數:   每堂 小時

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

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

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

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

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

上課地點:銅鑼灣

      立即報名:按此報名

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


      課程內容:

      Introduction to Pivot Table
      tick What is Pivot Table
      tick Insert a Pivot Table
      tick Prepare Data for pivot table
      tick Setting Filter, Columns, Rows and Values
      tick Using Value field settings to summarize values
      tick Insert a Pivot table in a worksheet
      tick Rearrange data fields for Pivot Table
      tick Apply business data management
      tick Apply business analysis with formulas
      tick How to refresh with data updates
      tick How to accommodate with new data
      tick Table layout setting
      tick Pivot table reporting settings
      tick New version vs Old version
      tick Pivot table design
      tick How to use 2016 Recommended Pivot Table
      tick Adding blank line between fields
      tick Look for a data solution

      Insert Charts for Pivot Tables
      tick How to insert charts for Pivot Tables
      tick Using Recommended charts for Pivot Tables
      tick Controlling pivot chart by pivot table fields
      tick How to manipulate pivot charts
      tick Setting graphic designs for pivot charts
      tick Adding and removing field head from pivot charts
      tick Insert Bar Chart
      tick Insert Pie Chart
      tick Insert Line Chart
      tick Insert Area Chart
      tick Apply trend analysis to pivot charts
      tick Apply linear forecast to pivot charts
      tick Moving the pivot charts to PowerPoint and Word
      tick Pivot Chart reporting 

      Common Skills and Tricks
      tick Link Tables
      tick Link Tables for same files, cross files, new documents and websites
      tick Link Table file path caution
      tick Advance logical test and functions
      tick Applying IF AND OR function for business senarios
      tick Applying Mixture of IF AND OR functions
      tick Understanding the Logical functions
      tick Strategic approach to Multiple complex IF functions
      tick Application of complex mixtures
      tick ISERROR function
      tick Rand function
      tick Randbetween function
      tick International Excel data checking approach
      tick Data validation with data in sequence
      tick Data validation with data calculations
      tick Cross data validation approach with VLOOKUP
      tick Cross data validation approach with IF ISERROR VLOOKUP
      tick Import data from a website
      tick Import financial, retail and other data from databases
      tick Import financial, retail and other data from ACCESS
      tick Advance data checking
      tick Special Paste – Paste with same column width
      tick Special Paste – Paste with Values only
      tick Special Paste – Paste with Transpose of data
      tick Special Paste – Paste with Linked tables
      tick Special Paste – Paste with Pictures and Linked Pictures 

      Data clearing and management
      tick Applying Trace Precedents
      tick Applying Trace Dependents
      tick Applying Trace to investigate data calculations
      tick How to Remove Trace Arrows
      tick Using Show All formula
      tick Using Evaluation to debug complex Excel Formulas
      tick Data checking approach with Evaluation
      tick Using Group to manage large data
      tick Applying Ungroup to grouped data
      tick Applying Filter with advance scenarios
      tick Using Remove Duplicate to delete repeated data
      tick Using Remove Duplicate to simulate a Pivot Table
      tick Advance analysis by using Remove Duplicate
      tick Applying Text to Column to handle exported data
      tick Handling system data from CSV, TEXT and Excel files
      tick Rearrange data by using Sort by Alphabets, Values and Icons

      Excel Advance course topics

      Excel Advance2

      Excel Advance3