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.
2h 27m • 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 28m • 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 the president of Technology and Society, Incorporated.He is the author of more than 40 books, including Microsoft Excel 2019 Step by Step for Microsoft Press, and has created and recorded more than 60 courses for Lynda.com and LinkedIn Learning. As a speaker, he has presented talks on topics including "Rhetorical Mathematics" for CLE credit at the Law and Magic conference, "Business Storytelling Using Microsoft Excel" at the ATD-Cascadia annual conference, and his Improspectives® approach to applying the techniques of improv theater to business and life for numerous audiences. As a performer, he has appeared in over 1,300 improv comedy shows with ComedySportz Portland and presents his Magic of the Mind show to theatrical and corporate audiences.Curt earned his BA in political science from Syracuse University and his MBA from the University of Illinois.
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.