Excel Examples
CategoriesTagsAbout
  • How to use Standard Deviation In Excel

    Nov 04, 2020

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

    #Tutorial#How To#Functions#Statistical

  • How to change Negative Numbers to Zero In Excel

    Nov 01, 2020

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

    #Tutorial#How To#Functions#Statistical

  • How to use NPV formula In Excel

    Nov 01, 2020

    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.

    #Tutorial#How To#Functions#Financial

  • How to use Number of Instances In Excel

    Nov 01, 2020

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

    #Tutorial#How To#Functions

  • How to use Ifs function In Excel

    Oct 31, 2020

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

    #Tutorial#How To#Functions#Logical

  • How to create a loan amortization schedule In Excel

    Oct 31, 2020

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

    #Tutorial#How To#Functions

  • How to find the most frequently occurring word in Excel

    Oct 31, 2020

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

    #Tutorial#How To#Functions#Array Formulas

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

    Oct 31, 2020

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

    #Tutorial#How To#Functions#Date & Time

  • How to use If Cell is Blank In Excel

    Oct 31, 2020

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

    #Tutorial#How To#Functions#Logical

  • How to use IfError In Excel

    Oct 31, 2020

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

    #Tutorial#How To#Functions#Formula Errors

  • 1
  • 2
  • 3
  • 4
  • 5
  • »

©2020 Excel Examples.