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 …

Continue Reading about How to create Attendance Tracking Formula? →

Microsoft Excel Tutorials

posted on

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 …

Continue Reading about How to create Attendance Tracking Formula? →

posted on

When you are dealing with loads of data, and by mistakenly you make an error by writing all the dates of one month before it has to begin, this is …

Continue Reading about How to get same date next month using EDATE function? →

posted on

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 …

Continue Reading about How to get Max Value ignoring errors in a range? →

posted on

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 …

Continue Reading about How to find missing values using IF formula? →

posted on

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 …

Continue Reading about How to Get nth day of year in excel? →

posted on

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 …

- Go to page 1
- Go to page 2
- Go to page 3
- Interim pages omitted …
- Go to page 9
- Go to Next Page »