Data Visualization & Presentation with Microsoft Office

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

Summary 2. Bar and Column Charts

Learning Objectives

Data Appropriate for Bar and 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

Multi-Series Area Charts

Stacked Area Charts

Summary 4. Pie Charts

Learning Objectives

The Trouble with Pie 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 Downloading Data Cleaning Data Summarizing 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

Creating a Pivot Table

Modify and Explore Pivot Table

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