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.
Create Charts and Dashboards Using Microsoft Excel
Create Charts and Dashboards Using Microsoft Excel
Instructor: Paula Del Rey
75,072 already enrolled
Included with 
Gain insight into a topic and learn the fundamentals.
4.6
(908 reviews)
Intermediate level
Recommended experience
Flexible schedule
Approx. 1 hour
Learn at your own pace
96%
Most learners liked this course
What you'll learn
Create PivotTables to assess specific relationships within the data.
Create line, bar, and pie charts to present the information from the PivotTables.
Compose a dashboard with the charts and tables created to present a global picture of the data.
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
1 assignment
Taught in English
See how employees at top companies are mastering in-demand skills
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There is 1 module in this course
In this project, you will learn how to create Charts and Dashboards in Microsoft Excel using sales data from a sample company. You will use PivotTables to look at discrete trends in the data, which you will then represent as line, bar, and pie charts. Towards the end of the project, you will summarize the sales data creating a dashboard composed of the charts and tables to provide a global picture of the sales data.
What's included
2 readings1 assignment1 ungraded lab1 plugin
Instructor
Instructor ratings
4.7 (87 ratings)Offered by
Recommended if you're interested in Business Essentials
Coursera Project Network
Coursera Project Network
Corporate Finance Institute
Why people choose Coursera for their career
Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
4.6
908 reviews
- 5 stars
76.26%
- 4 stars
17.91%
- 3 stars
2.41%
- 2 stars
0.65%
- 1 star
2.74%
Showing 3 of 908
LB
5
Reviewed on Jun 24, 2023
The teacher was excellent, very clear communication. I liked how she had us pause and try it ourselves before showing us the answer, I learned better that way having to think it through myself.
DD
5
Reviewed on Feb 15, 2023
GOOD AND HELP FULL COURSE IN DETAILS AND FINANCIAL AID FACILTIES ARE FOR WHO CANT PAY FEES THIS COURSE OF COURSERA IS GOOD AND VALUEABLE
TS
5
Reviewed on Sep 20, 2022
It was awesome. I have learned Dashboard creation. Instructor explaiend enough about what was doing.
New to Business Essentials? Start here.
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
Frequently asked questions
Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.
If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.
Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.
More questions
Financial aid available,