Data Visualization & Presentation With Microsoft Office
Autor Valerie M. Sue, Matthew T. Griffinen Limba Engleză Paperback – 28 dec 2015
Preț: 516.81 lei
Preț vechi: 662.57 lei
-22% Nou
Puncte Express: 775
Preț estimativ în valută:
98.90€ • 103.72$ • 82.47£
98.90€ • 103.72$ • 82.47£
Carte disponibilă
Livrare economică 18 decembrie 24 - 01 ianuarie 25
Livrare express 03-07 decembrie pentru 35.83 lei
Preluare comenzi: 021 569.72.76
Specificații
ISBN-13: 9781483365152
ISBN-10: 1483365158
Pagini: 360
Ilustrații: illustrations
Dimensiuni: 187 x 232 x 22 mm
Greutate: 0.64 kg
Ediția:1
Editura: SAGE Publications
Colecția Sage Publications, Inc
Locul publicării:Thousand Oaks, United States
ISBN-10: 1483365158
Pagini: 360
Ilustrații: illustrations
Dimensiuni: 187 x 232 x 22 mm
Greutate: 0.64 kg
Ediția:1
Editura: SAGE Publications
Colecția Sage Publications, Inc
Locul publicării:Thousand Oaks, United States
Recenzii
If you use Excel and Office to visualize and communicate data you’ll find this book invaluable.
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.
This text will introduce the MS Office neophyte to the wonders of creating charts while minimizing frustrations.
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.
This text will introduce the MS Office neophyte to the wonders of creating charts while minimizing frustrations.
Cuprins
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
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
Notă biografică
Descriere
Doing the job of a Microsoft Office manual, a graphic design text, and a data visualization book in one, this book covers the full range of tasks, from procuring data to presenting a report and provides step-by-step instructions for creating visual data displays