Office 365 - Excel 2019 Expert - Level 2 eLearning Course

Return to category list

About the course

The Office 365 - Excel Expert - Level 2 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 Workbooks

  • Protecting Worksheets;
  • Removing Protection;
  • Protecting Workbooks;
  • Opening Protected Workbooks.

Sharing Workbooks

  • Sharing Methods;
  • Share with People;
  • Uploading to OneDrive
Language
UK
Date last updated
10/29/2019
Duration
2 Hours 44 Minutes
Suitable Devices
  • PC
  • Phone
  • Tablet
Audio is Required
  • Yes
Includes Video
  • No
Downloadable Resources
  • eBook
  • Hints and Tips
Completion Criteria
  • Multiple Choice Assessment
Pass Mark
  • 70% pass mark required
Course Technology
  • HTML5
  • SCORM 1.2
Languages
  • English
Accreditation or Endorsements
  • No
Customisation Available
  • No

This course has a minimum of 25 learner registrations for us to provide a quotation.

Request a quote

Cookies

We use cookies to help make our site easier and better for you. We'd appreciate a quick Accept please, to help us continue these efforts.

You can check out the full details in the Privacy Policy.

Saving, please wait...

Your preferences are being saved. This page will reload with your chosen preference.