Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera Project Network

Create Charts and Dashboards Using Microsoft Excel

Coursera Project Network via Coursera

Overview

Unlock Unlimited Opportunities: Get 50% Off Your First Month of Coursera Plus
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.

Syllabus

  • Project Overview
    • 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.

Taught by

Paula Del Rey

Reviews

4.6 rating at Coursera based on 714 ratings

Start your review of Create Charts and Dashboards Using Microsoft Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.