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

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

Published by
Pearson Higher Ed USA
Available on demand
Title type
Title type
Information visualisation 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 visualisation: a product manager, statistician, and graphic designer each approach visualisation 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 organise 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 visualisations including bar charts, slope charts, strip charts, scatter plots, bubble charts, boxplots, and more.
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
Features & benefits
• 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, a popular blog on how to create charts in Excel that gets 30,000 monthly visitors

Author biography
Jorge Camões has been consulting businesses on how to effectively use information visualizations since 2010 with clients that include the global retail giant, IKEA. Prior to starting his consulting business, Camões worked for 10 years in the business intelligence department of the Portuguese subsidiary of Merck & Co. Camões runs the popular data visualization blog,, which has 30K monthly visitors. He works from his home in Lisbon, Portugal.
Sample Pages