Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Calculate Compound Interest in Excel: FV Formula and Yearly Table

Compound interest is interest that is calculated on the original amount and on the interest that has already been added. Because the interest earns interest, the balance grows faster than with simple interest, and the longer the time, the bigger the difference. Excel can calculate it in one cell with a simple formula, or with

Standard

How to Calculate CAGR in Excel: Formula, RRI Function and Examples

CAGR stands for compound annual growth rate. It is the constant yearly rate at which an investment, a sales figure or a population would have to grow to get from its starting value to its ending value over a number of years, assuming the growth was compounded each year. It smooths out the ups and

Standard

How to VLOOKUP From Another Sheet in Excel: Formula, Examples and Fixes

VLOOKUP finds a value in the first column of a table and returns a value from another column in the same row. In real work, the lookup table is often on a different sheet, such as a price list on one sheet and orders on another. The formula is almost the same as for a

Standard

How to Use Text to Columns in Excel: Split Names, Dates and Codes

Text to Columns is an Excel feature that splits the content of one column into several columns. It is the fastest way to separate a full name into first and last names, split an address, break up data copied from a text file or a website, or convert text dates into real dates. Unlike a