MOS Excel 2019 and 365 Expert

Course code: DLC022
Industry recognised MOS certification
Scroll to section...
Enrol Now
Course Overview
Course Content
Extra Info
Q&As
Discounts on Selected Courses
The offer has expired
Days Hours Minutes Seconds

For those who want to advanced knowledge of using Microsoft Excel, this course teaches all you need to know about the components of Excel…

  • Boost your CV with vital Microsoft Excel skills that employers look for
  • Expert knowledge in the advanced aspects of Excel
  • Industry recognised MOS certification
  • Valuable skills needed for preparing for the MOS exam
  • Learn how to create advanced formulas and macros
  • Manage advanced charts and tables
  • Access to GMetrix range of MOS exam practice questions
  • Online Excel course
  • Need to have Microsoft Excel 2019
This course is only available to study online.
Speak to an adviser
Course Overview

Impress your current or future employers with expert skills in Microsoft Excel. This course will help you stand out from other candidates or get you the promotion you need!

For those who use Excel regularly but want a more in depth, expert knowledge in Excel, our MOS Excel 2019 Expert course is perfect to help you understand a more skilled approach to using the programme.

Become fully skilled in using Microsoft Excel and choose to sit an exam to receive the full qualification.

Study for this course online and study whenever, wherever you want.

Course Duration

Up to 1 year.

Study Hours

Approximately 80 hours.

Course Outcome

You will be exam ready for your MOS Excel Expert exam.

Entry Requirements

You will need to have Microsoft Excel 365 or 2019.

Assessment

Tutor Marked Assessments.

Course Content
Unit 1
Manage Workbook Options & Settings
  • Introduction
  • Managing Workbooks
  • Preparing Workbooks for Collaboration
  • Using and Configuring Language Options
  • Lesson Review & Quiz
  • Assignment 1 – Workbook Options & Settings Exercises
  • Introduction
  • Fill Cells Based on Existing Data
  • Formatting & Validating Data
  • Advanced Conditional Formatting & Filtering
  • Lesson Review & Quiz
  • Assignment 2 – Custom Data Formatting Exercises
  • Introduction
  • Performing Logical Operations in Formulas
  • Lookup Data Using Functions
  • Using Advanced Date & Time Functions
  • Performing Data Analysis
  • Troubleshooting Formulas
  • Creating & Modifying Macros
  • Lesson Review & Quiz
  • Assignment 3 – Advanced Formula Exercises
  • Introduction
  • Creating & Modifying Advanced Charts
  • Creating & Modifying Pivot Tables
  • Managing Pivot Tables
  • Create & Modifying Pivot Charts
  • Lesson Review & Quiz
  • Assignment 4 – Advanced Table & Chart Exercises
  • The MOS Examination
Extra Info

Course Requirements

You must have Microsoft Excel 2019 in order to complete this course. The course covers the use of either Microsoft Excel 2019 or 365 which is a pc version of the software.

It will be possible to view the course materials using an Apple Mac although the information within the course will be specific to the PC version of Microsoft Office which will differ from Mac versions.

Course Duration

You will have up to 1 year to complete your course, which allows you to study in as much or as little time as you like. The course will take approximately 80 hours of study time but you don’t have to stick to this.

Study Method

Your course will be studied online, through an online training portal so you have access to your course materials all in one place. You will have access to your personal tutor support throughout your course through email, so help is available at any point.

GMetrix Skills Management System is also included in your course, which will allow you to practice for your exam effectively.

Overview of test features

  • Practice tests map to the Microsoft Office Specialist (MOS) exam objectives.
  • All tests are in-application or performance-based simulations to provide the best assessment of real-world experience.
  • All tests have both a testing and a training mode providing step-by-step help on each question.
  • Progress at own pace, save test to resume later, return to skipped questions.
  • Detailed, printable score report highlighting areas requiring further review.

Assessment

For your assignments, you will need to edit and create various Excel files to present your understanding of the course. You will need to submit your assignments online to your tutor. These will be marked and returned to you with feedback.

This course prepares you for the official Microsoft Office Specialist (MOS) Excel Associate MO-201 exam. If you want to take the exam to receive the full official qualification, you will need to book and pay for this separately.  They must be sat at a registered Certiport Testing Centre.

Course Outcome

On successful completion of this course, students will receive a Certificate of Completion with feedback from their tutor. Students can also apply for the Microsoft Office Specialist (MOS) Excel Expert MO-201 exam.

Progression

Proficiency in Microsoft Office products, and Excel in particular, is increasingly important in today’s competitive business environment and, whether students are currently employed or a job seeker, Microsoft Office Specialist certification proves to employers and prospective employers that they have the necessary skills to become an important member of their team.

Q&As

If you want to receive the full official qualification, you will need to sit an exam. This will need to be booked and paid for separately by you. Examinations must be sat at a registered Certiport Testing Centre.

  • Dedicated personal tutor support
  • Dedicated student support
  • GMetrix Skills Management System
  • Assignment marking and feedback
  • FREE CV writing service
  • FREE employability guide to help you impress future employers
  • FREE TOTUM card (formerly NUS)

If you want to sit the exam, this will need to be booked and paid for separately by you.

That's not a problem. We want to make sure you’re 100% confident about enrolling on the course and starting your study. So, just give our Student Adviser Team a call on 03300 563 100 and they’ll do their best to help.

Enrol now

If you are interested in and you’re looking for a more flexible approach to learning that fits around your life - this is the ideal course for you. Enrol online today by clicking below or speak to one of our advisers for more information.

Enrol on this course