Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

# Master Excel for Data Science

### 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

### Taught by

Eddie Davila, Joseph Schmuller, Curtis Frye, Michael M., Oz du Soleil, Dave Ludwig and Dennis Taylor

## Reviews

Start your review of Master Excel for Data Science

### Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.