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)

Unfortunately there are no further dates scheduled at present.

When workshop dates are available they will be released and advertised here on the course description.
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

Participant preparation needed?

None

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.

Formal assessment

No

Facilitator(s)

Carol Kemp (IT Services)

Delegate places

Maximum 11 delegates

Minimum 5 delegates

How to make
your reservation

Please complete the appropriate Online Booking Form submitting to Organisational Development. Booking Conditions apply.

Registration closes 48 hours prior to the event.

Questions

About the workshop content:
Contact Carol Kemp (IT Services) email: ck195@le.ac.uk tel: (0116) 229-7959

About the workshop arrangements:
Contact Organisational Development email: orgdev@le.ac.uk / tel: (0116) 252 5680 / 252-5118 / 223-1257.

For Office Use Only

Course Code: SDCCT011

Share this page:

Booking Forms

How to Book
To make a request to attend a training and development workshop, please complete a Booking Form.  Please note Booking Conditions apply. 

Additional requirements
If you have any access or additional requirements, please contact Staff Development Contact Us.  

About Us

who-are-we.pngWho are we?

Staff contact list

where-are-we.pngWhere are we?

Organisational Development,
Division of Human Resources,
University of Leicester,
Room 004, ground floor, Astley Clarke Building,
University Road, Leicester, LE1 7RH

email.png

Email

orgdev@le.ac.uk

telephone.png

Telephone

0116 252 5021