skip to navigation skip to content
Thu 24 Nov 2016
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:

No more events

[ Show past events ]



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


Booking / availability

Excel 2007: Advanced Part 2
PrerequisitesNew

Thu 24 Nov 2016

Description

This course which is a follow up from the Excel Further Use course, covers some more advanced features of Excel 2007. The course will be taught using Excel 2007 on PCs (Windows XP) but Macintosh users of Excel 2008 should also find it useful.

Prerequisites

This course is intended for those already familiar and confident with using Excel features, such as those covered in the Excel Introduction and Excel Further Use courses. It is expected that course attendees will have attended these courses or have equivalent knowledge.

Sessions

Number of sessions: 1

# Date Time Venue Trainers
1 Thu 24 Nov 2016   09:30 - 13:00 09:30 - 13:00 Phoenix Teaching Room Lynn Foot,  Monica Gonzalez
Topics covered

Excel Advanced Part 1

  • Labels and Names
  • Information Functions
  • Lookup Functions
  • Formula Techniques
  • Summarising Data
  • Data Consolidation
  • Validating Data
  • Conditional Formatting
Topics covered

Excel Advanced Part 2

  • Goal Seek
  • Scenarios
  • PivotTables
  • PivotTable Techniques
  • PivotCharts
  • Recording Macros
Format

Presentations, demonstrations and practicals

System requirements

Excel 2007 on PWF Windows

Notes
  • The course does NOT include writing macros using VBA - see the course Excel Programming Using VBA).
  • Please bring a memory stick if you wish to take away the exercise files; alternatively they can be downloaded from http://www-tus.csx.cam.ac.uk/courses/files/
  • There are also Excel self-taught courses available for loan from the Computing Service.
Duration

One half day session


Booking / availability

Override user: