Most popular programs
Trending now
Using Excel, learn the basics of business analytics and the importance of the role to obtaining crucial information for the organization.
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.