As data strategies become pervasive in all business and institutional sectors, Excel will become even more popular as a bridge tool for non-data scientists doing more work, more often, with data. This learning path is the perfect entry point to the world of data-centric projects and skills.
Master statistics functions in Excel.
Learn the data analytics and modeling capabilities of Excel.
Explore how to work with R, a tool for advanced data work.
Excel Statistics Essential Training: 1 with Joseph Schmuller
Learn statistics. Dr. Joseph Schmuller uses Microsoft Excel to teach the fundamentals of descriptive and inferential statistics.
3h 37m • COURSE
Excel Statistics Essential Training: 2 with Joseph Schmuller
Learn more statistics fundamentals. Find out how to perform ANOVA, regression, and correlation testing and run simulations in Microsoft Excel.
2h 10m • COURSE
Excel 2016: Managing and Analyzing Data with Dennis Taylor
Learn easy-to-use commands, features, and functions for managing and analyzing large amounts of data in Excel 2016.
3h • COURSE
Learning Excel: Data Analysis with Curt Frye
Unlock the power of your organization's data. Learn how to perform data analysis in Microsoft Excel.
2h 9m • COURSE
Excel 2016: Data Validation in Depth with Dennis Taylor
Learn how to use the data validation tools in Excel 2016 to control how users input data into workbooks and ensure data is entered consistently and accurately.
1h 34m • 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
Excel VBA: Managing Files and Data with Curt Frye
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
You'll learn Excel for data science with these experts
Joseph Schmuller is an award-winning teacher and writer.
Joseph holds a BS from Brooklyn College, an MA from the University of Missouri—Kansas City, and a PhD from the University of Wisconsin—Madison (all in psychology). He has held a variety of positions in industry and in academia. A former member of the American Statistical Association, Dr. Schmuller has taught statistics at the undergraduate, honors undergraduate, and graduate levels. He is the author of the three editions of Statistical Analysis with Excel For Dummies. He lives with his family in Jacksonville, Florida.
Dennis Taylor is an Excel expert who has 25+ years of experience in spreadsheet authoring and training.
Dennis has experience working as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the U.S. and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado.
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.
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.