Microsoft Excel - Hints and Tips (Level 3)

Aims

The aim of this course is to show you how to make the best use of some of the facilities in Microsoft Excel and, in particular, to save you time when using it.

Objectives

By the end of the course participants should have learnt tips on:

• Starting Excel
• Customising the screen
• Shortcut keyboard combinations and function keys
• Entering data and cell formats
• Moving around and selecting cells
• Use of the mouse to move or copy data
• AutoFill to extend a series
• Screen layout including wrapping text and freezing panes
• Using colours
• Adding comments
• Cell references - relative and absolute
• Charts
• Printing

Format

1 hour hands-on session on a PC, with further demonstration via overhead projection.