Essential Statistics for Data Analysis using Excel

Welcome to Essential Statistics for Data Analysis using Excel. We’re very excited to have you join us to learn the essentials of statistics and basic probability and how to apply them in Excel. We hope this helps you build on your data analysis and data science foundation and provides an enriching and engaging learning experience.

To get started, click on the Course tab at the top of the page and then read through the brief overview pages in the Getting Started section so you can become oriented to the course structure, the schedule, and how things will work in this course.

The course is designed for self-paced study of around 4 – 8 hours per week for six weeks, including lecture, further reading, assignments, and quizzes. All coursework must be submitted before the course end date, which is displayed on the Home page.


Course Materials

Course Prerequisites Remember that this course is the second course in a three-part xSeries for Microsoft Excel for the Data Analyst. The ability to organize and summarize data using Excel analytic tools such as tables, pivot tables, and pivot charts is needed before taking this course. Also, you should be comfortable creating complex formulas and visualizations. If you think you may need to start with the basics, then check out Introduction to Data Analysis using Excel. Secondary school (high school) algebra Ability to work with tables, formulas, and charts in Excel Ability to organize and summarize data using Excel analytic tools such as tables, pivot tables, and pivot charts Excel 2016 is required for the full course experience. Excel 2013 will work but will not support all the visualizations and functions Course Text Book This course includes excerpts from the following book from Microsoft Press and authored by course instructor Wayne Winston. The course contains all the text book material you will need to complete the course but if you would like to purchase the full book please select the image below to follow the link to the Microsoft Press Store for more information. The book is available in print and eBook (including EPUB, MOBI, and PDF) formats.