## How to create Attendance Tracking Formula?

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…

Continue readingBasic 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…

Continue readingIf 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…

Continue readingWhen 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…

Continue readingTo 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…

Continue readingIf 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…

Continue readingTo 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…

Continue reading