Everything for MS Excel

2010 Fifa World Cup South Africa - Fixture

2010-06-24T18:48:00.000-07:00

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):

Present Value Formula PV() - Excel

2009-07-14T21:24:00.000-07:00

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

Calculate the Correlation with Excel

2009-06-15T13:01:00.000-07:00

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:

Example: Savings Planner

2009-06-08T11:25:00.000-07:00

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

Template 003 - Any Year Calendar

2009-06-05T14:16:00.000-07:00

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

Template 002: School Day Schedules

2009-06-05T09:02:00.000-07:00

A simple but useful schedule to organize school activities.

It can be filled and then printed. It is configured with landscape orientation.

After the figure you will find the links to templates for 2007 and 2003 Excel Versions.

Schedule Template for Excel 2007

Schedule Template for Excel 2003 or XP

If you want an spanish version you can find it in Schedule in Spanish.

Template 001: Calendar 2009

2009-06-03T16:17:00.000-07:00

This template is designed in english for Excel 2007 and 2003 and before versiones.

You can download the files from the next links:

Template Excel 2007 version
Template Excel 2003 or before versions

Spanish Versions in Todo para excel