Author Archives | john.o.mason

The Subtotal Button for Summarizing Data in an Excel Database

The subtotal feature in Excel allows you to generate summary information, such as subtotals, averages, record counts, and maximum and minimum values for groups of records in a database. When you generate the summary information, Excel adds summary and grand total rows to the worksheet, labels each row, and outlines the records in each group. By clicking on the outline minus and plus symbols, you can quickly hide and show the details for each summarized group of data. The subtotal feature also allows you to remove and replace summary information.

  The Subtotal Button for Summarizing Data in an Excel Database (740.9 KiB, 2,379 hits)

Posted in Information Technology, Issue no. 7, Knowledge ManagementComments Off on The Subtotal Button for Summarizing Data in an Excel Database

Computing Cumulative Interest and Principal Paid for a Calendar Year

This paper demonstrates how easy it is use Microsoft Excel’s CUMPRINC and CUMIPMT functions to compute principal and interest paid for an entire year, even though the payments were made monthly. The CUMPRINC function computes the principal paid by a series of loan payments; the CUMIPMT function computes the interest paid. These two functions provide an alternative to preparing a monthly loan amortization schedule and adding up the amounts of monthly interest paid and principal paid for the year.

  Computing Cumulative Interest and Principal Paid for a Calendar Year (728.0 KiB, 4,467 hits)

Posted in Economics, Information Technology, Issue no. 5Comments Off on Computing Cumulative Interest and Principal Paid for a Calendar Year