Coursera
Coursera Logo

Create Charts and Dashboards Using Microsoft Excel 

  • Offered byCoursera
  • Public/Government Institute

Create Charts and Dashboards Using Microsoft Excel
 at 
Coursera 
Overview

Learn to convey information through visualizations, guiding viewers through a narrative supported by data evidence

Duration

2 hours

Mode of learning

Online

Difficulty level

Intermediate

Official Website

Go to Website External Link Icon

Credential

Certificate

Create Charts and Dashboards Using Microsoft Excel
Table of content
Accordion Icon V3
  • Overview
  • Highlights
  • Course Details
  • Curriculum
  • Faculty
  • + 2 more items

Create Charts and Dashboards Using Microsoft Excel
 at 
Coursera 
Highlights

  • Earn a certificate from Coursera
  • Learn from industry experts
  • Guided project & hands-on learning
Details Icon

Create Charts and Dashboards Using Microsoft Excel
 at 
Coursera 
Course details

Skills you will learn
Who should do this course?
  • Individuals who have some familiarity with Excel but want to improve their skills in creating visually appealing and informative charts and dashboards
What are the course deliverables?
  • 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
More about this course
  • In this project, learner will learn how to create charts in Microsoft Excel to analyze sales data of a sample company
  • Learner 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
  • Learner will learn how to format them so they are easily interpreted and they will then assemble the charts in a dashboard to provide a global picture of the sales data

Create Charts and Dashboards Using Microsoft Excel
 at 
Coursera 
Curriculum

Upload a document using the free online version of Microsoft Office 365

Create PivotTables in Microsoft Excel

Create and format a Line Chart in Microsoft Excel to represent sales profits by month

Create and format a Bar Chart in Microsoft Excel to represent sales profits by Salesperson

Create and format Pie Charts in Microsoft Excel to represent sales percentages by product category and city

Create a Dashboard in Microsoft Excel containing charts and tables

Faculty Icon

Create Charts and Dashboards Using Microsoft Excel
 at 
Coursera 
Faculty details

Paula Del Rey
Subject Matter Expert

Create Charts and Dashboards Using Microsoft Excel
 at 
Coursera 
Entry Requirements

Eligibility criteriaUp Arrow Icon
Conditional OfferUp Arrow Icon
  • Not mentioned

Other courses offered by Coursera

– / –
3 months
Beginner
– / –
20 hours
Beginner
– / –
2 months
Beginner
– / –
3 months
Beginner
View Other 6726 CoursesRight Arrow Icon

Create Charts and Dashboards Using Microsoft Excel
 at 
Coursera 
Students Ratings & Reviews

4/5
Verified Icon1 Rating
P
Prabhash Kumar Mishra
Create Charts and Dashboards Using Microsoft Excel
Offered by Coursera
4
Learning Experience: It was great to learn new things which enhanced my knowledge about data.Their way of imparting knowledge was enough to boost my path towards developing a mindset for data analytics
Faculty: It was great.They helped a lot in every aspect of the subject The course resources were readily available at any point with a proper way to test your skills too
Course Support: It was really amazing to get to know about different things
Reviewed on 4 Dec 2022Read More
Thumbs Up IconThumbs Down Icon
View 1 ReviewRight Arrow Icon
qna

Create Charts and Dashboards Using Microsoft Excel
 at 
Coursera 

Student Forum

chatAnything you would want to ask experts?
Write here...