More Information - MS Excel 2007 Intermediate

MS Excel 2007 Intermediate

Course cost (excl vat) £39.90
valid for 6 months

Introduction

From producing a professional-looking Financial Statement to using charts and graphs to spot sales trends at a glance, the tools within Excel 2007 can give businesses a far clearer view of how things look now and how they might look in the future.

This course will help businesses to maximise the investment they make in IT by ensuring staff have the skills they need to exploit the full potential of spreadsheet software.

Who is the 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 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

Course features

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

Featuring 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.