Pivot Tables Excel

Due to Coronavirus situation, as of April 1st 2020 this course will be delivered in virtual classroom via Video conferencing.

About the course

Learn to produce pivot data to generate and extract meaningful information from a large table within a matter of minutes. Pivot tables in Excel are a versatile reporting tool that makes it easy to extract information from large data. Pivot tables can summarize long lists of data that can be arranged dynamically, you can calculate summary information without writing formulas or copying cells. Also it can help you analyse large amounts of data. Pivot tables are user friendly, by moving, or pivoting, fields of data from one location to another using drag and drop, you can look at the same data in a number of different ways.

Learning outcomes

At the end of the course, you should be able to do

modifying data and
inserting Pivot Charts.


You must have a general understanding and experience in developing workbooks and worksheets in Excel

Delivery method and resources required

This course is currently being delivered in a virtual classroom environment via video conferencing. You will need a Windows 10 enabled computer/laptop, good internet connection, a web camera (essential as the trainer will need to see your screen) and a printer (optional). Once you have enrolled, you will receive instructions on how to join the virtual classroom.

As this course will be delivered in Microsoft Office 2016, it is expected that you have this version of office loaded on your computer. Your computer or laptop must be operational. If it has any known fault that may disrupt your learning, it is recommended that you do not enrol into this course.

Please note that this is a basic course and not Nationally Accredited and therefore, you won’t receive a Statement of Attainment. However, on successful completion of the full course, you will receive an attendance certificate. After completing this course, you may wish to enrol into the accredited programs such as Introduction to Word, Excel Introduction or Intermediate, Excel Formulas and Functions etc. (When available).

Further information

Should you require further information, please feel free to ring our enrolment office on 02 96872072 or email to admin@parramattacollege.com.au.

This course has no current classes. Please the waiting list.