Home Excel Page 2

Excel

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

Year Function

YEAR Function

0
The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out...

Delete Multiple Rows of data

0
In some cases, there is a need to delete multiple rows of data in Excel. When dealing with large data sets, there...
Separate

Separate Numbers after a symbol

0
This quick tutorial will demonstrate how to separate numbers after a symbol in Excel. In our example, we have a list of...

WORKDAY.INTL Function

0
Workday.intl Function
WORKDAY Function

WORKDAY Function

0
The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user specified values....
Subtract If Greater

Subtract If Greater than Zero

0
Learn how to subtract if greater than zero. In this example, we will demonstrate how to subtract a value only if a...
WEEKNUM Function

WEEKNUM Function

0
The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1...
Excel Rounding Functions

Rounding functions in Excel

0
Complete overview of rounding options in Excel.
ROUNDDOWN Function

ROUNDDOWN Function

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

FLOOR Function

0
The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the FLOOR function...

Latest Tutorials