Sydney Community College

• About
  • Accreditation
  • Awards
  • College Sites
  • Contact
  • Council
  • Mission
  • Principal's Welcome
  • Search Courses
  • History
    • Early History
• Policies
  • Access and Equity
  • Assessment
    • Assessment Reviews
    • Mutual Recognition
    • RPL
  • Codes of Conduct
  • Complaints
  • Customer Service
  • Discount Policy
  • Employment
  • Enrolment
    • Concessions
    • Course Cancellations
    • Physical Activity
    • Refund
    • Transfers
  • Environment
  • Harassment
  • OH&S
  • Privacy
  • Smoking Policy
• Teaching
  • Course Proposal Form
  • Tutor Handbook
  • Tutor Vacancies
• Learning
  • Course Search
  • Student Handbook
• More
  • EmployME
  • Employment Opportunities
  • Forms
  • GoYoungBiz
  • Reports
  • Tutor of the Year
  • Profiles
    • Tutor Profiles

Understand how to create customised Pivot Tables in Excel for easy and flexible data analysis. Learn to create and modify Pivot Tables by adding fields, summarising data amd filtering data. Learn to create and modify Pivot Charts.

Pre-requisite skills: Students must have a thorough understanding of Excel to attend this course.

Agenda

During this course the intention is that the following topics will be covered-but not necessarily in the order given. Due to the flexible nature of Adult Education classes parts of the curriculum may be adapted to suit the needs of the class.

• Create a simple Pivot Table
• Add fields to a Pivot Table
• Filter rows and columns
• Format a Pivot Table
• Summarise data with standard functions
• Create a Pivot Chart
• Data techniques

Objectives

The intended Learning Outcomes for this course are as follows.
By the end of the course the student will be able to:

• Understand how to create and modify Pivot Tables in Excel
• Understand how to create and modify Pivot Charts in Excel

Other Information

Basic knowledge of Excel with sound knowledge of entering data and performing basic calculations.

Please bring a floppy disk (or other portable storage device) to save work to.

Optional – Bring along sample data to analyse and work on.

Design & Technology Ctr, cnr Gordon St & Victoria Rd, Rozelle. If driving, no left turn into Gordon St, so turn left into Lilyfield Rd, then first right into Gordon St.

PLS NOTE: All classes need a minimum number of students to go ahead. If your course does not have enough students it will be cancelled and you will be informed. ***Please be aware that you maybe be informed of a cancellation &/or change via SMS or E-mail.

Show class calendar (1 sessions)