Analyzing Data with Confidence: A Beginner's Guide to Data Analysis Using Excel

The course covers a range of topics related to data analysis, including data cleaning and preprocessing, data mining, data visualization, and statistical analysis. The course typically begins with an introduction to the data analysis process, including the importance of data cleaning and preprocessing. Students will learn how to identify and correct common data quality issues, such as missing data, outliers, and inconsistent formatting.

This data analysis course is designed to provide a comprehensive yet practical overview of the whole analytics value chain, with a particular emphasis on the tools needed to extract objective insights from data. You will learn about the analytical process, including an overview of statistical ideas and techniques. You will also participate in hands-on exercises using Microsoft Excel and learn real data analysis skills.

* Learners should have an internet-enabled laptop with Microsoft Excel version 2016 or later preinstalled and comfortable with with performing more advanced functions on Excel and possess basic knowledge in statistics when attending this course.

Earn A Professional Certificate in Data Analytics in 4 Days!

Aventis' Professional Certificate in Data Analytics series aims to provide beginners with a comprehensive understanding of the 4 pillars of data analytics: data management, data analysis, data visualisation, and data storytelling.

Complete these 4 courses and earn your Professional Certificate:

1. A Beginner's Guide to Data Management & Data Reporting
2. A Beginner's Guide to Data Analysis
3. A Beginner's Guide to Data Visualisation
4. A Beginner's Guide to Data Storytelling

Upon completion of the course, learners will be able to:

• Understanding the fundamental concepts of data analysis including statistical inferencing
• Perform statistical analysis with different measures including central tendencies and variability
• Apply data analysis techniques to solve real-world problems in various domains
• Interpret the results of data analysis and draw conclusions from the findings

• Professionals and individuals with an interest to learn and improve their understanding and skills in data analytics.
• beginner-level learners across all industries and job functions.

"Jason has a good knowledge of data analytics and was helpful to give relevant scenarios and descriptions related to our work and industry."

"Mr Jason is very knowledgeable and is a very patient trainer. He guided me when I couldn't keep up."

Jason Khoo is a senior instructor with more than 20 years’ experience in training, and a qualified ACTA with WSG-SSG. He is a data analytics practitioner of 30 years. In the past he worked in TIBS (currently SMRT), MobileOne Ltd, 3M and Virgin Mobile.During his tenure, he has worked with multiple databases, extracted and downloaded information from systems and run numerous analysis. Such data analysis spanned across many departments such as Finance, Sales, Marketing, Human Resources, Payroll and Operations.He continued to work as an independent data analytics consultant for many companies, including Discovery Asia, 3M, Tanah Merah Country Club, Johnson and Johnson Vision Care, National Environmental Agency, Timberland and others.His data analytics skills combined with his in-depth knowledge of Microsoft Excel allowed him to deliver useful reports to clients without them having to incur software cost. These reports include Dashboards, Top 10 charts, Risk Analysis, Business Models, KPIs, etc.