You are here

Data Visualization & Presentation With Microsoft Office
Share

Data Visualization & Presentation With Microsoft Office



December 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.
 
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.

If you use Excel and Office to visualize and communicate data you’ll find this book invaluable.

James Suleiman
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.

Robert N. Yale
University of Dallas

This text will introduce the MS Office neophyte to the wonders of creating charts while minimizing frustrations.

Martin L. Levin
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.

Mr Johnn V Tieso
Business Economics Dept, Catholic University Of America
November 3, 2016

Sample Materials & Chapters

Chapter 2


For instructors

Select a Purchasing Option

SAGE Research Methods is a research methods tool created to help researchers, faculty and students with their research projects. SAGE Research Methods links over 175,000 pages of SAGE’s renowned book, journal and reference content with truly advanced search and discovery tools. Researchers can explore methods concepts to help them design research projects, understand particular methods or identify a new method, conduct their research, and write up their findings. Since SAGE Research Methods focuses on methodology rather than disciplines, it can be used across the social sciences, health sciences, and more.

With SAGE Research Methods, researchers can explore their chosen method across the depth and breadth of content, expanding or refining their search as needed; read online, print, or email full-text content; utilize suggested related methods and links to related authors from SAGE Research Methods' robust library and unique features; and even share their own collections of content through Methods Lists. SAGE Research Methods contains content from over 720 books, dictionaries, encyclopedias, and handbooks, the entire “Little Green Book,” and "Little Blue Book” series, two Major Works collating a selection of journal articles, and specially commissioned videos.