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. Professor Joseph Schmuller teaches the fundamentals of descriptive statistics and inferential statistics using Microsoft Excel.
3h 45m • COURSE
Excel Statistics Essential Training: 2 with Joseph Schmuller
Learn how to use statistics concepts and tools (including functions, 3D maps, and ANOVA) to perform data analysis in Microsoft Excel.
2h • 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
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
Working with Real-Time Data in Excel with Chris Dutton
Learn how to quickly feed real-time data from an API directly into Excel using WEBSERVICE and FILTERXML functions, enabling powerful insights and real-time analytics.
1h 18m • COURSE
Learning Excel Data-Analysis (2015) with Curt Frye
Learn to perform basic data-analysis tasks, from measuring covariance and correlation to testing hypotheses and calculating Bayesian probabilities, with these Excel tutorials.
2h 24m • 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
Excel VBA: Managing Files and Data 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
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.
Excel expert Dennis Taylor has 25+ years experience in spreadsheet authoring and training.
Dennis Taylor has over 25 years of experience working with spreadsheet programs 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 US 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.
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.
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.