Excel

Data Validation

I received a phone call from a Marketing Team wanting to know how to create a drop down list within a cell.  Data Validation is the perfect way to accomplish this. From the Data menu, select Validation.  A screen similar to the following

Interest

I just got off the phone with a customer who wanted to know how to calculate compound interest.  There are two easy ways to accomplish this in Excel.  First, on a line by line basis, secondly, using exponents. Line by Line: Download a copy