 # Excel 2019 - Level 5 Formulas and Functions

Regular price
£15.00
Sale price
£15.00
Shipping calculated at checkout.

Seat time: 3 hours

This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to use formulas and functions in Excel including Informational, Logical, Financial, Text functions, data tables and using named ranges.

Modules:

• Formulas and Referencing
• Working with Functions
• Logical and Informational Functions
• More Logical Functions
• Named Ranges
• Financial Functions and Data Tables
• Text Functions

You'll learn:

Formulas and Referencing

• Identify Formula Operators
• Understand Operator Precedence
• Over-ride Operator Precedence
• Enter Formulas
• Copy Formulas
• Use AutoFill
• Update Formula Results
• Use Absolute References
• Apply Percentage Values

Working with Functions

• Identify Function Components
• Enter Functions
• AutoSum Numbers
• Use the AutoSum List
• Use the ROUND Function
• Apply the IF Function

Logical and Informational Functions

• Use the IF Function
• Use the OR Function
• Use the AND Function
• Use Help for Error Messages
• Use Nested IF Functions
• Understand IS Functions
• Use the ISERROR Function

More Logical Functions

• Use the SUMIF Function
• Use the COUNTIF Function
• Use the AVERAGEIF Function

Named Ranges

• Name Cells
• Name Cell Ranges
• Add to and Edit Named Ranges
• Change Range Names
• Use Go To
• Navigate using Cell Names
• Use Names in Formulas
• Display Cell Formulas
• Delete Named Ranges

Financial Functions and Data Tables

• Understand Financial Arguments
• Use the FV Function
• Use the PMT Function
• Use the NPV Function
• Use the Pv Argument
• Use the RATE Function
• Use NPV Function
• Use the Guess Argument
• Use Data Tables

Text Functions

• Understand Text Functions
• Use the CONCATENATE Function
• Use the LOWER Function
• Use the LEFT Function