The Excel programs listed in this page are designed to improve your business productivity. You can download and use these programs for free. They have been tested using Microsoft® Office XP or version 2002 and are likely to work well with MS Office 2000 and Ms Office 2003, up to the current 2013 version.
These Excel programs are our business solutions to help organizations from big Multi-National Corporations (MNCs) to Small Medium Enterprises (SMEs) improve their operational efficiency.
They are easy to use and require minimum installation. You do not need to know have any technical knowledge to use them. Neither do you need the assistance of your IT department or personnels who are swarmed with so many requests every day that you would have to wait days or even weeks before they can start working on your request.
Please note that some of these programs are created using macros. To run those Excel programs with Macros, you may need to set the macro security level to medium and enable macro when prompted. The security level will prompt you when you are opening a file with macro. It will alert you when an excel file with macro is opened. That is to prevent you from opening a excel file that is infected with virus unknowingly. Rest assured that the Excel programs from our website are free from viruses.
Do you have find it tedious to track who is on leave in each month? Using this leave scheduler, you can easily identify them at one glance.
This template is capable of displaying the 12 months calendar of any year, simply by entering the year in the designated cell. The beauty of this calendar – created purely by using Excel formulas. No macro is involved and there is no need to install any software on your computer. You can duplicate as many copy as you like simply by saving the template/workbook with a name of your choice.
You can request for a free copy of the calendar on this excel calendar page.
If you would like to know how it is created, please go to this calendar page.
This program allows you to import your MS Outlook contacts into Excel, update the changes you have in Excel. When completed, you can upload the details back into MS Outlook.
With this program, I don’t have to make changes to my contacts one by one, especially when my contacts move office and I need to change the addresses of all the contacts from the same organisation to the new address.
You can request for the FREE program at our Outlook Contact Management page.
Internal rate of return is one of the main measures for companies or investors to evaluate whether they should proceed with the investments. The problem with IRR is that there may be multiple outcomes and you may end up with the wrong rate. So we have a template where you can enter your cashflows and find out which is the correct IRR you should be working with.
More about internal rate of return can be found in this IRR page.
Net present value is something that affects us everyday. If you put some money in the bank and don’t touch it, you may find that this money can buy you less and less thing in the future (like 5 yrs later). This is because your savings is growing slower than the cost of living (or in simplified terms, cost of food). How do we calculate that? We use NPV. It is also good for calculating whether an investment is generating the returns you are expecting. Find out how we use the NPV to calculate share prices.
This addin is capable of consolidating data in multiple spreadsheets in an Excel workbook and present the details in a single pivot table. Watch this video to find what exactly how this is done. You can request for a copy of Excel addin here.
This macro will help users create financial statements on the fly. The macro is able to generate the financial statements using the Charts of Account (COA) and on the right of the COA, the current year column, followed by 12 monthly columns for the following year plus a yearly column ranging from 3 to 10 years. What’s more, the macro will help to create formula for the relevants row and columns.
Share this page:
Would you prefer to share this page with others by linking to it?
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
advanced-excel.com is in no way associated with Microsoft