• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer
Wooster

Technology@​Wooster

Collaborating with the campus community to explore questions of​ pedagogy, best practices, and technology integration.

  • For Students
    • What Technology do I need at Wooster
    • Computer Labs
    • Downloads
    • Wireless
    • Printing
    • E-Mail
    • Gaming Consoles
    • Poster Printing
  • I’d like to
  • Events
  • Staff
    • Applications Development
    • Educational Technology
      • About
    • Information and Planning
    • Research and Planning
    • Technology Services
      • Digital Infrastructure
      • Media and Event Support
      • Technology Services – Media Services
      • Technology Services – Service Desk
    • Student Digital Media Assistants
    • Student Research Assistants
    • Student Technology Assistants
  • Resources
    • ArcGIS Online
    • Hoonuit online training
    • Moodle
    • Professional Development
    • Projects in a Box
    • Qualtrics
    • Select Survey
    • WordPress(Voices)
    • Workshops
  • Technologies
    • Classroom Technology
      • Document Cameras
      • Epson Technologies
      • SMART Technologies
      • Student Response Systems
      • Video Conferencing
    • Digital Media
      • Audio
      • Images
      • Mobile Apps
      • Presentation
      • Video
    • Virtual Reality
      • VR Resources
      • Virtual Worlds
    • Web 2.0
      • Information Management
      • Mashups
      • Media Sharing
      • Social Communication
      • Social Knowledge Building
    • Web Authoring
      • Blogging
      • CMS
      • Wikis
  • Contact Us
    • Ed Tech Consultation
    • Tech Services Consultation
  • Change Your Password
  • Spam & Junk Email
  • IT Policies
  • IT Blog
You are here: Home → Microsoft 365 → Excel → Pivot Tables and Charts in Microsoft Excel

Pivot Tables and Charts in Microsoft Excel

I find that Excel is a powerful tool for statistical data analysis. There are several different financial, statistical and logical functions one can use to work with data. One of my favorite tools in Excel is a pivot table. Pivot tables are used to generate a summary of the data. Suppose we have a table containing data. An example of what that might look like has been provided below.

Table containing multiple rows of data
Table containing multiple rows of data

By using the pivot table tool, we can quickly summarize a large set of data. The option to generate a pivot table is the first option from the left under the ‘Insert’ menu.

Insert menu in Excel
Insert menu in Excel

To generate your pivot table, just select the data you want to summarize and click on the ‘PivotTable’ button. You will then have you choose the fields you want as the rows, columns, values and filters. Pictured below is a table where the rows are account types, columns are cities, values are sums of account balances and we can filter the results based on the state.

Pivot Table
Pivot Table

In this table, I was able to quickly generate the sum of all checking and savings account balances for each city.

Another feature in Excel that I use quite often is charts. Charts are useful to represent features of data graphically. Suppose we have a table with data we want to create a chart of.

Table containing data
Table containing data

We can create a chart using the chart options under the ‘Insert’ menu. Excel offers many different types of charts such as bar, line, pie etc. The chart use see below was generated using the above table. There are several options available to customize the way charts look.

Bar chart representing data from the table
Bar chart representing data from the table

This article just covers a couple of my favorite features from Excel. I would highly encourage exploring other features as Excel is not only a useful application, but being able use it is also a highly marketable skill.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to print (Opens in new window)

Related

Filed Under: Excel, Microsoft 365 Tagged With: charts, excel, pivot table

Primary Sidebar

Interesting Videos

Resources

  • We can help with…
  • Professional Development
  • Projects in a Box
  • Workshops
  • I.S. Support
  • Request an Appointment
  • ArcGIS Online
  • Hoonuit online training
  • Qualtrics
  • Poster Printing
  • Request a Wiki
  • Loaner Equipment

Copyright © 2021 · Technology Theme 3.0.0 on Genesis Framework · WordPress · Log in

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkNo
You can revoke your consent any time using the Revoke consent button.Revoke cookies