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
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
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.
= SUM(number1, number2, …)
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