Microsoft Excel opens very slow: Possible solution

Wednesday, 31 December 2014

The symptoms are these: Excel opens very slow when you double click on a file spreadsheet, taking 30 seconds to several minutes to open. However when opening Excel only this opens fast and normal. If this is your problem solving can be disable DDE.

 Try the following: 

1) Click on Start> Control Panel> Folder Options

2) In the Folder Options dialog box, click on the rates tab and go down to "Spreadsheet XLS Microsoft Excel" and mark. Then click on Advanced Options

3) We make the Open option and click on Edit

4) Uncheck the option Use DDE . In the text box Application used to perform action we add at the end "% 1" (very important also put the quotation marks). Finally press OK .

Testing. Now should open Excel documents faster upon double clicking them.

comments | | Read More...

Vector decomposed into its components and graph

Decomposition of a vector into its components and graph

To decompose a vector into its components in "X" and "Y" trigonometric functions are used.

It works out as:

Fx = F * Cos (Angle)

Fy = F * Sen (Angulo)

 

Where:

Fx , Fy - > Components in X and Y respectively

F - > Vector into consideration, (can be Strength, speed, etc )

( Angle ) - > Angle in radians

comments | | Read More...

K.ESIMO.MAYOR Y K.ESIMO.MENOR

LARGE

Returns the k - th largest value of a dataset . This may be used to select a value based on their relative position. For example, you can use LARGE to return the highest value of a result, the second result or third.


syntax

LARGE (array, k)





Array is the array or range of data the k - th largest value you want to determine.
K represents the position (from the higher value ) within the array or range of cells, the data to be returned.


K.ESIMO.MENOR


Returns the k - th smallest value of a dataset. Use this function to return values ​​with a specific relative position within a data set.

syntax

SMALL (array, k)

Array is an array or range of numerical data whose k - th smallest value you want to determine .
K is the position within the array or range of data, the data to be returned, determined from the smallest value.

comments | | Read More...

How to convert A file to PDF

Tuesday, 30 December 2014

There are several applications for this task, but as is standard blog will choose a free it easy and reliable, such as PDF Creator , a virtual printer that does is convert any text file or image to Portable Document Format (PDF ) format serves primarily to anyone tamper with files to be distributed.

The first is to download PDF Creator , installed and ready.Steps in the installation:

• We accept terms of use. Next.
• Install the "explorer OfferBox" say no and start the real download.
• The real installer opens, choose the language.Next.
• We accept the agreement. Next.
• We chose standard installation. Next.
• We leave the name as is. Next.
• We leave the installation folder as is. Next.
• Uncheck the tab set Yahoo as the default search engine. Next.
• Custom Install uncheck all meno aid in English and spanish language. Next.
• Making a tab not create folder in the start menu. Next.
• PDF Creator associate the furthest extension .ps and the rest as is. Next. Install.

From then to convert a file to PDF we open it with any application, eg. the Word, give the button "print ", and instead choose the printer you have default we ask it to print in" PDF Creator . " Within seconds we'll have where have told you and with properties ayamos set him, for we can password protect your copy on clipboards, etc. Note : After installation you can remove the two installation folders that you downloaded (not the shortcut), or guard the second in our folder "software" for future installations off -line. The shortcut does not make much sense if you going to use from applications. I hope I have helped.

comments | | Read More...

Frequency distribution by Rule Sturgess

Frequency distribution by Rule Sturges
To construct a frequency distribution by rule Sturgess need to find three data.

1. The number of classes (k).

To calculate the number of classes needed in our distribution the following formula is used

   k = 1 + 3.322 log n

Where n is the amount of data in our sample , the value of k must be an integer , therefore , you should always round up to the nearest whole number.

2. The range of our data (R).

Range is as follows :

R = higher value - lower value


3. The amplitude of each class. (A).

To the extent the following is done :

A = k / R

The explanation of the construction of the frequency distribution by rule Sturgess with Excel.

comments | | Read More...

Current Age

Find the age of a person based on the birth date and the current date, the time to find the difference, convert the result to format in years.

Normally databases include the general data of a person, including those general data is the date of birth, a classic requested operation is to calculate the age of the person to the current date; In Excel we can make a small operation that allows us to calculate the age of a very simple way.

 

For this, we need to first perform a subtraction of the current date minus date of birth, the result is in a numeric format, in this numerical result we apply a suitable format which would convert it to a date which only use the year.

comments | | Read More...

How to play the .flv video

Monday, 29 December 2014

Flash Video FLV means and programs that perform trivial task called play FLV readers because paradoxically, the Adobe Flash Player no use to play flash videos.

This software allows you to view in your browser all kinds of multimedia wonders that exiben from every corner of the Web until almost all the commercials we see on television. These files are mounted on documents with extension flash SWF without the Adobe Flash Player , which should come from the factory with all operating systems, instead of the clip or animation that should look no further, a warning appears with a link that lets it fit. I Download it if you have it so you can see properly all pages, however, this software also you will see the flash, ie videos FLV . In order to see the videos in flash have to download and install one of the following free programs (I recommend this first): • VLC Media Player one blast.

VLC Media Player plays almost any video and audio format.Surely this ability is the reason why millions of users consider it the best. The compatibility with all kinds of multimedia files is because VLC Media Player brings its own set of codecs. In this way, VLC does not depend on those who have installed on Windows. The interface of VLC Media Player has no secrets even for novice users. It handles with ease. Despite this, it also features advanced options like streaming to send a video signal over the Internet. Throughout its development, the program has been specializing in video playback. This is clearly seen in the possibilities of adding subtitles and handle multiple audio tracks associated with a movie. Another aspect that makes many users opt for VLC Media Player is the ability to open incomplete videos downloaded through eMule. But I do not I have told you ok?

comments | | Read More...

CONSULTATION IN ANOTHER BOOK

CONSULTATION IN ANOTHER BOOK

One option that gives us excel is the ability to perform queries in other books, such as data search an employee or sales you made that employee for a certain period of time and which are contained in another book.

In excel performing an operation of this type is identified with the name EXTERNAL REFERENCE can create references are following certain steps.

 

You can reference the contents of cells in another workbook using an external reference. An external reference (also called link ) is a reference to a cell or range of cells on a worksheet in another workbook in Excel, or a reference to a defined name in another book. 

You can reference ranges specific cells, a specific name ranges of cells, or define a name for the external reference.

The formulas with external references to other books are displayed in two ways, depending on whether the source workbook, which provides data to the formula, is opened or closed in Excel.

When the source workbook is open in Excel, external reference includes the workbook name in square brackets ([]), followed by the name of the worksheet, an exclamation mark (!) And cells on which depends the formula. 

For example- the following formula adds cells C10 : C25 Budget.xls book.

External Reference

 
= SUM ([Presupuesto.xlsx] Annual C10 : C25)

If the source workbook is closed in Excel, external reference includes the entire path.

External Reference

 
= SUM ('C: \ Report \ [Presupuesto.xlsx] Annual' C10 : C25)

The formulas linked to a defined name in another workbook using the workbook name followed by an exclamation mark (!) And name. 

For example- the following formula sums the cells in the range Presupuesto.xlsx Book Sales.

= SUM ([ Presupuesto.xlsx] Sales)

Where can effectively use external references

External references are especially useful when it is not practical to hold together in the same workbook sheet models of large calculation.

•    Combine data from several books

•    Create different presentations of data

•    Simplify large and complex models

comments | | Read More...