|
Course overview
By the end of this module you will be able to choose appropriate formulae
and functions, using wizards where appropriate, audit your formulae, and
use conditional formatting.
Who should attend
Delegates should feel confident in the topics covered in the Microsoft
Excel Basic Formulas module.
Learning outcomes
At the end of the module, you will be able to:
• Investigate and 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
• Choose 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
Related courses
Creating
and Editing
Worksheets
and Workbooks
Basic Formulas
Charts
Linking
Spreadsheets and Formulas
Sorting
and Filtering Data Lists
Summarising
Data Lists
Templates
and Macros
PivotTable
and PivotChart Reports
Home
© Alpha Training | Telephone
020 8658 6994 | Email admin@alphatraining.com
|
