DLSEI 3.0 Cohort 3 registration has been closed.

Create Charts and Dashboards Using Microsoft Excel

Included with DLSEI 3.0

Guided Project

Learn, practice, and apply job-ready skills with expert guidance

4.62★

Rating out of 5

Guided project Level

Recommended experience

2.00 Hours

Learn at your own pace

Business

Domain

About this guided project

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.

What skills will you gain?

Microsoft Excel

Spreadsheet Software

Pivot Tables And Charts

Data Visualization Software

Excel Formulas

Data Analysis