Getting the Most Out of Excel Pivot Tables

Understanding the advanced features of Excel will streamline your workflow and help you manage large amounts of data and information.

  • Understand how to manage large lists of information effectively.
  • Create pivot tables to enhance the quantity and quality of data analyses.
  • Organise and display critical information clearly.
  • Use tips and tricks to enhance accuracy and save time.
  • What is covered in the course?

    • Working with data sets.
    • Creating and using a pivot table.
    • Useful pivot table options.
    • Using ‘What If’ analysis tools.
    • Tips and tricks for making the most of pivot tables!
  • Should I attend?

    This session is designed for professionals at any level looking to improve their knowledge and skill of Excel – specifically pivot tables.

    An ideal course for anyone working with a large amount of data in Excel, needing to undertake meaningful analysis.

  • How will I benefit?

    You’ll learn the advanced features in Excel that will help you rearrange, summarise, cross reference and analyse data from an Excel list or database. Unlock the secret to pivot tables that will enable you to collate, organise and present information in an easily understood format.

  • How will my organisation benefit?

    Better management of financial information, better analysis and better understood data to inform business decisions and processes … which organisation wouldn’t want that?

    Need customised training for your organisation?

    Contact our team to discuss customising this course to meet your needs.


  • AQF Equivalence, Articulation Pathways CPD Points and Certification

    • You will receive a soft copy University of Adelaide Certificate of Completion.
    • This PACE course may contribute to earning Continuing Professional Development (CPD) points or credit. Many professional associations accredit CPD at a standard rate of 1 hour of professional development / learning = 1 CPD point. This should be used as a guide only and confirmation should be sought from your accrediting body prior to registration in any PACE course or program.
Learning new and useful functions of Excel.past participant

What will I receive as part of this course?

  • Printed course book and materials (PDF copy for tablet on request)
  • Certificate of Completion and training record
  • Refreshments during the day, including a light lunch on full day courses

What should I bring to the course?

Our courses are designed to be work-related and interactive. Please bring current workplace examples related to this topic for use on the day.

What further development can I do?

We recommend Getting the Most Out of Excel Formulas and Functions or Get Organised Using Outlook.

Available course dates:

No dates for this course are currently being offered. Please register your interest for future dates by emailing