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.
Having trouble Logging In? Get in touch
Sign Up
Log In
Beginner Level
Excel 2021 avanzado
37,746Learners already enrolled
1.5-3 Avg Hours
CPD Accredited
Excel 2021 avanzado
Conviértase en un experto en el uso de las funciones y características clave de MS Excel 2021 con este curso en línea gratuito en Alison.com.
¿Quieres llevar tus habilidades de MS Excel al siguiente nivel? ¿Tiene curiosidad por conocer las nuevas funciones introducidas en Excel 2021? Este curso en línea sobre Excel 2021 está aquí para satisfac... ¿Quieres llevar tus habilidades de MS Excel al siguiente nivel? ¿Tiene curiosidad por conocer las nuevas funciones introducidas en Excel 2021? Este curso en línea sobre Excel 2021 está aquí para satisfacer sus necesidades profesionales y personales para mejorar su competencia. Este curso lo incluye todo, desde la identificación de las nuevas incorporaciones de esta versión de Excel hasta las funciones y fórmulas esenciales que pueden ayudarlo a ordenar y analizar los datos. ¡Inscríbase ahora y siga aprendiendo!
COURSE PUBLISHER -
What You Will Learn In This Free Course
- Examine the key behaviours known as...
- Identify the key differences betwee...
- Describe the role of the SORT funct...
- Explain how to use the SORTBY funct...
- Examine the key behaviours known as ‘arrays’ and ‘spills’ and how to properly apply them in MS Excel 2021
- Identify the key differences between unique and distinct values along with their usage with multiple criteria and columns
- Describe the role of the SORT function and how to apply it in the proper manner
- Explain how to use the SORTBY function in Excel, particularly the horizontal Sort aspect
- Examine the use of the SEQUENCE function and how to unstack records from the source data
- Describe the use of the FILTER function in Excel 2021 along with various logic aspects
- Explain the use of RANDARRAY and RANDBETWEEN functions in Excel 2021 and how they can be applied to randomize data
- Describe the application of two-way LOOKUPS, XLOOKUP and XMATCH functions to perform complex lookups
- Identify the difference between the CHOOSE and SWITCH functions to sort out source data
- Examine the use of statistical functions such as means, median and mode in Excel 2021 to perform calculations
- Explain how to rank and find the largest/smallest values present within the source data through various functions
- Describe how to apply the rounding off and aggregate functions in Excel 2021
![]()
Knowledge & Skills You Will Learn
Knowledge & Skills You Will Learn No internet? No problem! Download any course on the Alison App and learn on the go. 📲 Download Courses & Learn Without Internet Coming soon to iOS
Complete This CPD Accredited Course & Get Your certificate!
![]()
Certify Your Skills
A CPD accredited Alison Diploma/Certificate certifies the skills you’ve learned![]()
Stand Out From The Crowd
Add your Alison Certification to your resumé and stay ahead of the competition![]()
Advance in Your Career
Share your Alison Certification with potential employers to show off your skills and capabilities
Learner Reviews & Feedback For Excel 2021 avanzado
[The Alison Education Foundation is changing the world from darkness to light and building people to be prepared for knowledge] Let's all get up to education!
The best advanced course that helped me to start thinking like data Analyst Pro
Vera P. ![]()
Alison Graduate
Alison Graduate It was a great course.
Thanks for your effort. It helped a lot to understand new functions.
Kinda hard to learn them all but once, you apply them, it is fun to do it all over again based on my experience :D
View 28 More Reviews
Back to course information
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 Plan