Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, enabling organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage.
Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways.
Microsoft® Excel® is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-driven visualizations to show insights and trends, as well as create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.
Syllabus
- Course 1: Excel: Data Analysis and Visualization Fundamentals
- Course 2: Excel: Data Analysis with Formulas/Functions and PivotTables
- Course 3: Excel: Dashboards and Geospatial Visualizations
- Course 4: Excel: Statistical Analysis and Data Transformation
- Course 5: Excel: Modeling with Power Pivot and Reporting Insights
Courses
-
In this course, you'll continue to develop your data-analysis skills in Excel by presenting visual insights with dashboards. You'll also create geospatial visualizations in Excel. This is the third course in a multi-course Specialization. All of the courses in this Specialization require that you have a recent version of Microsoft Excel installed. The course setup instructions provided in the first course go into more detail about the hardware and software requirements.
-
This course will be useful for anyone who has a foundational knowledge of Excel and would like to perform more robust and advanced data analysis. You will begin by performing fundamental data-analysis tasks like creating tables and sorting and filtering data. You'll also start visualizing data with Excel through charts. This is the first course in a multi-course Specialization. All of the courses in this Specialization require that you have a recent version of Microsoft Excel installed. The course setup instructions provided in the first module of this course go into more detail about the hardware and software requirements.
-
In this course, you'll continue developing your data-analysis skills in Excel by analyzing data using formulas and functions. You'll also analyze data using PivotTables. This is the second course in a multi-course Specialization. All of the courses in this Specialization require that you have a recent version of Microsoft Excel installed. The course setup instructions provided in the first course go into more detail about the hardware and software requirements.
-
To round out your data-analysis skills in Excel, you'll use Power Pivot to create data models and perform advanced analysis and visualization tasks. You'll also plan and then create a report for presenting data-driven findings. This is the fifth and final course in a multi-course Specialization. All of the courses in this Specialization require that you have a recent version of Microsoft Excel installed. The course setup instructions provided in the first course go into more detail about the hardware and software requirements.
-
In this course, you'll continue to develop your data-analysis skills in Excel by performing statistical analysis with trendlines, sparklines, and using the Analysis ToolPak. You'll also connect to data and transform that data to ensure it is clean and in the optimal state. This is the fourth course in a multi-course Specialization. All of the courses in this Specialization require that you have a recent version of Microsoft Excel installed. The course setup instructions provided in the first course go into more detail about the hardware and software requirements.
Taught by
Bill Rosenthal