Programme for
2012/13

Course Details

Excel 2: Managing Data [3 hours]

Event Description

 

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. Through a series of practical exercises, 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 2007 that will be explored in this course.


Aims/Aimed at

Staff who wish to learn how to use Excel 2010 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 2007 or 2010.

Booking Information

Book via iTrent
Booking URL: http://www.qub.ac.uk/qol
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

Course Contact Details

Name: IT Training and Assessment Unit
Telephone: 6189
Email: itcourses@qub.ac.uk