About the course

The Office 365 - Excel - Level 5 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

You'll 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.