University of Bath

Excel: Database techniques (November)

This workshop aims to show the user some of the database techniques available in Excel

29 Nov 201810.00am
to
29 Nov 201811.30am
Free

About the workshop

This training course aims to show the user some of the database techniques available in Excel.

Learning outcomes

After completing this course, 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
  • understand grouping and outlining
  • work with sub-totals
  • work with Tables in Excel