精選 Microsoft Office 課程

Certificate in Big Data Analysis

課程編號CBDA2001

Certificate in Big Data Analysis 課程簡介

在每日的商業世界中,我們需要處理大量的數據以及各式各樣的資料分析。因此MS Office 扮演着重要的角色,協助我們加速完成每天的工作。

多年以來各大企業一直不斷地努力鼓勵員工學習及提升 MS Office 應用技能,進而縮短工作時間亦能夠提升工作效率。

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

 

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

課程時數:   每堂 小時

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

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

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

報名資格:建議先完成 Excel Beginning, Intermediate 及 Advance 課程 或 對函數應用有深入認識的人士

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

上課地點:銅鑼灣

    立即報名:按此報名

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

    課程證書

    課程內容:

    Introduction to Data Management, Cloud Data and  Databases
    tick What is data Management, cloud data and databases
    tick Where do we store the data?
    tick What are the businesses and large corporates approach to big data
    tick Why do we need a Server? What is the a local server, cloud server and web server
    tick Why not saving our data in Local drive?
    tick How to implement a Cloud server to home and business application?
    tick Three common Data Types for statistical analysis in business environment
    tick Handling Continuous Data
    tick Handling Categorical Data
    tick Handling Discrete Data
    tick Data Formats to handle the three data types
    tick Importing data from a Text file
    tick Importing data from a Word
    tick Importing data from a Excel
    tick Importing data from a CSV
    tick What is database?
    tick Introduction to Common databases
    tick SAS
    tick Oracle
    tick Access
    tick SAP
    tick Introduction to the relationship between Databases and Excel

    Statistical Functions and business analysis
    tick Average Function – Handling arithmetic mean
    tick Calculation of geometric mean for financial data
    tick STDEV.S Function – Handling data spreads
    tick Calculation of standard deviation without using the function
    tick Calculation of standard deviation without using the pivot table approach
    tick NORM.S.DIST Function – Applying standard normal distribution to business data
    tick Understand the pdf of normal distribution function
    tick Understand the cdf of normal distribution function
    tick NORM.DIST Function – Applying standard normal distribution to business data
    tick Understand the pdf of normal distribution function
    tick Understand the cdf of normal distribution function
    tick NORM.INV Function – Applying the inverse normal distribution to business data
    tick Marketing analysis with Norm.INV application
    tick BINOM.DIST Function – Applying binomial distribution to retail business data
    tick Business application to control risk for retail stores.

    Financial Functions
    tick PV Function – Calculate the Present value for standard cash flow
    tick FV Function – Calculate the Future value for standard cash flow
    tick NPV Function – Calculate the Net Present value for irregular cash flow

    Add-in Function
    tick How to turn on Add-in Functions?
    tick What is Excel Add-in functions
    tick Statistical Analysis tools for analyst
    tick Applying the statistical tools for big data
    tick Using the Solver Function
    tick Business Maximum Profit analysis by using solver function
    tick Using solver function general for other purposes
    tick Requesting a Solver report

    VBA/Macro Application
    tick What is VBA/Macro and VBE
    tick Installing the developer tab to Excel Ribbon
    tick Understanding the Macro approach to daily work flow
    tick Introduction to Macro application
    tick The 3 steps approach to record a Macro
    tick How to record a Macro?
    tick How to run a recorded Macro?
    tick How to Stop a Macro?
    tick How to delete a Macro?
    tick Adding a button for a Macro
    tick Assigning a different Macro to a button
    tick Change the name and size of the button
    tick More business application for Macro
    tick Introduction to VBA programming

    Excel professional course topic

    Excel Professional2

    Excel Professional3