PG Skills: Excel for the Workplace

Location
Murray Learning Centre - Room LG13
Category
Arts and Law, Engineering and Physical Sciences, Lectures Talks and Workshops, Life and Environmental Sciences, Medical and Dental Sciences, Social Sciences
Dates
Wednesday 18th March 2020 (14:00-16:00)
Download the date to your calendar (.ics file)
Contact

University Graduate School (graduateschool@contacts.bham.ac.uk)

Register for this event

Excel can be a powerful and useful tool for day-to-day administrative tasks as well as more complex work-related projects when you know how to use it to your advantage.  A previous attendee said “very informative and useful time-saving tips ideal for in the workplace or for research purposes.”

This hands-on workshop, delivered by Sonia Lee Cooke, Digital and Technology Skills Advisor within Library Services, will teach you several handy tricks to optimise your data and your time as well as enhance your workplace skills.

Please note: you will need to be familiar with the basics of Excel to participate in the workshop. 

Attendees will learn how to:

  • Add your own customised drop-down list to a spreadsheet
  • Utilise IF formulas to specify results for set criteria
  • Use vlookups to locate data in another table
  • Highlight cells of a certain value with conditional formatting
  • Extract and display significant data using pivot tables

Colleges

Professional Services