Excel 2007: Managing Data & Lists (Self-paced)

Prerequisites

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

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.

Number of sessions: 1

• Sorting
• Filtering
• Grouping and Outlining
• Summarising
• Formula Referencing
• Conditional Formatting
• Validating Data
• Protecting Data
• Comments

Presentation, demonstrations and self-paced practicals.

Excel 2007 on PWF Windows

test

• 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/

One half day session

• Orientation Tour   [Provided by Cambridge University Library]