# Excel Formulas

## Collection by Excel Tutorial

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.

### Sum Values Between Two Dates Quickly With SUMIFS Formula | Excel Tutorials

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

### How To Use RANK Formula? | Excel Tutorials

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

### How To Sum Data By Weekday In Excel? | Excel Tutorials

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:

### How To Sort Cells If A Cell Is X OR Y AND Z? | Excel Tutorials

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

### How To Sort Blank Data With SUMIF Formula In Excel? | Excel Tutorials

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:

### How To Show Formula Text With FORMULATEXT Function? | Excel Tutorials

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.

### How To Round A Number Down With ROUNDDOWN Formula? | Excel Tutorials

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

### How To Join First And Last Name Quickly In Excel? | Excel Tutorials

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 😎

### How To Highlight Blank Values In Excel With OR Formula? | Excel Tutorials

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

### How To Group Numbers At Uneven Intervals Using VLOOKUP? | Excel Tutorials

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

### How To Group By Numbers Using VLOOKUP Formula? | Excel Tutorials

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

### How To Get The Value Of The First Match In A Range Using A Wildcard? | Excel Tutorials

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:

### How To Get The Number Of Days Between Dates In Excel? | Excel Tutorials

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

### How To Get The Name From Email Address QUICKLY In Excel? | Excel Tutorials

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.

### How To Get The Domain From Email Address? | Excel Tutorials

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

### How To Create Course Completion Status Summary In Excel? | Excel Tutorials

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: