advanced excel microsoft

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.

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



Blog or Build an SBI! Site