This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel.
A clever Excel trick to change negative numbers to zero but leave positive numbers unchanged.
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.
This example describes how to count the number of instances of text (or a number) in a cell.
Use the IFS function in Excel 2016 or later when you have multiple conditions to meet.
This example teaches you how to create a loan amortization schedule in Excel.
This example teaches you how to find the most frequently occurring word in Excel.
To get the date of the last day of the month in Excel, use the EOMONTH (End of Month) function.
Use the IF function and an empty string ("") in Excel to check if a cell is blank.
Use the IFERROR function in Excel to return an alternative result, such as text, when a formula evaluates to an error.
Use the INDIRECT function in Excel to convert a text string into a valid reference.
This example teaches you how to calculate the future value of an investment or the present value of an annuity.
This example illustrates the ISERROR function in Excel.
The VLOOKUP function only looks to the right.
This example teaches you how to compare loans with different durations in Excel.