13 Resources [LKP]

This module contains the resulting dashboard, the Access database and the first version of the tutorial, created using Excel 2003, if you happen to still need it.

12 Final Touches [LKP]

The dashboard dashboard is almost ready for testing. But first we need to find the obvious errors and data exceptions, move things a bit, check colors and other final touches.

11 Adding a Map [LKP]

In this module we'll add a map to the dashboard. Nothing fancy, just a scatterplot with a background image, but is good enough to give us a sense of where thing are.

10 Defining KPI [LKP]

There are no dashboards without KPIs. We'll define the KPIs for the Demographic Dashboard, decide how to display them and where.

09 Designing the Dashboard [LKP]

This is the moment when we put everything together and actually design the dashboard. In these three videos we'll move things around, add and resize charts, change colors...

08 Create a Top Ten Table [LKP]

Today we are adding a table to our dashboard. It's a simple table: 10+1 countries (the active country), total population and population by age group. It also contains a bar and a line chart.

07 Create a Line Chart [LKP]

Today we are going to prepare a special data source for the line chart that points to different ranges depending on user's input.

06 Making a Scatterplot [LKP]

We'll see how to remove duplicates from a list, how to use functions like SUMPRODUCT() and ADDRESS() and how to split a table to create several series for a scatter plot.

05 Creating a Population Pyramid [LKP]

We'll create our population pyramid. This is a simple but interesting chart, for several reasons. First, it uses lines instead of the traditional columns, improving readability. Then it shows that you can use scatter plots to make line charts. It also shows how to display data to the left and to the right of the y-axis.

04 Creating Filters [LKP]

In Excel there are also some nice database functions, and that's what we are going to use to manage the data in this module. So the main goal today is to learn how to use the DSUM() function.