# Excel Formulas

## Collection by Excel Tutorial

105
Pins
•
1.46k
Followers

Learn Excel formulas and functions in this thread, you will get to know about each and every excel formulas of Office 365 or later. This board will be updating every day with new excel formulas and its uses. Follow this board to get to know each and every formulas.

this is the situation when we add a particular data as per the specifications.

As you can tell from the topic itself, this is about RANK Function only.

If you want to calculate the sum total of your earnings or expenditure or anything like that in reference to the weekday, here’s what you can do:

This is the situation when we need to bring the result which is based on a lot of specifications.

You must be wondering what do we mean by SUMIF not blank. It’s obvious to you that SUMIF is a Function but by “not blank” we mean from the situations where the data is blank. To understand the same, here’s an example:

If you want to check on the formula or the function that you used over a data, you can use another function i.e. FORMULATEXT Function.

You May have loads of numbers data with those weird-looking decimals like 123.901, 182.11 etc. Therefore, to reduce those after decimal numbers we have a 2

Let's say, You may have thousands of data with first and last names in excel and then your boss demands to join them in a new column and you scratch your heads and ask yourself "how tf? 🙄", well we covered it for you 😎

This can be used at times when there are a lot of data missing. To understand the same, let’s take an example:

When you are dealing with thousands of data entries, you prefer to have a systematic order😬 in the same. This can be done in one simple way, adding things into groups. This will make the data look more organised📚.

This function is used at the time when we have to categories our data into some systematic order like groups.

When you are dealing with loads of data entries, and you want to find something in particular but you do not remember the whole thing, here’s what you can do:

Has it ever happened to you that you are working on a project and you want to count the total number of days, you were working on the same? But then it

If you want to find out the name from an email address, you have walked into the right place😏. To find the same, all you need is the LEFT Function and FIND Function.

To get the domain from the email address we will use the RIGHT Function, LEN Function, and FIND Function.

When we have a bunch of data entries regarding students and we need to clarify for whether a particular student has completed a course or not, here’s what we can do: