An Introduction to Excel’s Normal Distribution Functions
(Download the workbook.)
When a visitor asked me how to generate a random number from a Normal distribution she set me to thinking about doing statistics...
How to Use Excel Formulas to Calculate a Term-Loan Amortization Schedule
"How do I calculate cumulative principal and interest for term loans? I have scoured the web for a function that will perform this task,...
Introducing Excel’s Three Types of Spreadsheet Databases
Excel offers three general ways to arrange data in your spreadsheet so you can use it as a database with your worksheet formulas:
Simple...
How to Create Monte Carlo Models and Forecasts Using Excel Data Tables
(Download the workbook.)
(This is the second of two articles about normal distributions. The first article is, How to Return Random Numbers from a Normal...
How to Report Periodic Data from Excel Databases
Sometimes, the best way to solve your Excel problem is to redesign your workbook.
Ron G. brought this thought to mind with a recent question....
Excel’s Five Annuity Functions
“Help!” the message said. “I know the payment, interest rate, and current balance of a loan, and I need to calculate the number of...
Use Excel’s INDEX-MATCH or VLOOKUP Functions to Populate Invoices and POs
A visitor asked how to set up a simple invoicing system in Excel.
This is a common problem in many small businesses, divisions, and sales...
How to Create and Use Dynamic Range Names in Excel
(Download the example workbooks.)
We Excel users often refer to ranges that need to move or expand in future versions of our reports. For example:
...
The Most Powerful Ways to Summarize Excel Data for Reporting and Analysis
(Note: I wrote this before Microsoft introduced Excel Tables or SUMIFS. This post is scheduled for an update.)
Excel users often need to summarize data...
How to Use Conditional-Format Formulas to Change Background Colors
"I have an Excel table with a column that will be filled with 'yes' or 'no. When a user enters 'yes' to a cell,...