"Excel" Cookbook for Statistics & Data Analysis

This practical Excel workshop focuses on mastering the essential statistical concepts and their data analysis functions, which are crucial for data-driven decision-making. Participants will learn to efficiently manage and manipulate data using Excel’s powerful features, including advanced functions, pivot tables, and conditional formatting. The course covers key statistical concepts such as regression analysis, hypothesis testing, and data summarization through descriptive statistics. Participants will also explore Excel's data visualization tools, including charts and graphs, to present insights. By the end of the course, learners will be equipped to perform robust data analysis and solve complex business problems using Excel’s full analytical capabilities with its Data Analysis library.

Workshop Overview

Learning Outcomes

Gain knowledge in using key statistical functions.
Learn to create and customize pivot tables for summarizing large datasets.
Use Excel’s Descriptive Statistics tool to summarize datasets and understand key metrics.
Understand how to use Excel’s regression data analysis model.
Develop skills to create meaningful charts, graphs, and histograms.
Apply t-test, Anova, regression and all other statistical concepts with function and Excel Data Analysis tool.
Learn to use Solver and Goal Seek to solve complex business problems.