New Functions in Microsoft Excel

New Functions in Microsoft Excel 2021


Get to grips with the new functions and features of Microsoft Excel and gain full proficiency in the latest 2021 version, with this complete video and instructor-guided training course. 

The New Functions in Microsoft Excel course has been expertly designed to guide you through Excel 2021’s new functions in the most straightforward way. Split into 10 key modules, you will learn how the UNIQUE, RANDARRAY and SEQUENCE functions work, how to filter data in a range or table, and explore other useful new functions. It also includes guidance on how to use these new functions in data reports.

This practical training course is ideal for those who are already familiar with Excel and wish to learn its latest functions. Enrol today and add a new set of valuable office skills to your resume.

Course Design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

Certificate of Achievement

Endorsed Certificate of Achievement from the Quality Licence Scheme

After successfully completing the course, learners will be able to order an endorsed certificate as proof of their new achievement. Endorsed certificates can be ordered and get delivered to your home by post for only £69.00. There is an additional £10 postage charge for international students.

CPD Certification from One Education

After successfully completing the assessment of this course, you will qualify for the CPD Certificate from One Education as proof of your continued expert development. Certificate is available in PDF format, at the cost of £9, or a hard copy can be sent to you via post, at the cost of £15.


This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an acknowledged lesson. One Education will be able to advise you on any further recognition, for example, progression routes into further and/or higher education. For further information, please visit the Learner FAQs on the Quality Licence Scheme website.

Method of Assessment

To assess your learning, you have to complete the assignment questions provided at the end of the course. You have to score at least 60% to pass the exam and to qualify for Quality Licence Scheme endorsed, and CPD acknowledged certificates. 

After submitting the assignment, our expert tutor will assess your assignment and will give you feedback on your performance.

After passing the assignment exam, you will be able to apply for a certificate.

Why Study This Course

It doesn’t matter if you are an aspiring expert or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an acknowledged certificate attesting to your knowledge.

The New Functions in Microsoft Excel is fully available to anyone, and no previous lessons are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16. 

Course Curriculum

New Functions in Microsoft Excel
Module 01: Introduction and Agenda 00:07:00
Module 02: RANDARRAY 00:04:00
Module 03: UNIQUE 00:05:00
Module 04: SEQUENCE 00:04:00
Module 05: SORT and SORTBY 00:09:00
Module 06: SORT A Practical Example 00:06:00
Module 07: FILTER 00:07:00
Module 08: FILTER A Practical Example 00:08:00
Module 09: Other Useful New Functions 00:15:00
Module 10: Using the New Functions in Reports 00:08:00
Assignment – New Functions in Microsoft Excel 2 days, 11 hours
Order Your Certificate
Order Your Certificate QLS 00:00:00

COPYRIGHT © 2022 One Education

Home Search Cart
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon