Share
Data Visualization & Presentation With Microsoft Office
Additional resources:
October 2015 | 360 pages | SAGE Publications, Inc
Written for students, professionals, and social scientists with little or no knowledge of data visualization principles, this complete guide presents step-by-step instructions for clearly and effectively presenting data using MS Office programs. Throughout the book, the focus is on turning raw, quantitative data into attractive, well-designed charts and tables that tell an accurate narrative about underlying information. Helpful illustrations, expert tips for solving common issues, and discussions on working efficiently are included to equip readers with the tools they need to engage their audience using a visual format.
Available with Perusall—an eBook that makes it easier to prepare for class
Perusall is an award-winning eBook platform featuring social annotation tools that allow students and instructors to collaboratively mark up and discuss their SAGE textbook. Backed by research and supported by technological innovations developed at Harvard University, this process of learning through collaborative annotation keeps your students engaged and makes teaching easier and more effective. Learn more.
Available with Perusall—an eBook that makes it easier to prepare for class
Perusall is an award-winning eBook platform featuring social annotation tools that allow students and instructors to collaboratively mark up and discuss their SAGE textbook. Backed by research and supported by technological innovations developed at Harvard University, this process of learning through collaborative annotation keeps your students engaged and makes teaching easier and more effective. Learn more.
Preface
Acknowledgments
About the Authors
Section I: Displaying Data
1. Choosing Data Displays
| Learning Objectives |
| Information and Audience Considerations |
| Are You Preparing a Report or Presentation? |
| Forms of Data Visualization Covered in This Text |
| Which Form of Data Visualization to Use |
| Summary |
2. Bar and Column Charts
| Learning Objectives |
| Data Appropriate for Bar and Column Charts |
| Stacked Column Charts |
| 100% Stacked Column Charts |
| Best Practices for Creating Column and Bar Charts |
| Choosing Between Bar and Column Charts |
| Summary |
3. Line and Area Charts
| Learning Objectives |
| Single-Series Line Charts |
| Multi-Series Line Charts |
| Area Charts |
| Multiseries Area Charts |
| Stacked Area Charts |
| Summary |
4. Pie Charts
| Learning Objectives |
| The Trouble With Pie Charts |
| When to Use a Pie Chart |
| Best Practices for Creating Pie Charts |
| Alternatives to Pie Charts |
| Summary |
5. Chart Formatting
| Learning Objectives |
| Remove Unnecessary and Redundant Information |
| Chart Titles |
| Chart Legends |
| Chart Axes |
| Charts with Data Tables |
| Labeling Individual Data Values |
| Labeling the Y-Axis on a Bar Chart |
| Formatting Numbers on Data Labels and Axes |
| Formatting Dates |
| Fonts |
| Color |
| Chart Templates |
| Perspective |
| Summary |
Section II: Preparing Data for Charting
6. Preparing Data for Charting
| Learning Objectives |
| Sources of Free Data |
| Downloading Data |
| Cleaning Data |
| Summarize the Data |
| Creating a Dynamic Summary Table |
| Subtotal |
| Summary |
7. Pivot Tables and Pivot Charts
| Learning Objectives |
| Introduction to Pivot Tables |
| Organizing Data for Pivot Tables |
| Transposing Rows and Columns |
| Filtering Data |
| Changing Summary Data Values |
| Nesting Variables |
| Totals and Subtotals |
| Refreshing Pivot Table Data |
| Grouping Data |
| Pivot Charts |
| Summary |
8. Tables: When Charts Aren't Enough
| Learning Objectives |
| Excel's Table Feature |
| Table Formatting Best Practices |
| Custom Table Styles |
| Summary |
Section III: Presenting Data
9. Creating Reports
| Learning Objectives |
| Report or Presentation? |
| Moving Charts From Excel to Word |
| Moving Tables From Excel to Word |
| Word's Layout Options |
| Professional Reports |
| Posters |
| Infographics |
| Dashboards |
| Summary |
10. Creating Presentations
| Learning Objectives |
| Perspectives on Presentations |
| Three Presentation Elements |
| Designing Audience Slides |
| Creating Speaker Notes |
| Creating Handouts |
| Summary |
11. Delivering Presentations
| Learning Objectives |
| Preliminary Considerations |
| Speaking of Data |
| Addressing Audience Questions |
| Working With the Physical Space |
| Speaking Into a Microphone |
| Using a Slide Remote |
| Going Pro With Presenter View |
| Delivering Presentations Remotely |
| Summary |
12. Concluding Comments
| Collecting or Downloading Data |
| Cleaning, Organizing, and Analyzing Data |
| Creating Charts and Tables |
| Creating Reports |
| Designing Presentations and Creating Handouts |
| Rehearsing and Delivering Presentations |
| Mastering Data Visualization Skills |
| Suggestions for Further Study |
Appendix A: Excel Basics
Appendix B: Configuring Microsoft Word for APA-Style Reports
Index
Supplements
Student Study Site
The open-access companion website at http://study.sagepub.com/sue features examples from the book in full color.
The open-access companion website at http://study.sagepub.com/sue features examples from the book in full color.
If you use Excel and Office to visualize and communicate data you’ll find this book invaluable.
University of Southern Maine
Data Visualization & Presentation with Microsoft Office is an excellent introduction to data visualization that will assist students and professionals with developing compelling, accurate, and beautiful charts and graphs.
University of Dallas
This text will introduce the MS Office neophyte to the wonders of creating charts while minimizing frustrations.
The University of Memphis
This is an excellent text, well-suited for entering students in the Business School program who need to learn and understand basic presentation skills. Our redesigned course includes more visualization materials than in the past and this text does the job for us.
Business Economics Dept, Catholic University Of America
November 3, 2016
