O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Perfect Excel Charts

Video Description

Turn complex data into meaningful visualization to gain insights by creating perfect charts and histograms

About This Video

  • Go 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 Excel
  • Work on real-life datasets to illustrate how to communicate effectively with data and charts

In Detail

A 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