Название: Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks
Автор: Jonathan Schwabish
Издательство: CRC Press
Год: 2023
Страниц: 401
Язык: английский
Формат: pdf (true)
Размер: 34.5 MB

This book closes the gap between what people think Excel can do and what they can achieve in the tool. Over the past few years, recognition of the importance of effectively visualizing data has led to an explosion of data analysis and visualization software tools. But for many people, Microsoft Excel continues to be the workhorse for their data visualization needs, not to mention the only tool that many data workers have access to. Although Excel is not a specialist data visualization platform, it does have strong capabilities. The default chart types do not need to be the limit of the tool’s data visualization capabilities, and users can extend its features by understanding some key elements and strategies. Data Visualization in Excel provides a step-by-step guide to creating more advanced and often more effective data visualizations in Excel and is the perfect guide for anyone who wants to create better, more effective, and more engaging data visualizations.

I stick with Excel because for my purposes (and for many other data practitioners like me), Excel is all I need. Hopefully my approach to Excel in this book will demonstrate that you can create great, effective visualizations without having to lean on an entire suite of data visualization tools.

In this book, I show you how to build nearly 30 of the “non-standard” graphs in Excel, graphs that are sometimes more complex than those in the standard drop-down menus and that can sometimes show data in better or more engaging ways. I focus on how to extend and combine the basic graphs in the Excel charting engine; how to use Excel formulas to make your graphs and data more responsive and flexible; and how you can be more productive and efficient when working with the tool.