-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
New Functions in Microsoft Excel
New Functions in Microsoft Excel
£29 ex Vat
Take This Course OR
1 Year Access 
Level 2
8 Students -
2 days, 12 hours
get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer
Overview
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
- Video lessons
- Online study materials
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.
Endorsement
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 | |||
| Assignment – New Functions in Microsoft Excel | 2 days, 11 hours | ||
| Order Your Certificate | |||
| Order Your Certificate QLS | 00:00:00 | ||
Related Courses
Intermediate
Intermediate
Intermediate
COPYRIGHT © 2022 One Education
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add