Sorting, grouping and summarising data in Excel

IT Training

Date:
Wed 13 Nov 2019 - 14:15 to 15:45
Sign up by:
Wed 13 Nov 2019 - 13:45

This self-paced course will help you to gain an understanding of how Excel can be used to manipulate your data to display the information in a variety of different ways including sorting, filtering, grouping, subtotalling and summarising data.

At the end of this trainer-facilitated session you will be able to: 

  • Understand and apply basic Sort Orders
  • Understand and apply basic Filters
  • Understand and apply complex filters and sorts
  • Use advanced filters and database functions
  • Work with sub-totals
  • Work with Tables

All of the tutors for the Lunchtime and Evening sessions are highly qualified and experienced IT trainers who have been delivering a variety of IT courses and workshops to staff and students at the University for many years.

These are some comments from previous attendees:

 

“I thought the work instructions were very clear and helpful.  A good level for beginners.”

 

“I will use it in my degree and later in life”

 

“I will use it as a foundation to learn more about excel, so I can use it for my everyday life, studies & job!”