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.
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.
|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|
Get accredited certificates
Add skills to your CV
Test your skills
for any questions
Set your own speed
Enjoy first 7 days free
Start for free