Master Excel for Data Science

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 1: 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: Complete Guide to Excel Statistics with Copilot
-Get a comprehensive overview of how to master statistics in Excel using the power of Microsoft Copilot.

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

Course 6: Excel: Filtering Data for Beginners
-Learn how to unleash the full potential of Excel filters. Explore basic and advanced filters, slicers, Power Query, crucial shortcut keys, and more.

Course 7: Excel: Power Query for Beginners
-Get up to speed quickly with Power Query in Excel to import and clean data.

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.