Skip to Content

Course Details

Excel 2: Managing Data [1 hour]

Event Description

 

Course dates are in this 1-page PDF - new dates are added throughout the year - http://go.qub.ac.uk/trainingschedule

The course can be offered for your unit/area if there are 6 or more delegates. Materials at http://go.qub.ac.uk/itdocs

Continuing from Excel 1: Essentials, this course looks at how to arrange and display both numeric and non-numeric data in Excel to present it in a meaningful manner. Participants will learn about a variety of techniques which can be employed to make spreadsheets more comprehensible, such as sorting, basic and advanced filtering, conditional formatting and custom number and date formats. Excel Tables and the new data bars, colour scales and icon sets, which can be used for conditional formatting, are among the features new to Excel that will be explored in this course.

COVID 19 Restrictions

Due to Covid-19 restrictions face-to-face training can no longer be offere at this time. The course will take the following format:

  • A 1 hour on-line training session via MS Teams
  • Post-session: Participants will be provided with access to a workbook and associated files, to complete asynchronously
  • A follow-up online clinic to address any queries/questions related to topics covered during the session
  • Additional topic specific resources (see link below) can be accessed as required

Additional Resources

This collection of resources can be accessed via LinkedIn Learning, an online learning resource for staff.  New users will need to complete the LinkedIn Learning sign up here.

Excel 2: Managing Data


Aims/Aimed at

Staff who wish to learn how to use Excel to store and display data and those hoping to take the ECDL Advanced module in Spreadsheets.

Pre-requisites

Previous attendance at Excel 1: Essentials or a similar level of experience of using Excel.


Booking Information

Book via iTrent


Booking URL:

http://www.qub.ac.uk/qol

Course Contact Details

Name: IT Training and Assessment Unit
Telephone: 6189
Email: itcourses@qub.ac.uk
New Course: No
Course Type(s): Spreadsheets - Continuing Professional Development
Staff Categories: All Staff
Keywords: Excel, Spreadsheets, Managing Data, Cell Formats, Number Formats, Date Formats, Filtering, Formatting, Conditional Formatting, ECDL Advanced