# Certificate in Big Data Analysis in Excel

Excel Pro Education
Certificate in Big Data Analysis in Excel
DATE & TIME
22 Aug 2022 (Mon)
7:00 PM - 10:00 PM
23 Sep 2022 (Fri)
7:00 PM - 10:00 PM
PRICE
HKD 1,190
ORGANISER Excel Pro Education
LOCATION DESCRIPTION

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
• SAS
• Oracle
• Access
• SAP
• Introduction to the relationship between Databases and Excel

• 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
• BINOM.DISTFunction
• 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

• 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

Certificate in Big Data Analysis in Excel 