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.
Extend Excel's capabilities and automate complex tasks with VBA. Create advanced filters, charts, and forms, and manage workbooks and worksheets with VBA code.
3h 13m • COURSE
Excel VBA: Process Modeling with 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.
3h 10m • COURSE
Building a Dynamic Heat Map in Excel with Chris Dutton
Learn how to create a dynamic heat map in Excel with conditional formatting and advanced lookup and reference functions.
1h 34m • COURSE
Visualizing Geospatial Data with Power Map in Excel with Chris Dutton
Learn how to build and visualize data within a dynamic heat map using Excel and Power Map.
37m 35s • COURSE
R for Excel Users with Conrad Carlberg
Update your data science skills by learning R. Learn how common data analysis and statistics operations are run in Excel vs. R and how to move data back and forth between each program.
1h 26m • COURSE
Logistic Regression in R and Excel with Conrad Carlberg
Learn how to perform logistic regression using R and Excel. This course shows how to process, analyze, and finalize forecasts and outcomes.
1h 37m • COURSE
Business Analytics: Data Reduction Techniques Using Excel and R with Conrad Carlberg
Learn how to carry out cluster analysis and principal components analysis using R, the open-source statistical computing software.
1h 2m • COURSE
You'll master Excel data and analytics skills with these experts
Curt Frye is a freelance course developer and writer.
He has developed more than 50 online courses on topics including Microsoft Excel, Tableau, Mathematica, and social network analysis. He has also written more than 40 books, with recent titles including Microsoft Excel 2016 Step by Step and Microsoft OneNote 2016 Step by Step, both for Microsoft Press.
In addition to his writing and course development, Curt is a popular conference speaker and entertainer. His programs include his Improspectives® approach to teamwork and creativity, analyzing and presenting data in Microsoft Excel, and his interactive Magic of the Mind show.
Chris Dutton is a certified Microsoft Excel Expert and analytics consultant.
Chris has nearly a decade of experience working with Fortune 500 companies across automotive, retail, insurance, and travel verticals. He has developed award-winning business intelligence and data visualization tools, which have been featured by Microsoft, the New York Times, and the Society of American Baseball Research (SABR). As founder of Excel Maven, Chris has helped thousands of students learn how to use Excel as a dynamic and powerful analytics tool, and has developed personalized training programs for individuals, private groups, and businesses across the country. He graduated summa cum laude and received the Charles Bluhdorn Prize in Economics at Tufts University.
Conrad Carlberg is a writer and consultant specializing in quantitative and statistical analysis.
He has authored 15 books on using Microsoft Excel for quantitative analysis. He holds a PhD in statistics and has run a consulting business specializing in statistical analysis in the medical and financial fields since 1995.