Excel Tutorial

Learn And Become Excel Pro with our range of excel tutorials featuring basics, Excel Formulas, Excel Pivot Tables, Power Query, Power BI, Analysis, Excel Macros

Excel Tutorial's best boards

More ideas from Excel Tutorial

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.

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:

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

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.

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.

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:

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:

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.

To convert the timestamp into time, we need to use two functions for it, i.e. the TIME Function and the MID Function.

To convert the timestamp into time, we need to use two functions for it, i.e. the TIME Function and the MID Function.