In this course, you will master the Microsoft Excel techniques successful business analysts and business data analysts rely on every day to extract actionable information from business data. Starting with basic Excel functions (it’s ok if you’ve never used Excel before), you will import and work with real world data sets, display your results in charts and graphs, then solve more advanced problems using Excel’s built-in data functions and the Solver plugin. Along the way, you will learn the essential data modeling and predictive analytics concepts that will give you the power to ask the right questions of data and extract the most useful answers.
You will learn the most important type of models, how to pick the best one, depending on the situation, and how to measure a model’s effectiveness to ensure it remains the best available. And you will know how to avoid common pitfalls of modeling, such as “fooled by randomness” and “over-fitting.”
Intermediate Excel users will have the option to test out of the basic Excel module, in order to move to the more advanced materials in later modules.
使用 Excel 分析数据 is course 2 of 5 in the Excel to MySQL: Analytic Techniques for Business Specialization.
In this Specialization, you’ll learn to frame business challenges as data questions. You’ll use powerful tools and methods such as Excel, Tableau, and MySQL to analyze data, create forecasts and models, design visualizations, and communicate your insights. In the final Capstone Project, you’ll apply your skills to explore and justify improvements to a real-world business process.
Jana Schaich Borg
Psychiatry and Behavioral Sciences
Executive in Residence and Director, Center for Quantitative Modeling
Pratt School of Engineering, Duke University