Managing and navigating worksheets In the first session we look at how to use the keyboard to move around and between the worksheets that make up a typical Excel file. The session also covers naming, moving, copying, inserting and deleting worksheets

Working with rows and columns Individual rows and columns on a worksheet - or groups of rows and columns - can be formatted to the user's requirement, moved, copied or completely hidden.  

Formatting cells This sessions covers the formatting of individual cells and cell ranges. We look at changing fonts and alignments - as well as adding borders, patterns and comments

Sorting data Sorting data in Excel is quick and simple - provided that your data is arranged in a clearly defined table

Creating and using formulae Excel can carry out powerful, complex calculations very quickly but in this session we cover the construction of simple formulae using standard mathematical operators

Relative and absolute cell references One of the most valuable aspects of Excel formulae is their ability to use both relative and absolute (with $ signs) cell addresses. This session explains how they work

Excel's functions - numerical and text Excel has a huge number of inbuilt functions that work with either text or numerical data. We look at some of the more useful ones

Locking rows and columns, and splitting screens If the data on your worksheet occupies more than a screen, you may want to lock rows or columns so that they remain visible as you scroll across or down the worksheet. This session shows you how

Using keyboard shortcuts As an alternative to the mouse, you can use these keyboard shortcuts (using the Ctrl key) to enter data and navigate the worksheet - and perform many other actions.  

Printing worksheet contents At some stage you'll want to print out the contents of your worksheet(s). Excel provides a range of tools to help you control what's printed - and how it appears

Creating charts and graphs Excel has a powerful inbuilt graphing and charting system.  In this session we use the "Chart Wizard" to create column, scatter and pie charts

Linking spreadsheets Sometimes you'll want to create a formula which includes references to cells on other worksheets - either in the same workbook (file), or in a different workbook. This session shows how this is done.