Statistics For Business Analytics Using Microsoft Excel

Business statistics is the use of statistical methods and tools to enhance decision-making, understand what is occurring in your company and why, and prepare for the future of your company. Making smarter choices, discoveries, investments, and projections is possible with the help of business statistics. Anyone who uses data to make choices should add business statistics to their toolkit, not only those in the fields of data science, analytics, or business development.

In this 2-day business statistics course, you will learn how to use Excel to model statistical relationships using graphs, calculations, tests, and other analysis tools. You will also learn how to enter and modify data, create charts, create histograms, examine outliers, calculate correlations, compute regression, perform inferential statistics and more.

*Learners should have an internet-enabled laptop with Microsoft Excel 2019 for this course.

Upon completion of the 2-Day course, learners would be able to:

• Define and understand the role and value of data analytics in business and decision making
• Define and understand various levels of data analytics and frameworks
• Best practices for data analytics and define key metrics for business insights
• Create business charts and pivot tables for data analysis
• Various types of business analysis methodologies for understanding data
• Various types of business statistics for decision making and comparison
• Prediction and forecast using regression and time series

This course is designed for beginners with:

• Basic/working knowledge of Microsoft Excel
• No background or experience in coding, programming, and/or computer science
• No experience and knowledge of statistics or data analytics

Dwight Fonseka is the Head Data Analyst at Plano, the world’s first science-based parental control application and an Adjunct Lecturer at the London School of Business and Finance. His interest in the area of data developed sometime in 2014 when he ventured into data analytics and database management. 7 years later, he has achieved an impressive skill set in data. This includes advanced statistics, big data analytics, cloud computing, neural networks, R programming, python programming, business analytics, data storytelling, and more. Dwight has a Masters in Education (Curriculum & Teaching), a Microsoft Certificate of Achievement (SQL), and an Advanced Certificate in Learning and Performance (ACLP).