What you'll learn:
- create the most common type of charts in Excel
- know which chart to use for a given dataset
- perform standard format changes in charts
- use Excel 2013 confidently for charts and graphs
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.