Gain hands-on experience extracting, preparing, exploring, and analyzing data statistically and visually using features and tools native to Microsoft Excel. In an ever-growing digital world, the need for strong data analysis skills is at the forefront of every business function, along with the ability to accurately describe and interpret analytical findings.
Class Deals by MOOC List - Click here and see EdX's Active Discounts, Deals, and Promo Codes.
This course will center on foundational concepts of data analysis, tools for working with data, and strategies for communicating results by utilizing a hands-on teaching approach. Topics include approaching data sets with a critical eye, basic statistical and visual analysis, formatting visuals for interpretation, storytelling with data, and an introduction to spreadsheet modeling.
Learn from renowned Kelley School of Business faculty with combined decades of teaching and analysis experience. This course will provide learners with practical skills to support their data analysis and decision-making needs.
This course is part of the Information Systems MicroMasters program.
What you'll learn
- Define exploratory, explanatory, prescriptive, and predictive analytics
- Import data into spreadsheets from external sources
- Cleanse data using functions native to Microsoft Excel
- Summarize data using basic descriptive statistics and statistical charts
- Communicate analysis findings using appropriate data visualization selections and formatting
- Develop simple dashboards to answer business questions
- Explore the foundations of spreadsheet modeling
