by Nikita Barsukov | Released July 2018 | ISBN: 9781789341034

Turn complex data into meaningful visualization to gain insights by creating perfect charts and histogramsAbout This VideoGo through high-level concrete processes on how to make charts clear, concise, and truthful, by focusing on the most typical chart types: line charts, bar charts, scatter plots, and histograms.Get a top-down approach in data science by first communicating and then implementing your findings in Microsoft ExcelWork on real-life datasets to illustrate how to communicate effectively with data and chartsIn DetailA lot of us who work with data know how to make charts, but don't know how to make effective visualizations that send a clear, efficient, and truthful message. Many of us don't realize what makes charts speak and how to remove noise and focus only on what's important.This course takes a different approach, focusing instead on various data science tools, typical workflows in data projects, algorithms, and the math behind data science. You will work on presenting and communicating with data using visual media such as charts, plots, and histograms with real-world datasets. By working with the four most popular chart types, you will dissect each of them at a microscopic level while using interesting real-world datasets with practical examples in Excel. The aim of the course is to show you where charts work and where they don't and what makes these charts easier to understand.By the end of the course, you will have learned how to implement the principles of effective visual communication using Excel.The code bundle for this video course is available at- https://github.com/PacktPublishing/Perfect-Excel-Charts Show and hide more

1. Chapter 1 : Introduction – Work with Visualization Elements
   • The Course Overview 00:03:40
   • Building Blocks of a Successful Visualization 00:02:26
   • Tips to Make Visualizations Clearer, Understandable, and Concise 00:15:55
2. Chapter 2 : Making a Perfect Line Chart
   • Overview of a Line Chart 00:05:17
   • How to Create a Perfect Line Chart in Excel? 00:09:49
   • How to Create a Stepped Line Chart in Excel? 00:02:38
3. Chapter 3 : Making a Perfect Bar Chart
   • Overview of a Bar Chart 00:05:02
   • Types of Bar Charts and When to Use Them? 00:05:38
   • Things That Make a Better Bar Chart 00:04:25
   • Building a Simple Bar Chart with Enhancements 00:09:13
   • Building Stacked Bar Charts 00:13:02
4. Chapter 4 : Creating Meaningful Scatterplots
   • Questions That Scatterplot Can Answer 00:04:39
   • Tips to Make a Meaningful Scatterplot 00:07:50
   • Making a Scatterplot with Trendlines and Dynamic Point Size 00:11:43
   • Making a Scatterplot with a Categorical Variable 00:11:11
5. Chapter 5 : Making a Perfect Histogram
   • What Is Histogram and How to Build It? 00:07:17
   • What Makes a Meaningful Histogram? 00:12:11
   • Making a Histogram with Extreme Outliers 00:16:47
Show and hide more