MOS Excel 2019 and 365 Expert

Course code: DLC022
Industry recognised MOS certification
Selected Discounted 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.
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
  • 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