Top Excel Functions You Need to Now in 2021
Using a spreadsheet software like Microsoft Excel has been a part of virtually everyone working in any business office since the 1990’s. Even then, people who knew some of the more advanced functions were able to stand out from their peers and performed better. In this article we will discuss some of the essential functions you need to know to truly unlock the power of Excel in 2021, which can be used not only for work-related matters, but also when doing your personal finances or even managing your stats when placing online bets at websites like www.casimba.com/en-gb/.
Obviously, the functions mentioned below aren’t for people who already have a vast knowledge of the application, instead, it will cover the basics and a few additional features recently added by Microsoft.
IF function
One of the simplest but very useful functions, the IF function will allow you to compare two values using logical arguments (such as greater than, equals, et cetera) and receiving an output based on its logical result (true or false).
This is the syntax for the IF function:
=IF(logical argument,value if true,value if false)
SUM function
The SUM function is quite straightforward, it adds all numerical values contained in the selected cells and provides an output of it, and it’s usually one of the first functions people learn when they study Excel. You can also insert other mathematical symbols within it so that you can have the final calculation done on a single formula.
The syntax for the SUM function is:
=SUM(number1,number2,…)
SEQUENCE function
This function might not look very useful, as it only creates a list of numbers that progress based on your inputs. It can, however, become a powerful tool when combines with other functions, such as IF or XLOOKUP. If the parameters are left blank, then everything will be set to one and will increment itself by one as well.
The syntax is:
=SEQUENCE(number of row, number of columns,starting number, step size)
CONCAT function
The purpose of the CONCAT function is to join, i.e. concatenate all the inputs you have selected. It is very simple and easy to use. For example, if you have a list of first and last names, this function will result into a list of full names for you.
See below the syntax for the CONCAT function:
=CONCAT(input1,input2,…)
If you want to have space characters in between each element, then you should write the function like this: (input1,” “,Input2).
XLOOKUP
If you have studied a bit of excel in the past you have probably heard of the VLOOKUP function, which has extensive use specially to, as the name implies, look up data in large data arrays and fill up forms based on a single value. Nowadays, Microsoft has implemented the XLOOKUP function, which covers both the former separated VLOOKUP and HLOOKUP functions, simplifying the entire process and saving computer resources.
The syntax is as it follows:
=XLOOKUP(Lookup value,lookup array, return array,error message)
Related Articles
