Excel 2007 for Beginners (self-paced)

Beginners

This self-paced hands-on course gives an introduction to spreadsheets, databases and charting using Excel 2007. There is emphasis on short cuts and other efficient ways of working.

The course is aimed at beginners - no previous knowledge or experience is assumed, but it can also be attended by those who wish to practise under supervision.

Number of sessions: 3

• Entering and amending information
• Formatting, copying and moving cell contents
• Using formulae and functions
• Relative and absolute references
• Searching
• Sorting
• Filtering
• Creating and amending charts
• Creating and manipulating databases

Self-paced hands-on, working from a workbook.

Excel 2007 on PWF Windows

• Participants work at their own pace using a workbook containing notes and exercises.
• Most participants will complete the material in the three timetabled sessions during which help and advice are available. However, the length of time taken will vary according to previous experience, so the facilities will remain available for informal use for a further week after the formal sessions; alternatively the course files can be copied to CD or memory stick (not supplied) so that the exercises can be completed on other machines.
• Downloadable workbook and exercise files
• This course is also available as a self-instruction pack from Computing Service Sales; there are also instructor-led and other self-teach courses on Excel.

Three sessions of two hours

• Excel 2007: Analysing and Summarising Data   [Provided by University Computing Service]
• Excel 2007: Functions and Macros   [Provided by University Computing Service]
• How to Excel with CUFS   [Provided by Finance Training]

• Basic Skills
• Spreadsheets