This course will help you to maximise the investment you make in IT by ensuring you have the skills to exploit the full potential of Excel 2007.

Who is this Excel 2007 course for?

Excel 2007 Intermediate is suitable for experienced computer users who are already confident in the basics of using spreadsheets. This course is appropriate for any business sector and there are no formal entry requirements.

What will you get from this Excel 2007 course?

When you have completed this course, you will be able to:

• Understand the differences between relative and absolute cell referencing

• Use a range of formulae to complete complex calculations

• Work with advanced commands on the format menu

• Use multiple workbooks and create 3D formulae

• Split windows, freeze frames and hide columns when working with large spreadsheets

• Create and format charts to highlight trends

• Publish workbooks as web pages for viewing or collaboration

Excel 2007 Course features

This course provides a comprehensive overview of the more advanced features and functions of Excel 2007.

clear, step-by-step instructions and reproductions of actual Excel 2007 screens, the course shows you how to perform complex calculations, how to create and work with large spreadsheets, how to use charts to highlight trends and how to publish your data on the web.

As you work through the course, you’ll complete a series of practice exercises and work with actual Excel 2007 spreadsheets.

You can start the course straight away and access it at any time, providing you have the use of a computer with an internet connection.

The course is available for six months from the date first accessed.