| Sample File |
Description |
| Work Days |
This example calculates the number of work days between two periods excluding weekends and public holidays. |
| Pivot Tables |
This example summarizes large amounts of data into a meaningful summary. |
| Salesman Commission |
Calculates Salesman's Commission where it is based on varying scales of earnings. |
| Summing Every 3rd Item |
Formula for calculating every third item. If you want to calculate every 2nd,4th,5th item, etc, then change, 3 to say, 2 for every 2nd item, 4 for every 4th item etc. |
| Net Present Value |
Formulas for Calculating the Net Present Value of a project. |
| Credit Card Payments |
Table & Formula for Calculating Interest on where minimum amount stipulated is repaid on a credit card. |
| Financial Calculator |
This example can be used to calculate the monthly repayment on a vehicle which has been financed. |
| Excel Game |
This simple game is so addicting, seems easy but try if you can solve. |
| Invoice_Report_Program |
This program will consolidate the data from the text file and lay it out in excel sheet for efficient calculations and other purposes. |