Seat time: 3 hours
About the course:
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
- Add Function Arguments
- Use the PROPER Function
- Use the UPPER Function
- Understand TRIM Function