Analyse your data with Excel Pivot Tables

Information

Course description

Course Overview

This course will introduce you to the advantages of using Pivot Tables and Pivot Charts in Excel. Pivot Tables are useful for summarising large amounts of data and viewing it in different ways.

“At the moment I spend time applying filters to Excel table to group data. Learning to use pivot tables will allow me to do this much faster, and in much more detail. It will also make preparing well presented reports much easier."

Date(s)

 

Available Dates:

  • Monday, 21st October 2019 (9.30am - 12.00pm)
  • Tuesday, 19th November 2019 (1:30pm - 4:00pm)
  • Wednesday, 11th December 2019 (9:30am - 12:00pm)
What can I expect to cover?

You will find out how to create multidimensional data views by dragging and dropping column headings to move data around and analyse it from different perspectives.

What will I get out of this course?

On completion of this course you will be able to:

  • Understand how and when to use a Pivot Table
  • Create a basic Pivot Table report
  • Change the layout and value settings
  • Group, subtotal and perform calculations within your Pivot Table
Who is it for?

All staff

Additional Information

We also offer Organise data or make calculations – Take Time to Learn Excel

What prior experience do I need?

You must have a good working knowledge of Excel. This course is aimed at those who have large blocks of Excel data and want to learn how to produce summary reports from this data.

Facilitator(s)

Carol Kemp (IT Services)

Delegate places

Maximum 11 delegates

Minimum 5 delegates

How to make
your reservation

To make a reservation for your place on this course please complete our Booking Form.

Questions

About the course content:
Contact ittraining@le.ac.uk

For Office Use Only

Course Code: SDCCT011

Share this page:

Questions

Contact ittraining@le.ac.uk if you have any questions about this course.