
Learn about the types of charts and the underlying datasets. Part 1
Learn about the types of charts and the underlying datasets. Part 2
Learn about the basic features of the insert tab.
Step by step I will guid you through our first plot - a pie chart.
In this video I will guide you through all the features of the Excel Design tab.
Learn about the 3 buttons on the right side of your chart.
Learn how to format chart axes.
Try to resemble the graph I created in this exercise. You can find the dataset in the course file.
In this video you will learn about an advanced Pie Chart type.
You will learn about the Doughnut chart - a variety of the Pie chart.
Learn about scatterplots with Excel.
Bubble charts are related to scatterplots but an extra variable can be incorporated.
Line charts are a perfect way to display time series data.
How to create area charts in Excel 2013.
Try to solve the exercise in this lecture. You can also find the solution to it at the end of the video. The dataset is in the course file.
You will learn how you can create charts with paired data.
Learn about dynamic charts which enable you to auto update your charts.
Do you work with charts but struggle to identify which chart to use?
Are you new to data analysis?
Do you want to learn about the charting options Excel 2013/2010 offers?
Are you looking for a structured way to learn about the Excel charting tools?
If your answer was YES to some of the questions, this course might be of interest to you.
When I created this course I put full emphasis on a structured and didactically sound way to gently show you how data visualization in Excel 2013 works. This course is especially suited towards a beginners audience to data visualization with Excel.
Most of the concepts of this course also apply to Excel 2010, so you might also consider this course if you are on 2010.
Beginners to data analysis often need a clear understanding of which chart type is suitable for a given dataset. I will give you this important knowledge right at the beginning so that you know from the start what you are dealing with and how you can utilize that knowledge.
I will also show you step by step all you need to know about the basic chart formatting tools. You will learn how to add elements, format axes, change colors and so on.
There is also a section about the frequently used types of charts and how you can easily create them in Excel.
At the end of this beginners course you should be confident in using Excel for standard charts. You will be also able to format already existing charts and tailor them in accordance with your needs.
I highly recommend to take a close look at the introductory videos on which type of chart to use for a given circumstance. Only if you know which chart type is suitable for a dataset will you be able to make full use of the many options Excel has to offer.