Home » Excel » Page 4

# Excel

Learning Excel has never been easier. Review hundreds of Excel tutorials geared towards beginners all the way to experts.

## 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 …

## Delete Multiple Rows of data

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 …

## Separate Numbers after a symbol

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 …

## WORKDAY.INTL Function

Workday.intl Function

## WORKDAY Function

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 …

## Subtract If Greater than Zero

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 …

## WEEKNUM Function

The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1 to 52 representing the corresponding week …

## Rounding functions in Excel

Complete overview of rounding options in Excel.

## ROUNDDOWN Function

The ROUNDDOWN function in Excel returns a number rounded down to a specified number of places.

## FLOOR Function

The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the FLOOR function is set to always round down. …

Scroll to Top