Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Perfect Excel Charts
Perfect Excel Charts

Perfect Excel Charts: Communicate with data using Excel charts

Arrow left icon
Profile Icon Nikita Barsukov
Arrow right icon
£7.99 £99.99
Video Jul 2018 2hrs 28mins 1st Edition
Video
£7.99 £99.99
Subscription
Free Trial
Renews at £16.99p/m
Arrow left icon
Profile Icon Nikita Barsukov
Arrow right icon
£7.99 £99.99
Video Jul 2018 2hrs 28mins 1st Edition
Video
£7.99 £99.99
Subscription
Free Trial
Renews at £16.99p/m
Video
£7.99 £99.99
Subscription
Free Trial
Renews at £16.99p/m

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Key benefits

  • • 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

Description

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

Who is this book for?

If you are a business analyst, data scientist, or a data practitioner trying to go beyond the default visualization options, or if you want to figure out how to work with messy real-life datasets, this course is for you.

What you will learn

  • • Apply a top-down approach in data analysis by starting with high-level questions, sketches, and metric definitions for more effective communication with data.
  • • Work with real-life noisy data and communicate findings that are relatable to real life with clarity and truthfulness
  • • Dissect common elements of an ideal chart to get an understanding of how to use it to tell a clear story
  • • Discover how elements of each chart type serve to add clarity and substance to the chart message
  • • Build perfect charts using Excel, one of the most popular statistical applications used worldwide

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jul 26, 2018
Length: 2hrs 28mins
Edition : 1st
Language : English
ISBN-13 : 9781789341034
Vendor :
Microsoft
Category :
Tools :

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : Jul 26, 2018
Length: 2hrs 28mins
Edition : 1st
Language : English
ISBN-13 : 9781789341034
Vendor :
Microsoft
Category :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
£16.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
£169.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just £5 each
Feature tick icon Exclusive print discounts
£234.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just £5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total £ 45.97 191.97 146.00 saved
Excel 2013 Dashboard Design
£7.99 £61.99
Perfect Excel Charts
£7.99 £99.99
Hands-On Financial Modeling with Microsoft Excel 2019
£29.99
Total £ 45.97 191.97 146.00 saved Stars icon
Banner background image

Table of Contents

5 Chapters
Introduction – Work with Visualization Elements Chevron down icon Chevron up icon
Making a Perfect Line Chart Chevron down icon Chevron up icon
Making a Perfect Bar Chart Chevron down icon Chevron up icon
Creating Meaningful Scatterplots Chevron down icon Chevron up icon
Making a Perfect Histogram Chevron down icon Chevron up icon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Chevron down icon Chevron up icon
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Chevron down icon Chevron up icon

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package? Chevron down icon Chevron up icon

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Chevron down icon Chevron up icon

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.