Overview

As data strategies become pervasive in all business and institutional sectors, Excel will become even more popular as a bridge tool for non-data scientists doing more work, more often, with data. This learning path is the perfect entry point to the world of data-centric projects and skills.

Master statistics functions in Excel.
Learn the data analytics and modeling capabilities of Excel.
Explore how to work with R, a tool for advanced data work.

Syllabus

Courses under this program:
Course 1: Statistics Foundations: The Basics
-Learn to understand your data using basics of statistics, such as defining the middle, mean, and median of your data set; measuring the standard deviation; and finding outliers.

Course 2: Excel Statistics Essential Training: 1
-Learn statistics. Dr. Joseph Schmuller uses Microsoft Excel to teach the fundamentals of descriptive and inferential statistics.

Course 3: Learning Excel: Data Analysis
-Unlock the power of your organization's data. Learn how to perform data analysis in Microsoft Excel.

Course 4: Excel for Business Analysts
-This course shows business analysts how to use Excel to measure the health of an organization. Learn how to use Excel to gather, assess, and use business analytics information.

Course 5: Excel: Tracking Data Easily and Efficiently
-Learn how to build a super-charged Excel spreadsheet to easily track any kind of data -from sales activity and inventory levels to household spending.

Course 6: Excel: Filtering Data for Beginners
-Make the most of the filtering capabilities in Microsoft Excel. Learn how to use filters to zero in on exactly the data you need.

Course 7: Excel: Power Query for Beginners
-Get an intro to Power Query, a set of robust features in Microsoft Excel.

Course 8: Excel: Charts in Depth
-Explore how to add visual appeal to your spreadsheets and workbooks with this in-depth course on the powerful charting features of Microsoft Excel.

Courses

0 reviews
2-3 hours
View details

Explore how to add visual appeal to your spreadsheets and workbooks with this in-depth course on the powerful charting features of Microsoft Excel.
0 reviews
3 hours 52 minutes
View details

Learn how to create data trackers in Excel to track any kind of data—from sales activity and inventory levels to vacation budgets using basic Excel and its newest features.
0 reviews
2 hours 41 minutes
View details

This course shows business analysts how to use Excel to measure the health of an organization. Learn how to use Excel to gather, assess, and use business analytics information.
0 reviews
30 minutes
View details

Make the most of the filtering capabilities in Microsoft Excel. Learn how to use filters to zero in on exactly the data you need.
0 reviews
24 minutes
View details

Get an intro to Power Query, a set of robust features in Microsoft Excel.
0 reviews
3-4 hours
View details

Learn statistics. Dr. Joseph Schmuller uses Microsoft Excel to teach the fundamentals of descriptive and inferential statistics.
0 reviews
2-3 hours
View details

Unlock the power of your organization's data. Learn how to perform data analysis in Microsoft Excel.
0 reviews

View details

Learn to understand your data using basics of statistics, such as defining the middle, mean, and median of your data set; measuring the standard deviation; and finding outliers.