Found 2044 Articles for Microsoft Technologies

The Easter celebration is usually celebrated on the first Sunday that follows the first ecclesiastical full moon that falls on or after March 21. Because of this, the date of Easter might vary from year to year. This tutorial may be of assistance to you if you are looking for the particular day of Easter for a given year. Here we will use a formula in determining when Easter will fall on any given year. Let’s understand step by step with an example. Step 1 In the first step, let’s assume we have a sample data for calculating easter ... Read More

How would you find out how many days are left till your next birthday, if it is something you are interested in?  Actually, if you are counting down the days till your next birthday with Microsoft Excel, you may utilise the worksheet formulae to make the process much simpler. Let’s understand step by step with an example. Step 1 Make a worksheet where the Headers are displayed below. Create column headings in a worksheet in a sequential order, as demonstrated in the screenshot below. In addition, enter your date of birth into the cell labelled "DOB " in column ... Read More

At times, you may want to know the working days left in a month or in a year. So, if you want to calculate the remaining days left in a month or to calculate the remaining days left in a year you can follow the below article which is easy and quick to calculate the days left in a month or in a year in an Excel sheet. Follow the steps given below to calculate the days or working days left in a month. Step 1 Open an Excel sheet and enter the date for which you want to calculate ... Read More

For you to calculate the compound annual growth rate (CAGR) in an Excel sheet, there is a basic formula that you need to follow =(End Value/Start Value)^(1/Periods)-1 you can easily apply this formula for this kindly follow the below steps − Step 1 Open a Microsoft excel sheet and enter the data as shown in below. You can change the data as per your requirement. Kindly find the below screenshot for your reference. Step 2 Now you need to select a blank cell and enter the below given formula into the blank cell and press the enter key so ... Read More

You know how to calculate the normal average function which gives the average value of all the selected cells in an excel sheet. But in this article, you will learn how to calculate the average excluding the min and max values or highest and lowest values from selected numbers as shown below. You can calculate the average without max and min values in Microsoft excel using the formulas. Open a Microsoft excel sheet and enter the numbers as per your need as shown in the below screenshot for your reference. Now you need to enter the below-given formula and ... Read More

In a typical scenario, we are able to easily calculate the average speed in an Excel worksheet by using the formula Speed = Distance / Hours. However, there are situations in which the hours are not represented by numbers but rather a time format,  how would you handle this work in Excel? In this tutorial, we will use a simple formula to calculate the average speed based on the distance travelled and the amount of time spent doing so. Let’s understand step by step with an example. Step 1 In the first step, let us assume we have a sample ... Read More

How can we do the calculations needed to determine the average of all the numbers on the various worksheets if we want to accomplish that? This post will show you an easy approach to compute the average for all numbers across several worksheets. Currently, we may know how to calculate the average for a selected range on a single worksheet. However, this article will show you how to do it for all numbers. In terms of the reality that the data range on other worksheets could be the same or different, we have prepared two instances to use as an ... Read More

We can use Excel formulas to count, add values between two provided dates of a data range, and average numbers between two dates. I'll show you how to calculate the average of two dates in Excel. The average of two dates can be calculated using the methods explained in this tutorial. Let’s understand step by step with an example. Step 1 In the first step, let’s assume we have a sample data. Please refer to the below screenshot for the same. Step 2 Create a new cell where you can save the First Date, the Last Date, and the ... Read More

If, for instance, you have a list of employee names in Excel along with their birthdays and ages, how would you go about calculating the average age for a specific month or year? And what happens if you want to calculate the average up to a certain date in Excel? In this tutorial, you will learn various Excel tips and methods that will make the problem easier to solve. Calculating the Average Age by Month with Formulas in Excel Let’s understand step by step with an example. Step 1 For instance, you have a table that looks like the one ... Read More

Let's consider that you have a list of ID numbers that contains 13 to 15 digits of numbers, and in those 13 to 15 digits, the first six digits are the date of birth of the candidate or a specific person, so that you have a list of ID numbers. For instance, consider that you have an ID number of one person 9304304413002 in this Id first 6 digits is the date of birth 1993/04/30. From this ID number, how will you calculate the age? In this article, I will introduce the formula which is very easy that quickly ... Read More