Excel 2007: Further Use PrerequisitesUpdated
Fri 29 May 2009
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: 1
| # | Date | Time | Venue | Trainer |
|---|---|---|---|---|
| 1 | Fri 29 May 2009 09:30 - 13:00 | 09:30 - 13:00 | Phoenix Teaching Room | E.V. Lilley |
Topics covered
- Creating charts
- More advanced formulae and functions
- Linking multiple worksheets and workbooks
- Working with a database (sorting, outlining, subtotalling, filtering)
- Excel workgroup features (protection)
Format
Presentations, demonstrations and practicals.
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/
- There are special Excel courses for Departmental Support Staff: see http://www.admin.cam.ac.uk/offices/personnel/staffdev/list.shtml#it_skills_development or contact Staff Development for details. Self-taught courses are also available.
Duration
One morning or afternoon session.
Booking / availability