Back to Create Charts and Dashboards Using Microsoft Excel
Coursera

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.

Status: Microsoft Excel
Status: Trend Analysis
IntermediateGuided Project2 hours

Featured reviews

AP

5.0Reviewed Jul 26, 2023

Super simple to follow along, instructor does a great job explaining every step in detail. Well done

DD

5.0Reviewed 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

M

4.0Reviewed Feb 1, 2024

Very well taught. The material well presented and easy to understand. The dashboard could be made interactive

MH

4.0Reviewed Dec 6, 2022

My business version of Excel is different from the instructors so many of the directions were difficult to follow

TS

5.0Reviewed Sep 20, 2022

I​t was awesome. I have learned Dashboard creation. Instructor explaiend enough about what was doing.

LB

5.0Reviewed 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.

MP

4.0Reviewed Aug 3, 2024

Nifty little course. Great refresher. Should have a separate sample file to work with in case learner already has the recommended spreadsheet editor or an alternative.

LA

4.0Reviewed Jul 24, 2024

I enjoyed the things I learned but this is not the dashboard I was imagining. It was simply copying and pasting charts and graphs onto one sheet.

DN

5.0Reviewed Jul 4, 2022

This course was very helpful. Now I can compile my results on excel sheet and make organised charts and graphs with the help of Pivot Table

MR

5.0Reviewed Jan 19, 2022

Nice course, clearing all the fundamentals of Dashboards. I was hoping more such courses by Instructor to be released on Coursera. "Power-Packed Investment"

SM

4.0Reviewed Jul 4, 2023

GREAT class! The version of Excel that is used is out of date, but it's still a great class and I highly recommend it!

AA

5.0Reviewed Nov 21, 2022

it's very helpful and I enjoyed with it , Now i enable to create. charts and dashboard using google sheets

All reviews

Showing: 20 of 189

Sónia Barroso
1.0
Reviewed Jul 25, 2022
Megan Anderson
1.0
Reviewed May 28, 2022
Kannan N
5.0
Reviewed Jun 26, 2022
Rameez AK
5.0
Reviewed Jun 27, 2022
Victoria Adiwu-Angakuru
5.0
Reviewed May 1, 2023
Diayara Pierson-Mitchell
1.0
Reviewed Jan 26, 2024
AD
1.0
Reviewed Jun 25, 2023
Michelle Casassus Garcia
1.0
Reviewed May 18, 2023
Sukhpreet singh Lohiya
5.0
Reviewed Jun 14, 2023
Rais Husmanov
5.0
Reviewed Jun 3, 2024
Harald Männle
5.0
Reviewed May 24, 2023
ASHWIN RAJ
5.0
Reviewed Mar 12, 2026
Analiza Rejano
5.0
Reviewed Feb 22, 2024
Ohood AlGhamdi
5.0
Reviewed Mar 2, 2025
Asma Abdulaziz
5.0
Reviewed Jan 22, 2025
Lauren Baars
5.0
Reviewed Jun 24, 2023
tran nguyen
5.0
Reviewed Jul 24, 2022
Mayank Rana
5.0
Reviewed Jan 19, 2022
Satyanarayana Raju
5.0
Reviewed Aug 29, 2024
Drousham Nasir
5.0
Reviewed Jul 5, 2022