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.
    Expand
  • 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.

    CONTACT US GET A QUOTE FIND OUT MORE

  • 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:

  • Thursday 3 November, 2022 (9.30am - 1.00pm)

    Course Start Date: Thursday 3 November, 2022 (9.30am - 1.00pm)
    Location: L 7, 10 Pulteney St. Adelaide
    Instructor(s):
    Christina Mourtzios BMa&CompSc, Dip (Training and Assessment), Cert IV in TAE, Grad Dip LLN

    Christina has a strong background in learning and development with over 12 years’ experience in the industry. She is passionate about developing people and her philosophy is based on a proven ability to enhance the productivity of organisations by helping them develop the most effective and efficient people. Christina brings a creative flair to her training sessions and makes complex sounding concepts simple to understand. She is able to draw on her experiences and share her knowledge with participants so they can build confidence and find value in her training.

    Schedule number: 7995
    Required fees: Price
    Registration (GST Free)$450.00
    Register yourself Register UoA Staff

    Need to register a group or request an invoice for a business or organisation? Register here.