Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks 1st Edition By Jonathan Schwabish ISBN-13: 978-1032343266
eBook[PDF]

Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks 1st Edition By Jonathan Schwabish ISBN-13: 978-1032343266

$30.00
✓ Secure checkout
✓ Instant digital download
✓ PDF document

Document details

Pages
401
File size
3.48 MB
Format
Digital PDF
Category
eBook[PDF]
About this ebook
Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks by Jonathan Schwabish is a step-by-step guide designed to bypass standard Excel limitations. It provides comprehensive tutorials on how to build custom, professional, and highly advanced charts within Microsoft Excel without requiring programming languages. [1, 2, 3]
The topics and chart types covered in the book include: [1]
Foundational Principles & Setup
  • The Philosophy of Data Visualization in Excel: Understanding graphic literacy and how to break out of boring defaults.
  • Introduction to Making Graphs in Excel: The absolute basics of the Excel charting engine.
  • Fundamental Formulas: Key calculations needed to restructure data so Excel can render custom chart structures.
  • Custom Color Palettes: Designing and installing non-standard color themes directly in Excel. [1, 2]
Advanced Chart Types & Visualizations
The core of the book outlines specific, step-by-step technical blueprints for building advanced charts, ranging from basic enhancements to highly complex figures: [1, 2]
  • Grid & Cell-Based Visuals: Sparklines, Heatmaps, Stripe Charts, and Waffle Charts.
  • Project & Strategy Graphics: Gantt Charts, Bullet Charts, and Tile Grid Maps.
  • Distribution & Frequency Models: Histograms, Strip Charts, and Raincloud Plots.
  • Advanced Bar & Column Structures: Broken Stacked Bar Charts, Diverging Bar Charts, and Lollipop Charts.
  • Specialized High-Level Analyses: Slope Charts, Dot Plots, Cycle Plots, and complex Marimekko Charts.
  • Data Annotations & Custom Layouts: Overlaid Gridlines, Block Shading (for both same and different frequencies), and techniques to Mark an Event with a Line. [1, 2]
Formatting, Table Design & Production
  • Making Better Tables: Restructuring text and numbers into clean, scannable data layouts.
  • Exporting Graphs from Excel: Best practices for extracting high-resolution visuals to use in reports, presentations, and websites.
  • Redesigns and Examples: Real-world makeovers that apply the book's design principles to messy, default-heavy charts. [1, 2]

File included

PDF
tmpphpGvZe76 3.48 MB

Topics

Advanced Bar & Column Structures: Broken Stacked Bar Charts Diverging Bar Charts and Lollipop Charts Advanced Chart Types & Visualizations Custom Color Palettes: Designing and installing non-standard color themes Data Annotations & Custom Layouts: Overlaid Gridlines Block Shading and to Mark an Event with a Line Distribution & Frequency Models: Histograms Strip Charts and Raincloud Plots Exporting Graphs from Excel: Best practices for extracting high-resolution visuals Formatting Table Design & Production Fundamental Formulas: calculations needed to restructure data so Excel can render custom chart structures Grid & Cell-Based Visuals: Sparklines Heatmaps Stripe Charts and Waffle Charts Introduction to Making Graphs in Excel ISBN-10: 1032343265 ISBN-10: 1032343281 ISBN-13: 978-1003321552 ISBN-13: 978-1032343266 ISBN-13: 978-1032343280 Making Better Tables: Restructuring text and numbers into clean scannable data layouts Project & Strategy Graphics: Gantt Charts Bullet Charts and Tile Grid Maps Specialized High-Level Analyses: Slope Charts Dot Plots Cycle Plots and complex Marimekko Charts The Philosophy of Data Visualization in Excel
Related ebooks