Loading

Smashing September Sale - Get 25% Off Certificates and Diplomas! Limited-time Offer - ends Friday, 17th September 2021

Claim My 25% OFF

New Microsoft Excel Functions for 2021

Learn how to use the various new excel functions introduced in office 365 in reports with this free online course.

Publisher: Ross Maynard
This free online course will teach you about the various Excel functions that have been added to Office 365. You will learn about dynamic arrays, their importance in Excel and how to use them. The importance, syntax structure, and numerous examples of functions like RANDARRAY, SORT, FILTER, CONCAT, IF, and SWITCH will be demonstrated. You will also learn to master the skill of creating powerful management reports using Excel. Enrol today.
New Microsoft Excel Functions for 2021
  • Duration

    1.5-3 Hours
  • Students

    566
  • Accreditation

    CPD

Description

Modules

Outcome

Certification

View course modules

Description

Every day, businesses all over the world generate massive amounts of data. This data is useless unless it is sorted and organized in order to extract meaningful information from it. Excel is one of the tools used by businesses all over the world to extract this valuable information and generate meaningful reports. Excel is a powerful tool that is used not only by businesses but also by individuals for personal purposes, such as maintaining and tracking expenses. People who are skilled with this tool are in high demand and have an advantage over those who are not. Excel is a data organization and calculation program. It is capable of analyzing data, computing statistics, creating pivot tables, and displaying data in the form of a chart or graph.


The use of functions is a powerful tool provided by Excel. Functions are mathematical formulas that allow you to perform calculations that would otherwise be difficult to perform by hand quickly and easily. This course focuses on these powerful functions and the reports that can be generated by using them. A function has three basic parts: the ‘=’ sign which signifies the start of the function, the function name and the parameters or arguments. Each of these parts plays an important role in the proper execution of the function. This particular course will focus on functions like RAND, RANDBETWEEN, RANDARRAY, and other functions like SEQUENCE, SORT, FILTER, CONCAT, TEXT-JOIN. The significance, syntax writing, and numerous examples demonstrating the aforementioned functions will be provided. You will learn how the RANDARRAY function simplifies the generation of a random value, as well as how multiple values can be generated. The use of other functions to generate lists, sort complex data as well as filter important information from a pool of data will be demonstrated.


Learning Excel functions makes your work easier and improves the quality of your reports and other information sheets. Excel formulas enable you to accomplish more while saving time. If you know how to use Excel formulas and functions, you can increase your productivity exponentially, whether you are a manager or a new employee. It is also one of the most in-demand skills among employers today. If you want to improve the speed and quality of your work and impress your boss, this is an ideal course for that. Take advantage of this opportunity to master the use of Excel functions. Enrol today.

Start Course Now

Careers