Pivot Table Training

Topic outline

• General

  General
• Introduction to Pivot Tables

  Introduction to Pivot Tables

  Pivot Tables are an extremely useful tool in Microsoft Excel which allow you to extract and summarise large amounts of data quickly and easily, with advanced features such as Pivot charts which can also help display your data in a useable way. They can be used for a variety of projects, for example – summarising a list of sales data.

  
  

  This training covers the basics of what Pivot Tables are, how to create them, and a brief introduction into some of the more advanced features that are available. 

  It is available to anyone who finds it useful, and is not graded or tested in any way. Feel free to view it as many times as you wish.
• Pivot Table Tutorial

  Pivot Table Tutorial
  • FilePivot Table Training

    Please open up the attached presentation, and run as a slide show to follow the tutorial

  • FileInstructions to switch to classic view Pivot Table
• Exercise

  Exercise

  Now it's your chance to have a go at creating a Pivot Table! 

  • FileSales Note Data

    Attached is a data sheet of sales note data for landings from a vessel between January - March 2020. 

    Using the tutorial above for guidance, please open this file and have a go at creating a Pivot Table, and use this to answer the questions in the below quiz when you're ready

  • QuizPivot Table Quiz

    Once you have created your Pivot Table, please use it to find the information to answer these short 4 questions

• Feedback

  Feedback
  • FeedbackPivot Table Training Feedback

    Please provide feedback regarding your experience of the Pivot Table training. All course feedback is anonymous, the training team uses the feedback to improve the course