Charts & Dashboards in Excel

Single & Multi Series Charts, Pie-charts, Stacked Charts, People Graph, Progress Bar, Dashboards with Slicer & Pivot Charts

What will you learn in this course?

Presenting complex data in a simple way is essential for any business. If you don’t have the skills to create compelling charts and dashboards, your data gets lost in uninspiring spreadsheets. This course helps you in not only create attractive charts but also use them for analysis and interacting with your data.

Types of charts

Learn how to create different types of charts in Excel.

It is essential to understand which task you should use to represent a particular data. Most people err here and end up creating charts that end up confusing the reader.

Learn clever formatting using lesser known charts in Excel to create a much greater impact with your audience.

Multi-series charts

While creating charts is simple, it can get confusing when you create charts with multiple series.

Multi-series charts also help you in arriving at complex insights which are otherwise difficult to infer from data.

Understand the basics of how you can navigate your way through multi-series charts, progress bars to represent your data in a powerful way.

Dashboards

Dashboards help you interact with the data in real-time. You can create visual interactive dashboards for looking at data with different permutations and combinations.

Visual interactive dashboards can lift your presentations considerably and can help you present data from many perspectives with just a few clicks.

How will this course help you?

Through this course, you'll learn to create most effective charts for each type of data, and how best to use them in order to communicate your message clearly. You'll also learn how to use charts for analysis and dashboards for interactivity.

Impactful visualization

All of us deal with a large amount of data at work. It isn't always easy or intuitive to make sense of the data you have quickly. However, charts simplify it significantly.

You'll be able to use your understanding of creating the right chart for your data to get your message across and get your audience to focus on what's important.

Analysis through charts

Just like charts make it easy to look at large data sets, they also make it easy to analyse data and infer insights from it.

Multi-layer charts let you juxtapose two seemingly un-related sets of data and spot insights that may be difficult to identify otherwise.

This method eliminates the need for writing complex formulas to arrive at these hidden insights.

Interact with data

Dashboards with charts allow you to look at various permutations in a real-time manner. These allow you to present various views of your data to your audience in real-time.

These enable you to explore alternative cuts of your data as you study the data individually or in a group of people, therefore getting you quick answers to your hypothesis.

A young man wearing headphones and looking at a laptop with focus

What all does this course include?

You'll have access to all these benefits once you enroll in this course

Short lessons for a quick understanding

Personalized feedback on assignment

Course Certificate on approval of assignment

Earn a Skill Badge on approval of assignment

Link to add certificate to your LinkedIn profile

Invitations to upcoming webinars

Discussion forum for clarifying doubts

Downloadable worksheets for practice

Course Curriculum

Creating Charts and Dashboards
8 Lessons
- Download Resource File
  Start
- Create a Column Chart for a Single Data Series
  Start
- Create Different Types of charts for Multiple Data Series
  Start
- Display Percentage in a Pie-Chart without calculating Percentage Data
  Start
- Display Aggregate Information for Related Data using Stacked Charts
  Start
- Creating People Graph
  Start
- Create a Progress Bar
  Start
- Create Dynamic Dashboards with Pivot Charts
  Start
Wrap-up
2 Lessons
- Final Words
  Start
- Assignment
  Start

Get access to the course

Master the art of creating amazing charts and dashboards in Excel with this course.

Gain the skills required to build amazing visuals that get people interested in your data and help drive smart decisions - faster.

Unlock the power of your data now!