DARREN TROFIMCZUK
  • Home
  • Publications
  • MY COURSES
    • Artificial Intelligence
    • HTML
    • Python
    • Excel Basics >
      • Cell References
      • Charts & Filtering
      • Basic Functions
      • Filtering
      • VLookUp
      • Pivot Tables
      • HLookUp
      • SumIF & SumIFS
    • Online Analytics & SEO >
      • PowerBI Desktop / Analytics
    • Project Management Tools
    • Digital Footprint
    • CRM-Hubspot & Dynamics
  • CV
  • Contact

Pivot Tables

You create the table by defining which fields to view and how the information should be displayed. Based on your field selections, Excel organizes the data so you see a different view of your data. Instead of analyzing countless spreadsheet records, a pivot table can aggregate your information and show a new perspective in a few clicks. You can also move columns to rows or vice versa. 

Creating a Pivot Table steps

  1. Open your original spreadsheet and remove any blank rows or columns.
  2. Make sure each column has a heading, as it will be carried over to the Field List.
  3. Make sure your cells are properly formatted for their data type.
  4. Highlight your data range
  5. Click the Insert tab.
  6. Select the PivotTable button from the Tables group.
  7. Select PivotTable from the list.

Practice Pivot Table Tasks

1) Download this Excel file with USA voting Data:
pivot_table_example1.xls
File Size: 503 kb
File Type: xls
Download File

2) Create a Pivot Table onto a new worksheet for each of these questions:
  • What is the party breakdown by precinct?
  • Do voters use permanent absentee ballots?
  • Which precincts have the most Democrats?
  • How many voter pamphlets do I need for Precinct 2416?
  • Do 18-21 year olds vote?
Support link with Screenshots and guidance support
Introduction to Pivot Tables: http://www.timeatlas.com/excel-pivot-tables/
3) Take a quick look at some other free datasets: ​https://tilastokeskus.fi/tup/mikroaineistot/aineistot_en.html

Statzon (https://statzon.com)

The Statzon tool you can use to help you gather data insights in many markets around the world. I have arranged with their CEO free accounts use until May 2018.
1) Signup here:
 https://statzon.com/register/form 
2) Use your Haaga-Helia email (@myy.haaga-helia.fi) to create a free account. 
Picture

  • Home
  • Publications
  • MY COURSES
    • Artificial Intelligence
    • HTML
    • Python
    • Excel Basics >
      • Cell References
      • Charts & Filtering
      • Basic Functions
      • Filtering
      • VLookUp
      • Pivot Tables
      • HLookUp
      • SumIF & SumIFS
    • Online Analytics & SEO >
      • PowerBI Desktop / Analytics
    • Project Management Tools
    • Digital Footprint
    • CRM-Hubspot & Dynamics
  • CV
  • Contact