Take your Excel data science skills to an advanced level. As data strategies become more pervasive, Excel will become even more popular for non-data scientists doing more work, more often, with data. This learning path extends the Master Excel for Data Science learning path, into VBA coding, data viz, and advanced interfacing between Excel and R.
-
Master Excel's powerful VBA coding functions for advanced modeling and analytics.
-
Build your expertise in Excel's increasingly powerful data mapping functions.
-
Master the use of Excel with R, the language and data science environment for statistical computing.
Courses
-
1
Excel VBA: Managing Files and Data4h 4mExcel VBA: Managing Files and Data
By: Curt Frye
Learn how to streamline data and file management in Microsoft Excel by using VBA.
-
2
Excel VBA: Process Modeling3h 2mExcel VBA: Process Modeling
By: Curt Frye
Learn how to use Excel and VBA for business process modeling. Find out how to create and run simulations for customer flow, queuing, and manufacturing.
-
3
Excel: Working Together with Power Query and Power Pivot51mExcel: Working Together with Power Query and Power Pivot
By: Joshua Rischin
Learn how to combine Power Query and Power Pivot, two robust features of Microsoft Excel, to analyze data.
-
4
Using Python with Excel56mUsing Python with Excel
By: George Mount
Take your Microsoft Excel skills to the next level using Python, one of the world’s most popular object-oriented programming languages.
-
5
From Excel to SQL1h 24mFrom Excel to SQL
By: James Parkin
As big data gets bigger, it's useful to be able to pull insights directly from MySQL. Learn how to apply your knowledge of Excel to gain new skills at capturing data from MySQL.
-
6
Machine Learning with Logistic Regression in Excel, R, and Power BI2h 49mMachine Learning with Logistic Regression in Excel, R, and Power BI
By: Helen Wall
Learn how to perform logistic regression using R and Excel and use Power BI to integrate these methods into a scalable, sharable model.
-
7
Excel: Economic Analysis and Data Analytics2h 26mExcel: Economic Analysis and Data Analytics
By: Michael McDonald
Find out how to use big data to perform regression analysis for economic forecasting in Microsoft Excel.
Instructors
Curt Frye
Online course developer, freelance writer, and speaker. MBA.
Joshua Rischin
Principal Consultant | Decision Partner to Finance and Executive Leaders | Decision-Grade Models & Reviews | Power BI, Copilot & Excel (applied)
George Mount
Helping organizations modernize Excel for analytics, automation, and AI 🤖 LinkedIn Learning Instructor 🎦 Microsoft MVP 🏆 O’Reilly Author 📚 Sheetcast Ambassador 🌐
Madecraft
James Parkin
Senior Software Engineer working with Javascript and React
Helen Wall
Leveraging data to make better business decisions | Consultant | Lecturer | Instructor | Power BI, Excel, Python, R, and SQL
Michael McDonald
Professor, Fairfield University