Course overview
By the end of this module you will have an understanding of some of Excel's logical and financial functions, use the function wizard, audit and trace your formulae, and use conditional formatting.

Who should attend
Delegates should feel confident in the topics covered in the Microsoft Excel Basic Formula module.

Learning outcomes
At the end of the module, you will be able to:
• Use functions in spreadsheets to perform core business calculations by selecting the most effective method
• Review how to get help using the function wizard to locate and select functions
• Solve the need for a specific outcome by use of goal seek and adjusting formula dependents to generate a target value
• Practice worksheet auditing, tracing errors and evaluating formulae, to determine accuracy and currency of data
• Apply formatting depending on multiple data conditions to display information for maximum impact and analysis

Course contents
Entering functions
Logical functions, e.g. nested IF, AND, OR
Financial functions, e.g. PMT, FV
Lookup functions, e.g. VLOOKUP, HLOOKUP
Understanding how to calculate with date functions

Using function wizard and help
Using function wizard to create nested functions
Getting help on functions

Using goal seek
Adjust formula dependents to reach a target value

Auditing formulas
Tracing precedents and dependents
Tracing errors
Creating comments
Evaluating formulas

Using conditional formatting
Formatting worksheet data conditionally
Creating multiple conditions

Home

© Alpha Training | Telephone 020 8658 6994 | Email admin@alphatraining.com