Introduction to PivotTables using Excel
Event Description
This is an advanced course aimed at staff who are experienced at using Microsoft Excel 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.
We will continue to offer online training at this time. This course will take the following format:
- A demo of the main features. Check available dates and book a place from this link: IT Training Course Schedule
- Course participants access a workbook and associated files here
- 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.
Aims/Aimed at
Staff who are experienced at using Microsoft Excel 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.
Booking Information
Book via iTrent
Booking URL:
Course Contact Details
Name: IT Training and Assessment UnitTelephone: 6189
Email: itcourses@qub.ac.uk
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