Programme for
2014/15

Programme for 
2013/14

Course Details

Introduction to PivotTables using Excel 2010 [3 hours]

Event Description

Date

Wed 19 Nov 2014

Time

09:30 - 12:30

This is a half day course that includes a presentation and a variety of practical exercises. This is an advanced course aimed at staff who are experienced at using Microsoft Excel 2010 and are interested in finding out more about PivotTables and PivotCharts. PivotTables are a popular Excel tool for dynamically exploring and analysing large datasets in order to summarise data and make informed decisions. PivotCharts are interactive charts that can be used to visualise PivotTable reports to convey information about patterns and trends within the data. PivotTables can take their source data from within Excel or from external sources like databases, Online Analytical Processing (OLAP) cubes and text files, and allow users to analyse data without altering the original data source. This course will provide participants with an introduction to PivotTables and will include topics such as adding and removing fields, applying styles, filtering data, changing field settings and creating PivotCharts.


Aims/Aimed at

Staff who are experienced at using Microsoft Excel 2007 or 2010 and are interested in finding out more about PivotTables and PivotCharts.

Pre-requisites

Participants should have completed Excel 1: Essentials before attending this course or should have significant previous 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, PivotTables and PivotCharts, OLAP Cubes, Large Datasets, ECDL Advanced

Course Contact Details

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