skip to navigation skip to content
Wed 21 Feb 2018
14:00 - 17:00

Venue: University Information Services, Roger Needham Building, Ely Training Room 2

Provided by: Student Systems


Booking

Bookings cannot be made on this event (Event is completed).


Other dates:

No more events

[ Show past events ]



Register interest
Register your interest - if you would be interested in additional dates being scheduled.


Booking / availability

Excel for CamSIS Users

Wed 21 Feb 2018

Description

Delegates will learn how to use shortcuts in Excel to improve their productivity, and also techniques for analysing complex data quickly by using pivot tables.

Target audience
  • Anyone who needs to process data exported from CamSIS Search
  • Further details regarding CamSIS' eligibility criteria are available

NOTE: Not relevant to students

Sessions

Number of sessions: 1

# Date Time Venue Trainer
1 Wed 21 Feb 2018   14:00 - 17:00 14:00 - 17:00 University Information Services, Roger Needham Building, Ely Training Room 2 map John Hocking
Topics covered
  • Sheet navigation – keyboard shortcuts
  • Changing column width - shortcut
  • Deleting data
  • Formatting data – Dates
  • Formatting data – Text
  • Formatting data –conditional formatting
  • Using and protecting formulae
  • Freezing panes
  • Sorting and filtering
  • Pivot Tables
  • Inserting, colouring and renaming worksheets
Objectives

To be able to:

  • Quickly navigate around an Excel spreadsheet
  • Format the data
  • Sort and filter the data
  • Use Pivot Tables to view the data in a different and clearer way
Aims

To become familiar with shortcuts in Excel, and the use of Pivot Tables for analysing data.

Format

Presentations, demonstrations and practicals

Duration

One half day session

Frequency

Monthly

Themes

Booking / availability