Create Charts and Dashboards Using Microsoft Excel
In this project, you will learn how to create charts in Microsoft Excel to analyze sales data of a sample company. You will learn how to create PivotTables to assess different aspects of the sales information, and represent the information from the tables as line, bar, and pie charts. When creating the charts, you will learn how to format them so they are easily interpreted and you will then assemble the charts in a dashboard to provide a global picture of the sales data.
Buy Now Free
- Level Intermediate
- Duration 3 hours
- Course by Coursera Project Network
-
Offered by
About
In this project, you will learn how to create charts in Microsoft Excel to analyze sales data of a sample company. You will learn how to create PivotTables to assess different aspects of the sales information, and represent the information from the tables as line, bar, and pie charts. When creating the charts, you will learn how to format them so they are easily interpreted and you will then assemble the charts in a dashboard to provide a global picture of the sales data.Modules
Your Learning Journey
-
2
Readings
-
1
Plugin
-
1
Lab
-
1
Assignment
1
Assignment
- Assess Your Knowledge
1
Labs
- Create Charts and Dashboards Using Microsoft Excel
2
Readings
- Project Overview
- Community Discussion Forum
Auto Summary
Master the art of creating insightful charts and dashboards using Microsoft Excel in this intermediate IT & Computer Science course by Coursera. Over 180 minutes, you'll learn to analyze sales data, create PivotTables, and represent data with various charts. The course focuses on formatting and assembling these charts into a comprehensive dashboard. Ideal for those looking to enhance their data visualization skills, it’s available for free.
Paula Del Rey