About the course
The Excel 2019 - Expert ? Advanced Functions, Consolidating and Auditing course covers topics included in the MOS Expert exam 77-728. This includes using Logical, Informational, Time, Mathematical and Lookup Functions. You will also learn how to Consolidate workbooks, Share and Protect workbooks and use Auditing tools.
Modules
There are 7 modules in this course
- Logical and Informational Functions
- Time and Mathematical Functions
- Lookup Functions
- Consolidating Workbooks
- Auditing Tools
- Protecting Workbooks
- Sharing Workbooks
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:
Advanced Functions
Logical and Informational Functions
- IF Function;
- OR Function;
- AND Function;
- Help for Error Messages;
- Nested IF Functions;
- IS Functions;
- ISERROR Function.
Time and Mathematical Functions
- Using Functions;
- Insert Function Box;
- TODAY Function;
- Displaying Dates as Numbers;
- DAY Function;
- MONTH Function;
- YEAR Function;
- COUNT Function;
- COUNTA Function;
- COUNTIF Function;
- SUMIF Function;
- AVERAGEIF Function;
- ROUND Function;
- Nesting Functions;
- Circular Functions;
- Iterative Calculations
Lookup Functions
- VLOOKUP Function;
- Creating Lookup Tables;
- Inserting Functions;
- VLOOKUP Arguments;
- LOOKUP Function;
- Modify Lookup Data;
- HLOOKUP Function
Consolidating and Auditing
Consolidating Workbooks
- Consolidating Data;
- What is Consolidation?
- Selecting Destination Area;
- Consolidating Workbooks;
- Creating Links;
- Updating Linked Data;
- Outlining Features.
Auditing Tools
- Using Auditing Tools;
- Trace Precedents;
- Trace Dependents;
- Removing Tracer Arrows;
- Tracing Errors in Formulas;
- Correcting Formula Errors.
- Viewing Formula Locations;
- Show Formulas.
Protecting and Sharing Workbooks
- Protecting Worksheets;
- Removing Protection;
- Protecting Workbooks;
- Opening Protected Workbooks.
Sharing Workbooks
- Sharing Methods;
- Share with People;
- Uploading to OneDrive