Events & Courses


Certificate in Big Data Analysis in Excel

在每日的商業世界中,我們需要處理大量的數據以及各式各樣的資料分析。因此MS Office扮演重要的角色,協助我們加速完成每天的工作。
多年以來各大企業的員工,一直不斷地努力學習及提升自己的MS Office應用能力,節省自身工作時間亦能夠提升工作效率。
本課程融合了多年的實戰經驗,令各位學員能夠充分利用及了解MS Office各版本的特點。由1997年的紮實基礎到2016年版本的最新技術,都能夠靈活運用。
如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵 與我們聯絡!
Introduction to Data Management, Cloud Data and  Databases
What is data Management, cloud data and databases
Where do we store the data?
What are the businesses and large corporates approach to big data
Why do we need a Server? What is the a local server, cloud server and web server
Why not saving our data in Local drive?
How to implement a Cloud server to home and business application?
Three common Data Types for statistical analysis in business environment
Introduction to the relationship between Databases and Excel
Statistical Functions and business analysis
Average Function – Handling arithmetic mean
Calculation of geometric mean for financial data
STDEV.S Function
Calculation of standard deviation without using the function
NORM.S.DIST Function
Understand the pdf of normal distribution function
NORM.DIST Function
Understand the pdf of normal distribution function
Understand the cdf of normal distribution function
NORM.INV Function
Marketing analysis with Norm.INV application
Business application to control risk for retail stores.
Financial Functions
PV Function – Calculate the Present value for standard cash flow
FV Function – Calculate the Future value for standard cash flow
NPV Function – Calculate the Net Present value for irregular cash flow
Add-in Function
How to turn on Add-in Functions?
What is Excel Add-in functions
Statistical Analysis tools for analyst
Applying the statistical tools for big data
Using the Solver Function
Business Maximum Profit analysis by using solver function
Using solver function general for other purposes
Requesting a Solver report
Mail Merge Function
What is Mail Merge
Understanding the Mail Merge model
Understanding Email systems
Common cautions when using Mail Merge
How to create a Mail Merge document in WORD
How to send all Mails using OUTLOOK
VBA/Macro Application
What is VBA/Macro and VBE
Installing the developer tab to Excel Ribbon
Understanding the Macro approach to daily work flow
Introduction to Macro application
The 3 steps approach to record a Macro
How to record a Macro?
How to run a recorded Macro?
How to Stop a Macro?
How to delete a Macro?
Adding a button for a Macro
Assigning a different Macro to a button
Change the name and size of the button
More business application for Macro
Introduction to VBA programming
如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵到 與我們聯絡!
27 Sep 2020 Causeway Bay

Upcoming HR events

Join HR events, seminars & workshops to get up with the latest HR trends!

  • Free

    HR Congress

    3 Sep 2020 -
  • 如何依法制訂香港僱傭合約?

    11 Jun 2020 -

Popular HR courses

Improve your skills and expand your career path

  • Effective Performance Management System

    28 Sep 2020 Kwun Tong
  • [Webinar] Cultivate Power without Being Intimidating

    30 Sep 2020 -
  • Coaching Clinic® 專業證書課程

    6 Nov 2020 Kowloon Tong

CTHR Events

Latest HR events organised by CTgoodjobs

  • HR Congress

  • Best HR Awards

  • Career Fairs

  • Seminars & Workshops

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed