Archive for May 2016

Compound Interest Formula in Excel

Excel Formula to Calculate Annual Compound Interest

This tutorial will demonstrate various ways to calculate compound interest in Microsoft Excel. What is compound interest? When you invest money, you can earn interest on your investment. Say, for example, you invest $3,000 with a 10% annual interest rate, compounded annually. One year from the initial investment (called the principal), you earn $300 ($3,000…

Read More

Print Comments in Excel

Excel allows you to display comments on the screen, but by default the comments will not print with your spreadsheets. This tutorial will teach you several different methods to print comments in your spreadsheets. Print Comments – Review Ribbon Method: 1. If you have more than one worksheet, select the one that contains the comments…

Read More

Add Up (Sum) Entire Columns or Rows in Excel

Sum an Entire Column in Excel

This tutorial covers how to add entire rows or columns in Excel The Sum Function We will use the Sum Function to add up entire rows and columns.

The Sum Function takes input in two primary forms: standalone cell references (ex.=sum(a1,b2,c3)) or an array of cells (=sum(A1:E1)). We will use the latter method: Tip…

Read More