Microsoft Excel Tutorials
Basic attendance tracking: To track the records and calculate the overall attendance of a student, here’s what to do: As you can observe in the image above, we have shown few roll numbers and …
Continue Reading about How to create Attendance Tracking Formula? →
If you are dealing with loads of data and you need to know the maximum value in the range, but there many errors present in the range too. This is what you can do: As you can see in the image …
Continue Reading about How to get Max Value ignoring errors in a range? →
When you are dealing with loads of data and you need to check for whether a particular value/ number/ product/ order is in the category or not, this is what you can do. To deal with such a …
Continue Reading about How to find missing values using IF formula? →
To calculate the no. of day in a year from a particular date, we will use the DATE Function and YEAR Function. Here’s an example, to elaborate the steps that needs to be done: As you can …
Continue Reading about How to Get nth day of year in excel? →
If you want to count the cells in the range that do not contain errors, then we can use the SUMPRODUCT Function, NOT Function, and ISERR Function. Let’s take an example to elaborate the …
To count the total characters, present in a particular cell, you can use the LEN Function. By characters we mean, anything present in the cell, be it the symbol, alphabet even space. Let’s take …
Continue Reading about How to count characters total in a range? →
