Course: Data Analysis using Excel PivotTable Reports
Duration: 1 Day
Venue: Newcastle upon Tyne (Quayside)
Date: Thursday 1st December 2005
Cost: 275 pounds plus VAT per delegate
Bookings are now being taken for the above course. Please note that on
this delivery of the course, each delegate will need to bring a laptop
with Excel 2000 or later installed.
Overview
========
This one day course is aimed at current users of Excel who wish to learn
how to manipulate one of the most powerful yet user-friendly tools
within Excel, namely PivotTable reporting.
PivotTable Reports are interactive tables which summarise large amounts
of data very quickly into tabular reports, the structure of which is
defined by the user. Once created, PivotTable Reports are extremely easy
to modify and format.
This course is designed to take the delegate from the basics of
PivotTable report creation through to more advanced topics such as
creating Custom Groupings and Displaying as Percentages.
No previous knowledge of PivotTable reporting is assumed and by the end
of the course, the delegate should be confident in building standard and
customised PivotTable reports.
Course Contents
===============
Introduction to PivotTable Reports
Creating a PivotTable Report
"Pivoting" a PivotTable
Structured Selection
Adding / Removing Fields in a Report
Refreshing PivotTable Data
Customising Fields
PivotTable Formatting
Grand Totals / Totals / Subtotals
Sorting PivotTable Data
Managing the Level of Detail
Custom Grouping
Displaying as Percentages
Course Summary
Course Venue
============
The course is being held at the Premier Travel Inn Newcastle Quayside.
Located on Newcastle's famous Quayside, the venue boasts easy access to
numerous local attractions on both the Newcastle and Gateshead sides of
the River Tyne. Hotel accommodation is not included in the price of the
course, but room rates and availability for the Premier Travel Inn
Newcastle Quayside can be obtained on 0870 990 6530.
Booking
=======
To book a place or places (discounts for group bookings of 2+) on the
course, or for further information, please do not hesitate to contact
me.
Best wishes,
Fen Scott
Statistical Consultant
IntrepiData
0191 478 2671
www.intrepidata.co.uk
This message is for the designated recipient only and may contain
privileged information. If you have received it in error, please notify
the sender immediately and delete the original.
|