Home Excel

Excel

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

Excel Tip Calculator

Tip Calculator Template

0
Learn to create a tip calculator template in Excel. This basic template allows you to setup a tip calculator for splitting up...
sum if date is greater

Sum if date is greater than

0
Sum if date is greater than a specified date. In this example, we will use the following formula to sum a range...

Calculate Work Days in Excel

0
Calculate Work Days in Excel Using the following Functions Learn how to calculate work days for a given year,...

Sum if between

0
To sum if between in Excel, we need to use the SUMIFS Function and define our criteria.

Sum if less than

0
Sum if less than with named criteria.

_xlfn. prefix in Excel

0
The Excel _xlfn. prefix indicates that your workbook contains a function that is not supported by your version of Excel.

Sum if greater than

0
To sum if greater than, we need to use the SUMIF Function and define our criteria. In this example, we will use...

SECOND Function

0
The SECOND function in Excel returns the second component of a specified time as a number between 0-59.

NETWORKDAYS.INTL Function

0
How many days do I have to work? Find out in Excel.

MONTH Function

0
The MONTH function in Excel returns the month component of a specified date as a number between 1-12.

Latest Tutorials

Excel Tip Calculator

Tip Calculator Template

sum if date is greater

Sum if date is greater than

Sum if between