product iamge

Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks

This document was uploaded by one of our users. The uploader already confirmed that they had the permission to publish it. If you are author/publisher or own the copyright of this documents, please report to us by using this DMCA report form.

Download
Search on Amazon

Simply click on the Download Book button.

Yes, Book downloads on Ebookily are 100% Free.

Sometimes the book is free on Amazon As well, so go ahead and hit "Search on Amazon"

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.

Author(s): Schwabish, Jonatham
Year: 2023

Language: English
Commentary: Data Visualization in Excel, Guide for Beginners, Intermediates, and Wonks
Pages: 401
Tags: Data Visualization in Excel, Guide for Beginners, Intermediates, and Wonks

Cover
Half Title
Series Page
Title Page
Copyright Page
Dedication
Table of Contents
Acknowledgements
PART ONE: SETTING THE STAGE
1. Introduction
2. How to Use This Book
3. The Philosophy of Data Visualization in Excel
4. Introduction to Making Graphs in Excel
5. Fundamental Formulas Used in Building Your Graphs
6. Building a Custom Color Palette in Excel
PART TWO: MAKING GRAPHS IN EXCEL
7. Sparklines
8. Heatmap
9. Stripe Chart
10. Waffle Chart
11. Gantt Chart
12. Comparing Values with Two Graph Types
13. Broken Stacked Bar Chart
14. Diverging Bar Chart
15. Block Shading (Same Frequency)
16. Block Shading (Different Frequencies)
17. Mark an Event with a Line
18. Dot Plot
19. Slope Chart
20. Overlaid Gridlines
21. Lollipop Chart
22. Bullet Chart
23. Tile Grid Map
24. Histogram
25. Marimekko Chart
26. Cycle Plot
27. Strip Chart
28. Raincloud Plot
29. Making Better Tables
PART THREE: MOVING VISUALS OUT OF EXCEL
30. Exporting Graphs from Excel
31. Redesigns and Examples
32. Conclusion
Appendix 1. Color Tools
Appendix 2. Data Visualization Tools
Appendix 3. Additional Excel Resources
Appendix 4. Quick Instructions List
References
Index