# How to use Standard Deviation In Excel

This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel.

# How to change Negative Numbers to Zero In Excel

A clever Excel trick to change negative numbers to zero but leave positive numbers unchanged.

# How to use NPV formula In Excel

The correct NPV formula in Excel uses the NPV function to calculate the present value of a series of future cash flows and subtracts the initial investment.

# How to use Number of Instances In Excel

This example describes how to count the number of instances of text (or a number) in a cell.

# How to use Ifs function In Excel

Use the IFS function in Excel 2016 or later when you have multiple conditions to meet.

# How to create a loan amortization schedule In Excel

This example teaches you how to create a loan amortization schedule in Excel.

# How to find the most frequently occurring word in Excel

This example teaches you how to find the most frequently occurring word in Excel.

# How To Get The Date Of The Last Day Of The Month In Excel

To get the date of the last day of the month in Excel, use the EOMONTH (End of Month) function.

# How to use If Cell is Blank In Excel

Use the IF function and an empty string ("") in Excel to check if a cell is blank.

# How to use IfError In Excel

Use the IFERROR function in Excel to return an alternative result, such as text, when a formula evaluates to an error.

# How to use Indirect In Excel

Use the INDIRECT function in Excel to convert a text string into a valid reference.

# How to Use Investment or Annuity In Excel

This example teaches you how to calculate the future value of an investment or the present value of an annuity.

# How to Use IsError function in Excel

This example illustrates the ISERROR function in Excel.

# How to Use Left Lookup function In Excel

The VLOOKUP function only looks to the right.

# How to Use Loans with Different Durations In Excel

This example teaches you how to compare loans with different durations in Excel.