- Recognize the importance of the ten-second rule when creating visuals in Excel.
- Identify the relationship between data and the visualizations you create in Excel.
- Name the manner in which you can provide the deepest dive into data as you apply visualizations in Excel.
- Explain how a particular Excel chart type will relate different scales to return the output you want.
- Explore the differences in the effectiveness of Excel chart types in relaying information.
- List the justifications for using one type of Excel chart over another.
Skill Level Intermediate
(light music) - [Chris] Hey Everyone, Chris Dutton here, and welcome to Excel Data Visualization Part One, Mastering Charts and Graphs. In this course, we'll begin with some quick data viz best practices, and then explore a few of Excel's chart customization tools, like formatting options and custom templates. From there, we'll review over 20 different chart types available in Excel 2016, including basic options like pies, columns, and line charts, as well as more advanced options like histograms, waterfalls, surface and contour charts, and even geospatial heat maps.
Now, keep in mind that this is part one of a two-part series. So make sure to check out part two, Designing Custom Visuals, where we'll explore a number of more advanced custom demos. We've got a lot to cover, so let's dive in.