Empower Yourself For Free
Join our community of 45 million+ learners, upskill with CPD UK accredited courses, explore career development tools and psychometrics - all for free.

New Microsoft Excel Functions for 2021
New Microsoft Excel Functions for 2021

What You Will Learn In This Free Course
- Distinguish between the SORT and SO...
- Explain the purpose of RAND, RANDAR...
- Define dynamic arrays and state the...
- List multiple functions used in the...
- Distinguish between the SORT and SORT BY functions
- Explain the purpose of RAND, RANDARRAY and RANDBETWEEN functions
- Define dynamic arrays and state their uses
- List multiple functions used in the creation of management reports
- Describe the use of FILTER and SORT functions to filter and sort data
- Outline the different lookup functions
- Evaluate the different functions to be used in a multi-scenario situation
- Explain the syntax of various functions
Complete This CPD Accredited Course & Get Your certificate!
Certify Your Skills
A CPD accredited Alison Diploma/Certificate certifies the skills you’ve learnedStand Out From The Crowd
Add your Alison Certification to your resumé and stay ahead of the competitionAdvance in Your Career
Share your Alison Certification with potential employers to show off your skills and capabilities
Learner Reviews & Feedback For New Microsoft Excel Functions for 2021






Want to create a customised learning path for your team?
Our dedicated Learning Advisors are here to help you curate a customised learning path tailored to your organisation's needs and goals.
Not sure where to begin?
Discover the career most suitable for you and get started in the field with a step-by-step plan.
Get your PlanMore Free Online Courses by This Publisher
Learners Who Took This Course Also Enrolled In
- Microsoft Excel Formulas and Functions
- MS Excel: Manage and Report with Microsoft Excel (Basic)
- Master the Tricks of Microsoft Excel
- Simplified Microsoft Excel Functions
- Diploma in Microsoft Excel for Beginners and Experts
- Advanced Excel 2021
- Mastering the Basics of Microsoft Excel
- Microsoft Excel Essentials