Excel 2007: Analysing and Summarising Data (Self-paced) PrerequisitesUpdated
Wed 10 May, Fri 12 May 2017
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 10 May 2017 09:30 - 13:00 | 09:30 - 13:00 | Phoenix Teaching Room | E.V. Lilley, Lynn Foot |
| 2 | Fri 12 May 2017 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