You are here

Data Visualization & Presentation With Microsoft Office

Data Visualization & Presentation With Microsoft Office

Additional resources:

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


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


3. Line and Area Charts
Learning Objectives

Single-Series Line Charts

Multi-Series Line Charts

Area Charts

Multiseries Area Charts

Stacked Area Charts


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


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



Chart Templates



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



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


8. Tables: When Charts Aren't Enough
Learning Objectives

Excel's Table Feature

Table Formatting Best Practices

Custom Table Styles


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





10. Creating Presentations
Learning Objectives

Perspectives on Presentations

Three Presentation Elements

Designing Audience Slides

Creating Speaker Notes

Creating Handouts


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


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


Student Study Site
The open-access companion website at 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

Preview this book

Sample Materials & Chapters

Chapter 2

Valerie M. Sue

Valerie M. Sue is a senior manager at Kaiser Permanente (KP). She manages a range of projects for KP’s Market Strategy and Sales Operations Department and provides data visualization consultation to KP executives and staff. Prior to joining KP, Sue was an associate professor of communication at California State University, East Bay. At CSU, East Bay she taught communication theory, research methods, survey research, statistics, and was the director of the Communication Department’s graduate program. She has authored numerous journal articles, book chapters, and an online survey methods text. Sue earned a PhD in Communication from Stanford... More About Author

Matthew T. Griffin

Matthew T. Griffin is a senior consultant at Kaiser Permanente (KP). He works in KP’s Market Research department analyzing large quantities of web-related data and investigating the ways in which KP members use digital tools to manage their health. Griffin has been using Excel (and before that Lotus 1-2-3) for nearly 30 years. He has honed his expertise and passion for Excel while working in the healthcare, banking, and retail industries. He has provided Excel support and training to hundreds of colleagues over the years. Griffin has a B.S. in Business Administration with a concentration in information systems from San Francisco State... More About Author

For instructors

To inquire about the availability of this title for review (print and/or digital), please contact your local sales representative or call (800) 818-7243.

SAGE Knowledge is the ultimate social sciences digital library for students, researchers, and faculty. Hosting more than 4,400 titles, it includes an expansive range of SAGE eBook and eReference content, including scholarly monographs, reference works, handbooks, series, professional development titles, and more.

The platform allows researchers to cross-search and seamlessly access a wide breadth of must-have SAGE book and reference content from one source.