In Chapter 1, you will embark on an immersive exploration of basic Excel charts, equipping yourself with the skills to create impactful visualizations and customize chart types. Through a comprehensive understanding of Series and Categories, you will gain the expertise to transform data into compelling narratives that resonate with your audience.

Getting started with data visualization in Excel

Truth or a myth?

Building the first charts

Comparing Contributions

Visualizing Contribution Differently

How are we doing on Sales?

Visualizing Sales per Segment

Quarterly Sales per Region

 Building basic charts

Ready to further enhance your charting skills with Excel? This chapter will explore how to work with dual series and prepare more advanced charts, such as Bullet charts, Waterfall charts, or Scatter plots. Additionally, we will investigate various chart editing options. There's a lot to learn, so let's get started!

Exploring more complex charts

Options

Waterfall chart

Bullet chart

Scatter plot

Pick the right chart!

Bullet, waterfall charts, and scatter plots

Tracking several measures

Comparing versus the average

Quarterly profit walkthrough

Regional performance quadrant

Advancing to more complex charts

Like any discipline, data visualization has its best practices, and it's time to take a closer look at the dos and don'ts. In this chapter, we will improve our skills in selecting chart elements, applying colors, legends, and labels, while also learning how to troubleshoot and customize poorly designed visuals for the benefit of end users.

The art of data visualization

Misleading news?

Chart Clinic 1 on 1

Visualizing evolution

Accenting lines

Fixing a 3D chart

Colorful charts

Data visualization best practices

Get ready for an exciting journey into the world of visualizing disaggregated data in this final chapter! We'll explore PivotTables, PivotCharts, and how to combine them into a dynamic mini-dashboard. Are you ready to unlock the true power of your data? Let's dive in!

Visualizing disaggregated data with PivotCharts

Aggregate or disaggregate - that is the question!

Pivot Charts in action

Basic PivotCharts

Exploring data with PivotCharts

Building a dashboard

Printing our results

Congratulations!

Exercises and Datasets

Excel Formula Translations

Course Glossary

Unlock the power of data visualization with Excel! This course is your ticket to becoming an independent data visualization wizard in a business analysis context. Whether you're a beginner or looking to level up your skills, we've got you covered. You'll learn to solve business problems using various visualizations, from basic bar and line charts to more advanced scatter plots, bullet charts, and waterfalls. Visualizing insights on summarized and disaggregated raw data (with PivotCharts) will hold no secrets as you progress through this course. As you go along, you will acquire the best data visualization practices and learn how to leverage visual design elements to the advantage of your data insights! Let's bring visual insights to life with Excel.

The videos contain live transcripts you can reveal by clicking "Show transcript" at the bottom left of the videos.
The course glossary can be found on the right in the resources section.
To obtain CPE credits you need to complete the course and reach a score of 70% on the qualified assessment. You can navigate to the assessment by clicking on the CPE credits callout on the right.

<h2> Building basic Charts </h2>
You will embark on an immersive exploration of basic Excel charts, equipping yourself with the skills to create impactful visualizations and customize chart types. Through a comprehensive understanding of Series and Categories, you will gain the expertise to transform data into compelling narratives that resonate with your audience.

<h2> Advancing to more complex charts </h2>
Ready to further enhance your charting skills with Excel? You will explore how to work with dual series and prepare more advanced charts, such as Bullet charts, Waterfall charts, or Scatter plots. Additionally, we will investigate various chart editing options. 

<h2> Data Visualization best practices </h2>
Like any discipline, data visualization has its best practices, and it's time to take a closer look at the dos and don'ts. We will improve our skills in selecting chart elements, applying colors, legends, and labels, while also learning how to troubleshoot and customize poorly designed visuals for the benefit of end users.

<h2> Visualizing disaggregated data with PivotCharts </h2>
Get ready for an exciting journey into the world of visualizing disaggregated data! We'll explore PivotTables, PivotCharts, and how to combine them into a dynamic mini-dashboard. Are you ready to unlock the true power of your data? 


Introduction to Excel

Learn how to create a range of visualizations in Excel for different data layouts, ensuring you incorporate best practices to help you build dashboards.

Data Visualization in Excel

Excel Fundamentals

The manager would like to see a breakdown of yearly revenue per product category to assess which products increased/decreased the total revenue.

Our customer base is declining year over year, but the manager wants to know if we had at least one year with a positive inflow/outflow delta.

Your partner has asked you to visualize the household expenses in order to determine if certain spending categories exceed the projected budget.

You'd like to see how your grades stack up compared to other students. For each subject, you would like to compare your grade against the average.

The manager wants to know which products generate the highest profit compared to sales.

Pick the right chart!

Data Visualization in Excel

Latihan interaktif praktis