Free Excel Download
These excel programs are designed to improve your business productivity.
You can download them for free. Kindly note that these excel programs have been
tested using Microsoft® Office XP or version 2002. They are likely
to work well with MS Office 2000 and Ms Office 2003.
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 these programs are created using macros. To run these excel
programs, 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.
Excel Calendar
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 - it is 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.
Contact Mgmt
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 (IRR)
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 (NPV)
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). The reason being the 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.
Consolidate data from multiple worksheets
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.
Creating the Financial Statement
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.
Download
Financial Statement Creator
•
|
New! Comments
Have your say about what you just read! Leave me a comment in the box below.