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

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

Request a Quotation
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
Can be customised
  • No
Accreditation or Endorsements
  • No
Languages
  • English
Image of a SkillStation dashboard

Let's get started

with a demo and a 30-day free trial.