Home > Store > Home & Office Computing > Microsoft Applications

Data at Work: Best practices for creating effective charts and information graphics in Microsoft Excel

Register your product to gain access to bonus material or receive a coupon.

Data at Work: Best practices for creating effective charts and information graphics in Microsoft Excel

Best Value Purchase

Book + eBook Bundle

  • Your Price: $48.59
  • List Price: $80.98
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

More Purchase Options

Book

  • Your Price: $35.99
  • List Price: $44.99
  • Usually ships in 24 hours.

eBook (Watermarked)

  • Your Price: $28.79
  • List Price: $35.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

About

Features

• A frank, practical guide to data visualization fundamentals–no design experience required

• Shows students how to use the skills they already have to think about and organize data in ways that directly relate to their work

• The principles taught are tool-agnostic and can be applied regardless of the tool used to create the information graphics

• Students get access to downloadable Excel charts featured in the book with step-by-step instructions on how the charts were created

• Author Jorge Camões runs ExcelCharts.com, a popular blog on how to create charts in Excel that gets 30,000 monthly visitors

Description

  • Copyright 2016
  • Dimensions: 7" x 9"
  • Pages: 448
  • Edition: 1st
  • Book
  • ISBN-10: 0-13-426863-6
  • ISBN-13: 978-0-13-426863-7

Information visualization is a language. Like any language, it can be used for multiple purposes. A poem, a novel, and an essay all share the same language, but each one has its own set of rules. The same is true with information visualization: a product manager, statistician, and graphic designer each approach visualization from different perspectives.


Data at Work was written with you, the spreadsheet user, in mind. This book will teach you how to think about and organize data in ways that directly relate to your work, using the skills you already have. In other words, you don’t need to be a graphic designer to create functional, elegant charts: this book will show you how.


Although all of the examples in this book were created in Microsoft Excel, this is not a book about how to use Excel. Data at Work will help you to know which type of chart to use and how to format it, regardless of which spreadsheet application you use and whether or not you have any design experience. In this book, you’ll learn how to extract, clean, and transform data; sort data points to identify patterns and detect outliers; and understand how and when to use a variety of data visualizations including bar charts, slope charts, strip charts, scatter plots, bubble charts, boxplots, and more.


Because this book is not a manual, it never specifies the steps required to make a chart, but the relevant charts will be available online for you to download, with brief explanations of how they were created.

Sample Content

Sample Pages

Download the sample pages (includes Chapter 4 and Index)

Table of Contents

Introduction

1.     The building blocks

2.     Human perception

3.     Beyond perception

4.     Preparing the data

5.     Information visualization

6.     Discovery and communication

7.     How to choose a chart

8.     Comparisons

9.     Composition

10.    Distribution

11.    Evolution

12.    Relationships

13.    Profiling

14.    Aesthetics in visualization

15.    Color: how to avoid catastrophe

16.    Formatting the chart

17.    Conclusions

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership