Coursera
Coursera Logo

Create Charts and Dashboards Using Microsoft Excel 

  • Offered byCoursera

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

Start from

Start Now

Mode of learning

Online

Difficulty level

Intermediate

Official Website

Go to Website External Link Icon

Credential

Certificate

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

Create Charts and Dashboards Using Microsoft Excel
 at 
Coursera 
Admission Process

    Important Dates

    May 25, 2024
    Course Commencement Date

    Other courses offered by Coursera

    – / –
    3 months
    Beginner
    – / –
    20 hours
    Beginner
    – / –
    2 months
    Beginner
    – / –
    3 months
    Beginner
    View Other 6715 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...