How to use Standard Deviation In Excel2020-11-4Functions StatisticalThis 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 Excel2020-11-1Functions StatisticalA clever Excel trick to change negative numbers to zero but leave positive numbers unchanged.
How to use NPV formula In Excel2020-11-1Functions FinancialThe 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 Excel2020-11-1FunctionsThis example describes how to count the number of instances of text (or a number) in a cell.
How to use Ifs function In Excel2020-10-31Functions LogicalUse the IFS function in Excel 2016 or later when you have multiple conditions to meet.
How to create a loan amortization schedule In Excel2020-10-31FunctionsThis example teaches you how to create a loan amortization schedule in Excel.
How to find the most frequently occurring word in Excel2020-10-31Functions Array FormulasThis 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 Excel2020-10-31Functions Date & TimeTo 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 Excel2020-10-31Functions LogicalUse the IF function and an empty string ("") in Excel to check if a cell is blank.
How to use IfError In Excel2020-10-31Functions Formula ErrorsUse 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 Excel2020-10-31Functions Lookup & ReferenceUse the INDIRECT function in Excel to convert a text string into a valid reference.
How to Use Investment or Annuity In Excel2020-10-31Functions FinancialThis 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 Excel2020-10-31Functions Formula ErrorsThis example illustrates the ISERROR function in Excel.
How to Use Left Lookup function In Excel2020-10-31Functions Lookup & ReferenceThe VLOOKUP function only looks to the right.
How to Use Loans with Different Durations In Excel2020-10-31Functions FinancialThis example teaches you how to compare loans with different durations in Excel.