Microsoft Excel 2007: Intermediate (1 Day)

Product Description

This course concentrates on developing your existing knowledge of Excel &

Includes:: working with more advanced formulas & functions.

In Microsoft (R) Office Excel (R) 2007: Essentials, you created, edited, formatted, & printed basic spreadsheets. You now have a need to streamline repetitive tasks & display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline & enhance your spreadsheets with templates, charts, graphics, & formulas.

You will learn how to get Excel to make decisions using IF functions & conditional formatting. You'll also learn how to create templates for commonly used worksheets & protect data using the security features.

This course will also enable you to create, build & customise graphs including plotting trend lines, & use Pivot Tables to help analyse data. You need to be using Excel regularly, including writing your own formulas, in order to get the most out of this course.

This training may be available onsite; please contact us if you are interested.