Excel 2019 - Level 5 - Formulas and Functions
About the course
The Excel 2019 - Formulas and Functions 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
There are 7 modules in this course
- Formulas and Referencing
- Working with Functions
- Logical and Informational Functions
- More Logical Functions
- Named Ranges
- Financial Functions and Data Tables
- Text Functions
Course features
- Simulation training replicates the software you are learning providing a realistic learning experience.
- Learn how to perform tasks at your own pace and interactively by following easy step-by-step actions.
- Reinforce your knowledge at the end of each lesson by completing interactive and multiple choice quiz questions.
- Assess your skills at any time by undertaking the Course Test.
- Lessons can be completed within 30 minutes so training can be undertaken in 'bite' size pieces.
- Bookmarking allows you to learn in multiple training sessions.
- Course navigation features allow you to jump directly to specific topics of interest quickly and easily.
- Designed for people who require initial and refresher training activities.
- Available on-line 24 hours a day.
- Version for Mobile Devices.
- Review course content with eBooks
Youll learn how to:
Formulas and Functions
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