When autocomplete results are available use up and down arrows to review and enter to select. Touch device users, explore by touch or with swipe gestures.

# Excel Formulas

## Collection by Excel Tutorial

121
Pins
•
2.66k
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.

If you have two timings⏳ in your screen and you want to calculate the difference between them or in other words you want to calculate...

When you have a bunch of dates and all you need is to get the month out of it, here’s what you can do:

When you want to find a particular data, which has some sort of specifications but you have loads and loads of data in your hand so it becomes kind of difficult, you have come to the right place.

When you are weak in math, even a cube root becomes a huge deal🙅! So, to find out the cube root🤓 of a number in...

If you are looking for a way where you could convert feet and inches into inches through excel, you have come up in the right...

To calculate the total number of rows in a range, here’s what we can do:

To calculate the percentage variance in excel, let’s take an example for the same.

In this space, we will learn how to count data that ends with a particular value e.g. RSVPUP-12-P, here, P is the ending value of...

If you want to count the unique values in a range, you can do the same with the help of SUMPRODUCT Function and COUNTIF Function.

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📚.

When you have a proper detailed or systematic requirement regarding some data, this how you can categorize the same🤓🤔: The example above will give you...

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.

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:

Pad text to equal length: When we are dealing with loads of cells which have data filled in it, we observe that due to the length of different data’s (or characters together) they seem very inappropriate.

VLOOKUP is very handy When you have a particular data in hand, and you need to find something in relation to it, it becomes nearly...

As you can tell from the topic itself, this is about RANK Function only. Ranking is an aspect which is very important for a person...