YEAR Function
The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out the year from a date or […]
The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out the year from a date or […]
In some cases, there is a need to delete multiple rows of data in Excel. When dealing with large data sets, there are several ways you can delete
Delete Multiple Rows of data Read More »
This quick tutorial will demonstrate how to separate numbers after a symbol in Excel. In our example, we have a list of Serial numbers that were exported into
Separate Numbers after a symbol Read More »
The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user specified values. For example, these values would be
Learn how to subtract if greater than zero. In this example, we will demonstrate how to subtract a value only if a cell is greater than zero. Let’s
Subtract If Greater than Zero Read More »