Excel 2007 (Spreadsheet Package): Introduction
Mon 22 Sep 2014
Description
Microsoft Excel is the chosen spreadsheet package as it is a popular choice, both on Macintosh and PC.
Prerequisites
Basic computing skills i.e. equivalent knowledge attained from attending the Windows Essential Basics (Level 1) and Windows File Handling and Desktop Skills (Level 2).
Sessions
Number of sessions: 1
| # | Date | Time | Venue | Trainers |
|---|---|---|---|---|
| 1 | Mon 22 Sep 2014 09:30 - 13:00 | 09:30 - 13:00 | Phoenix Teaching Room | E.V. Lilley, M. ten Wolde |
Topics covered
- Building a new workbook (data entry and formulae)
- Modifying an existing workbook
- Worksheet shortcuts (AutoFill, copying and moving cells, inserting and deleting rows and columns, AutoSum)
- Enhancing the appearance of a worksheet
- Enhancing printed output
- Controlling worksheet display
Format
Presentations, demonstrations and practicals.
System requirements
Excel 2007 on PWF Windows
Notes
- This course will be taught using Excel 2007 on PCs (Windows XP) but Macintosh users of Excel 2008 should also find it useful.
- Charts are NOT covered - they are dealt with in the Excel Further Use course.
- Anyone wishing to copy the course exercise files should bring a USB memory stick or 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 half day session
Theme
Spreadsheets
Booking / availability