Programme Objective
 

This workshop is designed for finance and accounting professionals who work on strategizing and analyzing business problems. It is focused on learning about nuances of data analytics and describing raw data to derive further decision making in today’s world.

 

The participants of this workshop will learn working with large data sets and complex calculations whilst understanding data statistically. The trainer will focus on multiple available techniques in analyzing the data, Data forecasting, Descriptive analytics and Predictive Analytics to enhance the participants’ understanding of data from an analytical perspective and ability to make informed decisions.

 

This workshop will also help the participants to learn tips and tricks of doing quick analysis and managing data quickly to present insightful reports to the client

Our expert trainer will work with the participants on huge data sets and practical examples to help them relate to real life analytical problems and optimum approach to the solutions.

 

Hands on exercises will be given to help the participants to master these functionalities and apply them in a meaningful way.

 

 

Training Outcomes:

 

At the end of the workshop, the participants will be able to increase productivity and enhance efficiency in their day-to-day work with Excel files. Participants will be able to analyze their financial data in a meaningful way to draw further insights for decision making. The aim of the workshop is to allow the participants to be more self-confident with data mining and advanced analytical techniques for further analysis and interpretation for senior management and steer committees.

Programme Outline

Understanding Data statistically for further analysis

1. What is Data Analytics and its types
2. Using Statistical Analysis
3. Descriptive Vs Predictive Analytics
4. Predictive Vs Prescriptive Analytics
5. Data Modelling Relationship
6. Application to Business Management
7. Discussing examples

Mastering Descriptive Analytics and application of these concepts in real work related projects on raw data to derive quick decisions

1. Understanding the concepts of statistical terms and techniques
2. Correlation analysis
3. Correlation Vs Causation
4. Using Statistical Analysis to generate insights
5. Multiple hands-on exercises and examples to help participants to apply these techniques in their respective work areas
6. Quiz and practical exercises

Understanding the techniques of Predictive Analytics and its application

1. Regression analysis techniques
2. Concept of Hypothesis Testing
3. Data Modelling Relationship
4. Quiz and practical exercises

Quick Analytical Tips and Tricks to apply analysis on day-to-day work

1. Using Excel for Advanced Data Analysis
2. Managing multiple business scenarios and achieving targets

Dashboard designing

1. What is Management Dashboard
2. Principles of dashboard design
3. Using Advanced formulas to create dynamic data
4. Linking humungous data with customized view and selections
5. Mastering Developer Tab
6. Hands on exercises

Mastering the concept of Forecasting

1. Forecasting using historical data
2. Forecasting in Excel
3. Application of Forecasting methods in Excel

 

Pre-requisites

Please take note of the following admission requirements:

• Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
• Mandatory for video camera to be turned on throughout the course
• Display your official name (as per NRIC) in Zoom, to facilitate attendance taking

Training Methodology

Live Webinar, with multiple hands on exercises and assignments

Closing Date for Registration

1 week before programme or until full enrolment.

Intended For

The training is ideal for those (such as Accountants, Controllers, Finance managers, Auditors and all accounting professionals) who deal with large volume of data and Excel applications in their day-to-day work for reporting, data mining and need Excel tools and technologies to further enhance their efficiency and productivity in data analysis and interpretation.

Programme Facilitator(s)