InExcel brings this time a template in agreement to the fever of the Soccer 2010 FIFA World Cup South Africa. You can fulfill results and Excel will automatically go configuring quarterfinal, semifinals and the final match of the championship.
Not forget fulfilling the results of all of the games!!!
And which is your favorite team?
You can download the fixture from the next link (MS Excel 2000-2003-XP):
Thursday, June 24, 2010
2010 Fifa World Cup South Africa - Fixture
Tuesday, July 14, 2009
Present Value Formula PV() - Excel
Let´s follow with the financial examples. Now we will analize one of the basic relations, that of the present value of future payments.
Present Value
The next example allows to calculate and understand the outcome of the Present Value formula PV . For example shows through a chart, the items included in the formula. the sequence of periodic payments and the possible inclusion of a payment made in the last period. The results coincide with those that can be obtained by deducting the exercise period to period values. Additionally, the chart can be updated to represent the exercise. For convenience the example model supports up to 120 times, depending on the user that can be monthly, quarterly or annually. The only consideration to be taken is to match the frequency of payments with the interest rate. Finally, the last argument to be considered by the formula, said the convention on the timing of periodic payments are made, you can take the value zero for periodic payments executed at the end of the period, and one if a periodical payments are made at the beginning of period. In either option, the final payment is considered as the definition says, at the END of the last period.
NOTE: Enable Macros in order to update the graph automatically according to the number of periods.
Excel 2007 Version
Excel 2003-02 Version
Spanish Versions
Excel 2007 Version
Excel 2003-02 Version
Spanish Versions
Monday, June 15, 2009
Calculate the Correlation with Excel
The following example allows to calculate the correlation coefficient between two series.
For the calculation we use the basic command COEF.DE.CORREL = () (excel version in Spanish) or = Correl () (in English version of excel).
The worksheet besides calculating the correlation coefficient, calculates p-value, or the probability of the test where the null hypothesis is that the correlation coefficient is different (two tails) or less or greater than 0 (one-tail).
Recall that the formula of correlation coefficient between two data sets X and Y, is:
While the null and alternative hypothesis to verify the significance of the correlation coefficient are:
The files with the example:
Monday, June 8, 2009
Example: Savings Planner
With this example you can lear how to use the NPER formula in excel.
NPER permits to find the number of periods necessary to achieve a goal of money supposing that you can save an equal quantity of money every month.
Savings Plan
This workbook calculates the necessary period of time to achive savings goals.
Suppose, for example, that you want to change your car. With this sheet you could solve the period of time necessary to save enough money.
Fill in the cells the amount of money you can save every month, the anual interest rate and the amount of money goal. Excel will find how many years and months you will need.
The sequence of your savings and your savings plus your interests are showed graphically.
The files for MS Excel 2007
The files for MS Excel 2003-02
Spanish Version
Friday, June 5, 2009
Template 003 - Any Year Calendar
The most important characteristic of this calendar is that allows configure day and months for any year!!!
It has a Sheet named "Auxiliar" where the calculations are made. You should NOT delete this sheet.
Like in the other templates, down you could find the links to download the files for MS Excel 2007 and 2003-XP. Enjoy it!!!
Download versión 2007
Cownload Calendar Version 2003 and XP
The spanish version here
Subscribe to:
Posts (Atom)
