This course features interactive videos to help you understand both the analytical concepts and the software. This course contains a capstone project, in which you will apply the concepts taught using a separate data source; this realistic project gives you the practice and confidence necessary to connect, explore, and analyze data sources into the future.
This course is also part of a certificate:
This course features interactive videos to help you understand both the analytical concepts and the software. This course contains a capstone project, in which you will apply the concepts taught using a separate data source; this realistic project gives you the practice and confidence necessary to connect, explore, and analyze data sources into the future.
This course is also part of a certificate:
Data Analytics and Visualization Certificate
In this course, you will learn the basics of business analytics using Excel. You'll start by learning all about business analytics, including the importance of the role of obtaining crucial information for the organization. Then, you will begin working on a dataset in Excel, and learn essential tasks such as sorting and filtering the data to learn more about the business. Finally, learn how to analyze both categorical and numeric data: for categorical data, learn how to aggregate data using Excel's Pivot Table feature; for numeric data, learn the basics of analyzing distributions using statistics and common visualizations such as histograms and boxplots. By the end of the course, you will have hands-on practice in preparing data for analysis and thoroughly analyzing a dataset using descriptive analytic techniques.
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.