Home

Microsoft Excel

Run Windows Apps in Linux with Wine 1.0 [Feature]

Fri, 06/20/2008 - 16:00
No matter how easy Linux distributions make it for newcomers to install and use a free, open-source operating system, nearly everyone has at least one program that only works in Windows. Wine, a free...
Source:
  • report this post

[How-To] Shrink Excel Text

Tue, 04/08/2008 - 14:16
Tim Roth has written me a mail asking for a step by step process to Shrink Excel Text. Tim in his mail writes I use MS Excel 2003 with text in the cells, and the General format applied. When I change the format of a portion of the text, that part of the text’s font size is reduced. I can manually fix the font size, but I use Excel a lot and this is quite troublesome. Therefore, for the information of Tim and all other readers of my blog, i am putting below a solution for this issue. Please follow the steps mentioned below. 1. Press CTRL+A to select all. 2. Right-click anywhere in the selection and select Format Cells. 3. In the Alignment tab, uncheck the box Shrink to fit and click OK. 4. If all the text is supposed to be the same size, click the Font tab and set the desired size. 5. Click OK to finish. Hope this helps. Also read:
Source:
  • Read more
  • report this post

[How-To] Calculate Equated Monthly Installment using MS Excel

Sat, 03/29/2008 - 08:36

Excel is definitely a very powerful tool and i attribute the reason for its success to the fact that it was able to change the way people used to compute earlier. The fact that Excel was able to change the behavior of people is the real reason for its success. Therefore, it also holds a very key lesson, if we can create softwares which in turn lead to change the way people live/ work/ behave, those softwares shall certainly be big hits :)

In this post, i shall share with you the formula available in Excel to calculate Equated Monthly Installment.

Lets assume we need to calculate Equated Monthly Installment (EMI) for a principal of 1,00,000 for a period of 1 year (12 months) at a rate of 11%. In order to compute Monthly Installment using Microsoft Excel, follow the below mentioned steps.

1.) Go to Fx and select PMT from Financial.

Source:
  • Read more
  • report this post

Valid XHTML 1.0 Strict

Syndicate content