Lynda.com is no longer available for individual subscribers. Please go to LinkedIn Learning to access your account if you moved or to sign up for a new account. For additional support, reach out to firstname.lastname@example.org.
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.
Chaining and combining filter criteria
Determining whether workbooks and worksheets exist, with VBA
Opening, closing, and saving workbooks
Using VBA to calculate data via Excel's built-in functions
Creating charts with sparklines
Adding fields to UserForms
Manipulating PivotTables with VBA
3h 46m • 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
Excel: Using Dynamic Array Functions (Office 365/Microsoft 365) with Oz du Soleil
Learn how to use the seven new dynamic array functions in Microsoft Excel.
1h 26m • 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 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 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.
Oz du Soleil is an Excel MVP, author, and trainer with a passion for clean data and reliable reporting.
An even greater passion is that of teaching, sharing knowledge, and empowering people to handle their data more efficiently and with greater skill. Over the past 6 years, Oz has been teaching public and private workshops and giving presentations. He has presented at Northwestern University, University of Illinois at Chicago, IgniteChicago, and ExcelTV, and at various Excel and data conferences in Toronto; Amsterdam; San Jose; Portland, Oregon; and Chicago, Illinois.
His book, Guerrilla Data Analysis Version 2, condenses some of that knowledge. Through his popular YouTube channel, Excel on Fire, he trains students to use Excel more effectively and access more of Excel's features. Find out more at http://ozdusoleil.com/.
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.