• No products in the basket.



  • 1 Students

  • Certified


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 2021 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

  • Video lessons
  • Online study materials

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.

Why study this course

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

The New Functions in Microsoft Excel 2021 is fully available to anyone, and no previous qualifications 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 2021
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 2021 00:00:00
  • £425.00 £25.00 ex Vat
  • 1 year
  • Number of Units11
  • Number of Quizzes0
  • 1 hour, 13 minutes


Get accredited certificates

New skills

Add skills to your CV


Test your skills

Dedicated Support

for any questions

Set your own speed

Self-paced learning

Enjoy first 7 days free

Start for free

COPYRIGHT © 2021 One Education