Events at The University of Manchester
  • University home
  • Events
  • Home
  • Exhibitions
  • Conferences
  • Lectures and seminars
  • Performances
  • Events for prospective students
  • Sustainability events
  • Family events
  • All Events

Webinar: Tables and Pivot Tables in Excel

image
Dates:23 March 2021
Times:14:00 - 15:30
What is it:Webinar
Organiser:Cathie Marsh Institute for Social Research
How much:Free
See travel and contact information
Add to your calendar

More information

  • Booking

Other events

  • In category "Webinar"
  • By Cathie Marsh Institute for Social Research

Tables were introduced into Excel in 2007 but are still not that commonly used. Perhaps because casual users think they are using tables all of the time, after all their data is in rows and columns? The advantages of using tables is not well advertised. There are in fact many benefits of using tables in Excel, some may seem cosmetic such as maintaining column names when you scroll down but there are some more useful benefits such as allowing complete data validation on data input and being able to join tables without the need for lookup functions.

Pivot tables are possibly more used than tables but often only for relatively simple data summarisations. Additionally, they can be used to find unique (or non-unique) values and provide basic statistics and, as we can now easily join tables, what about a pivot table using multiple tables?

This free webinar, organised by the UK Data Service, will demonstrate all of the above and more.

The webinar will last for 1 hour with 15 minutes for questions and answers at the end.

Speaker: Peter Smyth, University of Manchester

Book a place at https://www.ukdataservice.ac.uk/news-and-events/eventsitem/?id=5735

Price: Free

Travel and Contact Information

Find event

Online

Contact event

Gill Meadows

gillian.meadows@manchester.ac.uk

Contact us

  • +44 (0) 161 306 6000

Find us

The University of Manchester
Oxford Rd
Manchester
M13 9PL
UK

Connect with the University

  • Facebook page for The University of Manchester
  • X (formerly Twitter) page for The University of Manchester
  • YouTube page for The University of Manchester
  • Instagram page for The University of Manchester
  • TikTok page for The University of Manchester
  • LinkedIn page for The University of Manchester

  • Privacy /
  • Copyright notice /
  • Accessibility /
  • Freedom of information /
  • Charitable status /
  • Royal Charter Number: RC000797
  • Close menu
  • Home
    • Featured events
    • Today's events
    • The Whitworth events
    • Manchester Museum events
    • Jodrell Bank Discovery Centre events
    • Martin Harris Centre events
    • The John Rylands Library events
    • Exhibitions
    • Conferences
    • Lectures and seminars
    • Performances
    • Events for prospective students
    • Sustainability events
    • Family events
    • All events