Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Extract all partial matches in Excel
  • Offset in Excel
  • How to get relative row numbers in a range in Excel
  • How to use Excel OFFSET function
  • How to use Excel MATCH Function

Data Analysis Examples

  • How to Create One and Two Variable Data Tables in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • Conditional Formatting New Rule with Formulas in Excel
  • How To Create Frequency Distribution in Excel
  • How to create Checklist in Excel

Data Validation Examples

  • Excel Data validation only dates between
  • Excel Data validation allow uppercase only
  • Excel Data validation must not contain
  • Excel Data validation allow weekday only
  • Excel Data validation unique values only

Tag: Net Present Value

How to calculate Net Present Value (NPV) in Excel

by

NPV formula for net present value To calculate Net Present Value (NPV) you can use the NPV function. Formula =NPV(rate,cashflows)-initialcost Explanation In the example shown, the formula in F6 is: =NPV(F4,C6:C10)+C5 How this formula works Net Present Value (NPV) is the present value of expected future cash flows minus the initial cost of investment. The …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Join Text Strings Using Concatenate or ‘& Operator’ in Excel
  • Get first name from name with comma — Manipulating NAMES in Excel
  • How to strip protocol and trailing slash from URL in Excel
  • How to get page from URL in Excel
  • How to check if cell contains one of many things in Excel
  • Excel Date & Time Functions Example
  • How to determine year is a leap year in Excel
  • How to calculate future date say 6 months ahead in Excel
  • Convert date to text in Excel
  • Get date from day number in Excel
  • ACCRINT function: Description, Usage, Syntax, Examples and Explanation
  • PDURATION function: Description, Usage, Syntax, Examples and Explanation
  • SLN function: Description, Usage, Syntax, Examples and Explanation
  • DOLLARDE function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate simple interest in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles