You are here

Book > Textbooks > Scholarly Aids/Research Tools
Data Visualization & Presentation With Microsoft Office
Share

Data Visualization & Presentation With Microsoft Office

Online Resources
© 2016 | 360 pages | SAGE Publications, Inc
Download flyer
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
Report this review
Key features

KEY FEATURES:

  • A unique blend of both data visualization best practices and step-by-step instructions for illustrating data is provided in one easy-to-use resource, eliminating the need to purchase multiple books to learn the data reporting process.
  • Step-by-step coverage of the how-tos of creating bar, column, line, area, and pie charts and tables and inserting them into reports and presentations is enhanced with screenshots of menus and dialogue boxes for readers to easily follow along.
  • Content on creating and delivering presentations goes beyond the technical advice on making charts and shows readers how to present effectively.
  • Abundant figures provide examples of poor and effective data visualization, allowing readers to see the real-life application of the principles discussed in the book.
  • Specific instructions for setting up Microsoft Word for academic reports, configuring PowerPoint for reports and posters, and using Excel to create dashboards are included to guide readers in reporting and presentations.

Sample Materials & Chapters

Chapter 2

Preview this book

For instructors

Review and Desk copies for this title are available digitally via VitalSource.

Request e-review copy

If you require a print review copy, please call: (800) 818-7243 ext. 6140 or email textsales@sagepub.com.

Select a Purchasing Option

Electronic version
Prices from
$26.00*
*180 day rental

Bundles

Shipped Options:

BUNDLE: Evergreen: Presenting Data Effectively 2e + Sue: Data Visualization & Presentation with Microsoft Office

ISBN: 9781544317618
$88.00

This title is also available on SAGE Research Methods, the ultimate digital methods library. If your library doesn’t have access, ask your librarian to start a trial.

Find out more