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.
Excel VBA: Managing Files and Data (2014) with Curt Frye
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 data analysis and statistics operations are run in Excel versus 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 Excel MOS Expert, edtech entrepreneur, and best-selling instructor.
Chris has spent 10+ years specializing in data visualization and business intelligence. As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur.com, and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics seeks to empower everyday people to change the world with data. Chris graduated summa cum laude and received the Charles G. 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.