Now convert any unit of measurement, Calender from year 1900-2078, Loan Repayment Schedule, Area Conversion, Trigo Functions, Cone, Circle, Polygon and Triangle calculations possible in one sheet.
Download Link:
http://www.box.net/shared/2ao1qaepn4
Source:
mehryar.beyk@aramko.com
Friday, May 15, 2009
Wednesday, May 13, 2009
Excel Power Uitlities
There are more than 100 utilities to process data in excel. It gives cent percent accuracy and saves time. Here is the power utilities which can change text case (from UPPER CASE to lower case, Proper Case or Sentence case), Sum based on Cell Background Color, Split Data, Join Data, Create linkable index sheet for all sheets in a workbook & much more.
How to Install:
1. Download the .zip file.
Download Link: http://www.box.net/shared/t680yvcqzg
2. Extract the .zip file.
3. Run the .exe file. (It may ask you change the security level. Open MS-Excel, Go to Tools menu - Macro - Security. In Security Level tab, Select Low.)
4. A new menu Power Utils will apear.
5. For maximum use of this utility, help is available in it.
Courtesy: http://www.powerutilsnet.com
How to Install:
1. Download the .zip file.
Download Link: http://www.box.net/shared/t680yvcqzg
2. Extract the .zip file.
3. Run the .exe file. (It may ask you change the security level. Open MS-Excel, Go to Tools menu - Macro - Security. In Security Level tab, Select Low.)
4. A new menu Power Utils will apear.
5. For maximum use of this utility, help is available in it.
Courtesy: http://www.powerutilsnet.com
Income-Tax Ready Reference
One page summary of all important Direct tax is ready. It covers all heads of Income, Tax rate structure for all assesses, Capital Gain Cost Inflation Index, FBT rates in brief, NSC Interest rates, Depreciation , TDS rates, Wealth-tax and Gift tax.
Download Link:
http://www.box.net/shared/t680yvcqzg
Download Link:
http://www.box.net/shared/t680yvcqzg
Saturday, May 9, 2009
Convert Numbers to Text
Convert number to text is an Add-In. It results the numbers into words alongwith "paise" and "only".
How to install:
1. Download the Add-In on your Desktop. Download Link:
http://www.box.net/shared/lc8a0mmd1z
2. Download the file and save it to Desktop. Copy the file.
3. Open MS-Excel.
4. Go to Tools -> ADD-Ins ->Browse
5. A window will open "AddIns" folder.
6. Paste here the file.
7. Press Ok. Make sure that the Num2text add-in is displyed in the list and it is selected by tick mark in the check box. Press Ok again to close Add-Ins Window.
How it Works?
Suppose Cell A1 contains 1001.23
Type formula in Cell B1 =num2text(A1)
Cell B1 will display Rupees One Thousand One and Paise Twenty Three Only
It will change the amount in words automatically as the Cell A1 gets changed.
How to install:
1. Download the Add-In on your Desktop. Download Link:
http://www.box.net/shared/lc8a0mmd1z
2. Download the file and save it to Desktop. Copy the file.
3. Open MS-Excel.
4. Go to Tools -> ADD-Ins ->Browse
5. A window will open "AddIns" folder.
6. Paste here the file.
7. Press Ok. Make sure that the Num2text add-in is displyed in the list and it is selected by tick mark in the check box. Press Ok again to close Add-Ins Window.
How it Works?
Suppose Cell A1 contains 1001.23
Type formula in Cell B1 =num2text(A1)
Cell B1 will display Rupees One Thousand One and Paise Twenty Three Only
It will change the amount in words automatically as the Cell A1 gets changed.
Subscribe to:
Comments (Atom)