Become an expert at using the key functions and features of MS Excel 2021 with this free online course on Alison.com. Are you looking to take your MS Excel skills to the next level? Are you curious about the new features introduced in Excel 2021? This online course on Excel 2021 is here to satisfy your professional and personal needs to upgrade your proficiency. This course has got everything from identifying the new additions of this version of Excel to the essential functions and formulas that can help you sort and analyze data. Enroll now and keep learning!
| Course Category | Microsoft Excel, Computers & IT (Information Technology) |
| Course Type | Online Learning |
| Course Qualification | CPD Certificate |
| Course Duration | 1.5-3 hours |
| Course Fee | Free |
| Entry Requirements | Like all courses on the Alison Free Learning platform this is a free, CPD-accredited course. A Graduate can choose to buy a certificate or diploma upon successful completion of a course, but this is not required or necessary. At Alison we believe that free education, more than anything, has the power to break through boundaries and transform lives. Alison is the world’s largest free online empowerment platform for education and skills training, offering over 5000 CPD accredited courses and a range of impactful career development tools. It is a for-profit social enterprise dedicated to making it possible for anyone, to study anything, anywhere, at any time, for free online, at any subject level. Through our mission, we are a catalyst for positive social change, creating opportunity, prosperity, and equality for everyone. |
| Career Path | In This Free Course, You Will Learn How To • 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 |
| Course Code | 5022 |
Enrol with Alison today! This free online certificate course teaches you how to use CPR, AED, and first aid to save lives.
Enrol with Alison today! Learn how to give good care to the elderly with the nursing procedures and practices in this free online nursing course.
Enrol with Alison today! Learn the important functions and practices of human resource professionals in this free online diploma course.
Enrol with Alison today! In this free online course, learn how to implement the HACCP Food Safety System in your catering establishment.
