Microsoft Excel is hands-down one of the best tools for people who work with a huge amount of data every morning. It makes managing everything in one place a cool breeze. Moreover, you can use different functions and formulas to solve complex mathematical problems within a few seconds only. But if you are someone who is just beginning with basic excel formulas then you might be wondering about what 10 functions of MS Excel are and how to use them. So, keep on reading to know more.
Table of Contents
10 Functions of MS Excel that Everyone Should Know
If MS Excel is your go-to tool, then you are doing great because it cannot get any better than this. Despite its popularity, there are still a lot of people like freshers who are still struggling with Excel functions and formulas. This article will help you with learning 10 functions of MS Excel so you can make things easier than ever.
Some of the important Excel functions include SUMIF, COUNTIF, CEILING, REPLACE, SUBSTITUTE, NOW, TODAY, MODULUS, POWER.
What are the TOP 10 Excel Formulas?
Let us first take a look at what are the top 10 excel formulas. In simple words, MS Excel formulas are expressions that operate on values within the specified range of cells. Using these formulas, you can easily do so much more than basic subtraction and addition. You can easily use these formulas to carry out big tasks within a few seconds despite the massive amount of data. This sums up what are the top 10 Excel formulas.
Also Read: How to Export Trello Board to Excel
Top 10 Excel Functions
Depending on your requirement, there are plenty of formulas that you can use to execute an operation. Let us take a look at the top 10 excel functions:
This function is used to round up a number to its nearest multiple of significance.
- Number– The value you want to round.
- Significance– The multiple to which you want the number to round up to.
This among the rest 10 functions of MS Excel is the opposite of FLOOR() function. This function rounds a particular number down towards zero to its nearest multiple of significance.
- Number– It is the numeric value you want to round.
- Significance– It is the multiple to which you want to round the number.
This function is used to replace a part of any text string with another text string.
=REPLACE(old_text, start_num, num_chars, new_text)
- Old_text– This is the text in which you wish to replace some characters.
- Start_num– This refers to the position of the character present in the old_text which you want to replace.
- Num_chars– This is the number of characters in old_text that you want REPLACE() to replace.
- New_text– This is the text that will replace characters in old_text.
Also Read: How to Swap Columns or Rows in Excel
Another one of the basic 10 functions of MS Excel is SUBSTITUTE function. It is used for replacing the existing text with a new text in a text string.
=SUBSTITUTE(text, old_text, new_text, [instance_num])
- Text– It is the text in which you want to substitute characters.
- Old_text– This refers to the text you want to replace.
- New_text– It is the new text that will replace the old text.
- Instance_num– This is optional. It merely specifies which occurrence of old_text you wish to substitute with new_text. For instance, if you use instance_num, only that particular instance of old_text is replaced.
This function gives the current system date and time. However, it will change according to the system data and time on your device.
You can use this function to find out the current system date.
Also Read: How to Calculate Z Score in Excel
When a number is divided by a divisor, this function works on returning its reminder.
= MOD(number, divisor)
- Number– It is the number for which you wish to find the remainder.
- Divisor– This is the number by which you want to divide the Number.
This one of the basic 10 functions of MS Excel returns the result of a certain number when raised to a power.
Number– It is the base number which can be any real number.
Power– This is the exponent to which the base number will be raised.
This is used to count the total number of cells within a range that meet the required condition.
COUNTIF(Where do you want to look, what are you looking for)
The SUMIF function adds the values in a range that meet the specified criteria.
Range– This is the range of cells that you want to be evaluated by criteria.
Criteria– This defines the cells which will be added.
Also Read: How to Make Excel File Read Only
Basic Excel Formulas
Now that you know about the top 10 Excel functions, let us move on. Here are a few basic excel formulas that everyone should know to master MS Excel and become a pro.
|SUM||=SUM(A2:A10)||This function gives you the total value of the selected rows or columns.|
|AVERAGE||=AVERAGE(number1, [number2], ….)||This function is to calculate the average of the selected cells.|
|SUBTOTAL||=SUBTOTAL(function_num,ref1,[ref2],…)||It simply returns the subtotal in a database. The output depends on what you want, and you can choose anything from min, max, count, sum, or average.|
|COUNT||=COUNT(value1, [value2], …)||Counts the total number of cells in a range that contains any number. It does not include blank cells or cells with data in a form other than numerical.|
|CONCATENATE||=A2&” “&B2.||This function merges multiple text strings into one text string.|
|LEN||=LEN(text)||LEN () returns the total number of characters in a string including spaces, characters, and special characters.|
|DATEDIF||=DATEDIF(start_date,end_date,unit)||This function provides the difference between two dates in terms of years, months, or days.|
|VLOOKUP||=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])||You can use this function to search things within a table or an array. This is great for search-type situations.|
|HLOOKUP||= HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])||HLOOKUP or horizonal lookup looks for a value in the top row of a table.|
|TRIM||=TRIM(text)||It will remove all spaces from text except for the single spaces between words|
|LEFT||=LEFT(text, [num_chars])||This extracts a specific number of characters from a text string.|
|RIGHT||=RIGHT(text, [num_chars])||The RIGHT function extracts a specific number of characters from a text string.|
|MID||=MID(text, start_num, num_chars)||The MID function is used to extract text from the middle of a text string.|
- What Does Delivery Report Not Requested Mean on Android?
- What are the Default Margins in Google Docs?
- How to Split Excel File into Multiple Files by Row
- How to Subtract Multiple Cells in Excel
We hope this helped you with the 10 functions of MS Excel. Please share your valuable feedback and reviews in the comments down below and let us know what you would like to read next.