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

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

By: Jorge Camoes
  • Written for the spreadsheet user but also goes beyond basic Excel skills
  • Learn how to extract, clean, and transform data
  • Thorough, modern reference about data and data visualization

Excellent book, strong on theory and examples

I purchased "Show me the numbers" by Stephen Few, "Storytelling with Data" by Cole Knaflic, and "Data at Work" by Camoes to improve some excel templates I maintain. I think Data at Work was the best of the three, with a strong overview of perception and information theory combined with a wide range of practical guidelines and examples.

Few's book is massive and comprehensive, but generally too detailed to be easily approachable. Knaflic's book is very much about the storytelling aspect, which is great if you're investing some serious time in individual graphs for something like a quarterly report (once you have the data and know what you want to say), but Data at Work had more content and example that were applicable to something like template building.

Andre

Andre

StarStarStarStarStar

More Praises

I strongly recommend this book if you are seeking new perspectives on ...

I became aware of this book in Twitter and decided to give it a shot. I was impressed with all of its content. I can tell Jorge spent a long time writing and researching this book. This is not another Excel book from the mill. It uses Excel charts only to illustrate how to approach data challenges. I strongly recommend this book if you are seeking new perspectives on how to present data. It is a much comprehensive book than most of the colorful "pretty chart" visualization and "difficult to understand" data science books available from Amazon.

WASal

StarStarStarStar

If you are an Excel nerd and you like visualization then YOU must have this book in your collection

An excellent thorough modern reference in visualization, I refere to several stated framework occasionally when i am conducting a project especially Jorge chart classification which i find very useful.

almost all of the transformations and cases illustrated in the book are done through Excel; which i like a lot.

although the book does not contain step by step instructions to develop these charts (and the book is not intended for that purpose anyways ); if you have a decent background in Excel you will be able to recreate most of the visuals displayed or decode the example files uploaded by Jorge in the companion site.

I begin following Jorge for years, and have a relatively decent background in Excel and VBA. I did not face any problem understanding the files attached in the companion site, the methods and formulas embedded. if i recall correctly all of the examples do not need VBA to construct but i found that I was able to re-create some using VBA routine easily.

one note though the printing quality is crap :) this is a valuable book and very practical too, with bending I noticed that some pages especially at the beginning of the book started to fall :( Jorge if there is any upcoming version please print it with another publisher.

looking forward for your next book Jorge, keep sharing and keep developing good visuals using Excel .. you are among the few people around the world that have mastered creating such beautiful meaningful art with Excel, I hope you stay motivated in this domain and publish more Excel books in the future :) I will definitely buy them all :D

wim

StarStarStarStarStar

Doubly Useful: Excellent Design Tips & All Possible in Excel

This book is excellent. For better or worse, Excel is everywhere. Using it well for data visualization is beyond most people (and books!), but Jorge has you covered. His book is an excellent introduction and detailed guide to visualization core principles and best practices. Excel just happens to be Jorge's tool for communicating, and that makes his tips feel "accessible" to everyone. No obscure data vis tools or software are needed! That said, it does not read like a how-to in Excel, the focus is on design and presentation. All the data files are available on a separate book site. For me, this makes the book twice as useful, and I immediately added it to the top of my list of recommended references on data visualization.

Lynn Cherny

Boston, MA
StarStarStarStarStar

Helpful

Good mix of theory and practice. Well-reasoned, thoughtful, and honest. I can apply the book's advice immediately in my own work.

Wilson Gu

StarStarStarStarStar

Great book - it covers introductory and more advanced topics

Great book - it covers introductory and more advanced topics. Anybody who wants to be better at data visualization should give this book a try.

Susan R.

StarStarStarStarStar

Damaged even though ordered new

I ordered this book new. Unfortunately, it came and there was a tear on the spine.

Elizabeth

StarStarStar

Beautiful and practical instruction for making informative graphs

I ...really.... like this book. Does a beautiful job illustrating just how informative and pleasing graphs can be in spite of Microsoft Excel.

For those of you who've read Edward Tufte and are looking for practical instruction of doing what he says, this is a great start. (For those of you who haven't, what are you waiting for? Get a hold of The Visual Display of Quantitative Information, read it, and then come back.)

For readers who don't care for the lengthy explanations, just flip through until something strikes you. And it will. The Excel examples are a handy reference. All around well executed - this is really about the best you can do in Excel without resorting to VBA hacking. This book will make you think twice about that graph you're working on, and you'll be motivated to make it even better. Well done.

Bryan

StarStarStarStarStar

Book Details

Publisher : New Riders; 1st edition (April 11, 2016)
Language: : English
Paperback : 448 pages
ISBN-10 : 0134268636
ISBN-13 : 978-0134268637
Item Weight : 1.77 pounds
Dimensions : 6.9 x 0.8 x 8.9 inches
Best Sellers Rank : #450,945 in Books (See Top 100 in Books)
#73 in Microsoft PowerPoint Guides
#253 in Microsoft Excel Guides
#259 in Spreadsheet Books

About the Author

Jorge Camoes

Biography

Jorge Camões studied statistics and information management and has been consulting businesses on how to effectively use information visualizations since 2010, with clients in the top 25 pharma companies and major retailers. 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 Excelcharts.com. He works from his home in Lisbon, Portugal.

Downloads & Materials

Close