Using PMT, PPMT, IPMT, IF and IFERROR functions in Excel, we create an amortization schedule to calculate repayments / over payments as well as the amount of interest and principal paid on a mortgage.
Visual Basic loops can use IF, ELSE and ELSEIF or FOR NEXT statements to allow you to perform the same task on a large number of cells easily and quickly. You can easily group cells using cell ranges
Microsoft Excel can do some amazing things. I like to attempt little projects testing what Excel can do. I was asked the other day to simulate a cup draw using Excel and this is the result. This article will give you...
The Insert Tab of Microsoft Excel 2007 is important as it helps you to insert objects like tables, pictures, charts, hyperlinks, symbols among others. It has been discussed thoroughly here.
This hub introduces you to Microsoft Office Excel 2007, a spreadsheet program. It is ideal for performing Mathematical calculations, it can also be used for data analysis, and creating charts.
In our work-field, we often face the necessity to create some random numbers for various reasons. Sometimes it is for making a pin number for accessing something or a random password for someone to access a website, or...
SUMPRODUCT in Excel 2007 and Excel 2010 allows you to multiply data from multiple data ranges and then sum the result. It can be used, for example, to calculate stock levels or sales commissions.
Though rarely used, it is important to know much about these two menus. There are some vital commands in both that you need to know as an Excel Program user.
Format menu of Excel 2003 helps us to format the cells and the entire worksheet. It is through this menu that you can be able to change things like font, font colour, and font size of Excel document.
If you are using pictures in your Excel spreadsheet you may be having some difficulty with sorting the pictures along with the other data in the list. The good news is that you can sort pictures in an Excel list just...