Microsoft Excel 2007 Advanced Function Writing

This course is designed for intermediate/advanced Microsoft Excel professionals who may work or be interested in the domains of finance, statistics, project analysis, market analysis or general data manipulation.

Delegates will learn how to:

• Review topics covered on prior courses
• Work with IF and related functions with IF in their name
• Nest functions together, not just nested IFs
• Work with array functions
• Calculate with both nested and array combined functions to maximise your formula
• Manage and manipulate date and time functions in a spreadsheet
• Control text values with text related functions
• Use a variety of lookup and reference functions
• Manage rounding of values with various functions
• Work with some basic statistical analysis functions

Overview

In Microsoft Excel 2007 courses: Level 1 and Level 2, you would have learnt to write formulas and functions to perform calculations using a variety of techniques. This course takes function writing to the next level and teaches you many more functions within Microsoft Excel 2007. It introduces you to additional keyboard commands, shortcuts and features related to writing functions.

The target students for this course are people who want to get the most out of their data by learning various analysis functions. Whether you are an account manager, an IT worker or someone who needs to regularly manipulate Microsoft Excel 2007 worksheet data, this course will show many functions and their capabilities.

You will use the advanced features of Microsoft Excel 2007 to attain a high degree of proficiency as an Excel power user within the area of writing functions.