array(3) {
  ["banner_text"]=>
  string(305) "
Want to get to grip with apprenticeships? Download the latest free whitepaper and playbook here.

"
  ["background_colour"]=>
  string(7) "#19072d"
  ["link_colour"]=>
  string(7) "#f7eefd"
}

Want to get to grip with apprenticeships? Download the latest free whitepaper and playbook here.

DIGITAL, DATA AND IT PROFESSIONAL QUALIFICATION

Microsoft Excel 2019

Start your prep for the MO-200 exam with the Microsoft Excel 2019 course and lab. The lab is cloud-based and device-enabled, making it easy to use. 

The Microsoft Excel certification course and labs thoroughly cover the MO-200 exam objectives and provide the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. The study guide provides hands-on learning on the basic and advanced concepts covered in the Microsoft Excel certification exam.  

This course is for anyone preparing to take MO-200 exam, as the content guides you through topics which will be covered within the exam. Throughout the course material you are supported with over 200 flashcards and over 250 quizzes to aid in solidifying your learning and development. 

Lab features

  • Flexible alternative to physical Labs
  • Comes with well-organized component library for every task
  • Highly interactive lab, allowing user to learn by doing
Enquire

At a glance

Professional Qualification

Type

Professional Qualification

Standard

Microsoft Excel

Format/Modality

Virtual delivery

Duration

12 months access, 60 – 120 hours of learning

Nationwide

Geography

Nationwide

Cost

£400

Add to cart accept
Add to cart
banner

LEARNING TOPICS

Learning journey

  • This course begins with a pre-assessment. It will identify how much you know about a topic and any possible areas of improvement before you start learning.

  • Introduction
  • Fundamentals
  • Creating worksheets
  • Formatting
  • Manipulating data

  • Charts
  • Output
  • Settings and templates
  • Managing workbooks

  • Named ranges
  • Tables
  • Summarizing data
  • PivotTables

  • After completion of the course, you’ll have a short Post-Assessment to measure your achievement

Course includes

  • Over 280 knowledge quizzes
  • Over 200 flashcards
  • 100+ video tutorials

Learning outcomes

For Employers

Employees preparing for the MO-200 can prepare to their best ability as well as gain basic and advanced skills and knowledge. With the help of various delivery methods, employees with different learning styles will be able to digest and apply the learning content.

For Learners

On completion of this course, you will have the knowledge and confidence to take the MO-200 exam. As you go through basic concepts such as worksheet creating and formatting and move into more advanced formulas and complex topics like error trapping, you will be able to use excel to manage and manipulate data as needed, with ease.

digital data and it
Ready to develop new excel and data skills? Purchase this course

Related products

You might also like these

CompTIA Cyber Security Analyst

Gain the skills required to pass the CompTIA CySA+ certification exam with the CompTIA Cybersecurity Analyst (CySA+) course and lab. The lab is versatile and delivers a hands-on experience, replacing expensive physical labs. . Gain the skills required to pass the CompTIA CySA+ certification exam with the CompTIA Cybersecurity Analyst (CySA+) course and lab. The lab is versatile and delivers a hands-on experience, replacing expensive physical labs. ... Read More Read Less

  • <p>Virtual delivery</p> Virtual delivery
  • <p>12 months access, 60 – 120 hours of learning</p> 12 months access, 60 – 120 hours of learning
  • Nationwide Nationwide
Learn more
ITIL 4 Foundation

Start your prep for the ITIL 4 Foundation exam with ITIL 4 Foundation course. This course exam objectives and helps you understand the key concepts of service management, how the ITIL guiding principles can help an organization and the four dimensions of service management.. Start your prep for the ITIL 4 Foundation exam with ITIL 4 Foundation course. This course exam objectives and helps you understand the key concepts of service management, how the ITIL guiding principles can help an organization and the four dimensions of service management.... Read More Read Less

  • <p>Virtual delivery</p> Virtual delivery
  • <p>12 months access, 40 – 80 hours of learning</p> 12 months access, 40 – 80 hours of learning
  • Nationwide Nationwide
Learn more
Microsoft Project 2021

Learn how to effectively manage your projects through the basics of Microsoft Project capabilities. . Learn how to effectively manage your projects through the basics of Microsoft Project capabilities. ... Read More Read Less

  • <p>Virtual delivery</p> Virtual delivery
  • <p>12 months access, 60 – 120 hours of learning</p> 12 months access, 60 – 120 hours of learning
  • Nationwide Nationwide
Learn more
CompTIA ITF + IT Fundamentals

Gain hands-on experience to pass the CompTIA IT Fundamentals exam with this self-directed course and lab. . Gain hands-on experience to pass the CompTIA IT Fundamentals exam with this self-directed course and lab. ... Read More Read Less

  • <p>Virtual delivery</p> Virtual delivery
  • <p>12 months access, 40 – 80 hours of learning</p> 12 months access, 40 – 80 hours of learning
  • Nationwide Nationwide
Learn more

Explore our full programme offering. View all programmes