Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Calculate NPV in Excel: NPV and XNPV With Examples

Net present value, or NPV, tells you whether an investment is worth making by converting all future cash flows into today’s money and subtracting the cost. A positive NPV means the project earns more than your required return, and a negative NPV means it earns less. Excel has the NPV function for regular yearly or

Standard

How to Use XLOOKUP in Excel: Syntax, Examples and VLOOKUP Differences

XLOOKUP is the modern lookup function in Excel. It finds a value in one column or row and returns the matching value from another, and it fixes many of the limits of VLOOKUP: it can look to the left, it defaults to an exact match, it does not break when you insert a column, and

Standard

How to Sort Data in Excel: A to Z, Multiple Columns and Custom Order

Sorting puts your data in a useful order, such as names from A to Z, amounts from largest to smallest or dates from oldest to newest. Excel can sort by one column, by several columns at once, by cell color or by a custom order such as High, Medium, Low. It can also sort a

Standard

How to Make a Pie Chart in Excel: Step-by-Step Guide

A pie chart shows how a whole is divided into parts, such as the share of sales by product or the share of a budget by category. Excel can build one in seconds, and with a few formatting steps it becomes clear enough for a client report or a presentation. This guide shows how to