Dear Allstat.
This course notification is for statisticians / data analysts / researchers
who use Microsoft Excel regularly but do not currently know about the speed
and power of PivotTable Reports.
Course: Analysing Data with Excel PivotTables
Venue: Express by Holiday Inn, London Limehouse
Date: 5th July 2010 (9:30am – 3:00pm)
Cost: £295 plus VAT per delegate
Background:
Does your job involve data analysis to create summary reports from lists of
data? Do you regularly use Excel to perform these tasks? Using PivotTables
can save you vast amounts of time in your Excel work. Analyses that may take
a week to perform manually in Excel can literally take minutes with
PivotTables.
The course is extremely hands-on, with delegates following demonstrations
and then working through tasks throughout the course, based on sample data.
The course assumes that the delegate has a working knowledge of Excel. No
previous PivotTable skills are required.
Course Content:
Introduction to PivotTables
Creating a PivotTable
“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
Summary
Booking:
To book your place, please fill in a course registration form (which can be
found at http://www.intrepidata.co.uk/general/CRF.pdf ) and fax back to me
on 0191 477 2320. Delegates will need to bring a laptop with Excel XP, 2003
or 2007 installed.
If you need any further information, please don’t hesitate to contact me.
Best wishes,
Fen
Fen Scott
Statistical Consultant & Excel Specialist
IntrepiData
Tel: 0191 478 2671
www.intrepidata.co.uk
You may leave the list at any time by sending the command
SIGNOFF allstat
to [log in to unmask], leaving the subject line blank.
|