Excel Day 4: Charts and Graphs

Objectives

  • Create and manipulate charts
  • Use different viewing options such as Freeze Panes and Split Screen
  • Prepare a document for printing using page layout and backstage view.

Outline

Hook: Finished Day 4 files

Introduction

  • Has anyone used Excel since last class?
  • Does anyone have any questions since last time?

Create and manipulate charts

  • Paste Special:
    • Use paste special to paste the values, transposed, down the empty slots labeled “Price” and “Quantity”. 
  • Scatter-plots
    • When to use a scatter-plot
    • Adding a trendline
    • Switching x and y axis
    • Change input range
  • Pie Charts
    • When to use a pie chart
    • Edit the legend/title
    • Display percentages
  • Histograms
    • When to use

Viewing Options

  • Split Screen
  • Freeze Panes

Printing Options

  • Page Break preview
  • Insert Page Break
  • Manipulate size of page

Conclusion

  • Recap:
    • Create and Manipulate charts
    • Viewing Options
    • Printing
  • Help desk/Instagram/Upcoming classes