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
Hai dimenticato la password?No worries, we will send reset instructions to your email address.
Beginner Level
Excel avanzato 2021
37,765Learners already enrolled
1.5-3 Avg Hours
CPD Accredited
Excel avanzato 2021
Diventa un esperto nell'utilizzo delle funzioni e caratteristiche chiave di MS Excel 2021 con questo corso online gratuito su Alison.com.
Stai cercando di portare le tue competenze in MS Excel al livello successivo? Sei curioso di conoscere le nuove funzionalità introdotte in Excel 2021? Questo corso online su Excel 2021 è qui per soddisfare ... Stai cercando di portare le tue competenze in MS Excel al livello successivo? Sei curioso di conoscere le nuove funzionalità introdotte in Excel 2021? Questo corso online su Excel 2021 è qui per soddisfare le tue esigenze professionali e personali per migliorare le tue competenze. Questo corso include tutto, dall'identificazione delle nuove aggiunte di questa versione di Excel alle funzioni e alle formule essenziali che possono aiutarti a ordinare e analizzare i dati. Iscriviti ora e continua a imparare!
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 avanzato 2021
[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