skip to navigation skip to content
Wed 9 May, Fri 11 May 2012
09:30 - 13:00

Venue: Phoenix Teaching Room

Provided by: University Information Services


Booking

Bookings cannot be made on this event (Event is in the past).


Other dates:


May 2012


May 2017


July 2020



Register interest
Register your interest - if you would be interested in additional dates being scheduled.


Booking / availability

Excel 2007: Analysing and Summarising Data (Self-paced)
PrerequisitesUpdated

Wed 9 May, Fri 11 May 2012

Description

This hands-on course is a follow up from the Excel 2007 Introduction course.

Prerequisites

It is essential to be familiar with the basic features of Excel and concepts of spreadsheets, as covered on the Excel Introduction or Excel for Beginners courses or have the equivalent level of knowledge.

Sessions

Number of sessions: 2

# Date Time Venue Trainers
1 Wed 9 May 2012   09:30 - 13:00 09:30 - 13:00 Phoenix Teaching Room E.V. Lilley,  Lynn Foot
2 Fri 11 May 2012   09:30 - 13:00 09:30 - 13:00 Phoenix Teaching Room E.V. Lilley,  Lynn Foot
Topics covered
  • Charts
  • Data Consolidation
  • Pivot Tables/Techniques/Charts
  • Goal Seek
  • Scenario Manager
Format

Presentation, demonstrations and self-paced practicals.

System requirements

Excel 2007 on PWF Windows

Notes
  • The course will be taught using Excel 2007 on PCs (Windows XP) but Macintosh users of Excel 2008 should also find it useful.
  • Anyone wishing to copy the course exercise files should bring a USB memory stick or floppy disk they can be downloaded from, http://www-tus.csx.cam.ac.uk/courses/files/
  • Self-taught courses are also available.
Duration

One half day session

Theme
Spreadsheets

Booking / availability

Override user: