Month: February 2009

Learning Microsoft Excel macros

Posted by cloud – February 26, 2009

Microsoft Excel is a spreadsheet and probably the most commonly used on most computers today. There are tools at your fingertips and can be confusing, but it can also give you many ways to make your work easier. One of the simplest is the macro. If you used a phrase or a piece of text or data, you can connect to Excel with a few keystrokes. Read on to learn how to use macros in Excel.

The measures relating to the use of macros

1. Choose your text block in front of you to read what he wrote. On the main menu bar, click Tools, Macro and Record New Macro.

3. A pop-up and you must enter at least two things. You need to know what to call your new macro, and you need to know what key to use for access.

4. Click "OK" and you’re ready to begin entering your macro. Type exactly and only the data you want to appear in the macro. We use the word, for example, as an example.

5. For example, type, and then click on "Tools" "Macro" and "Stop Recording". This completes the macro and makes it available for you.

6. Click on "Shift" and "Control" to run the macro to insert the word "example". This will insert text in the active cell.

7. Facilitating the use of macros. Click on "Tools" then "Customize." Select "Toolbars" and then check the box next to "Visual Basic". Now click "Close." You can drag the toolbar at the top with the rest of the toolbar.

For more information about using a keyword, type the word, place the cursor on it and press the F1 key. Sometimes it helps to look at the example of aid rather than to read the details. Do not use the command keys for macros. It’s always good to use both "Shift" and "Control" with its macros.

  • Share/Bookmark

IF function in Microsoft Excel

Posted by cloud – February 15, 2009

The IF function is one of the most useful Excel functions and the most used. What it does, basically, is test to see if a certain condition is true or false. Return a real value and if it becomes a false alternative. Many people seem to really cause much headache with the IF function, but overall, it is not really a difficult tool to use.

The IF function allows the decision-making in a spreadsheet. Specific criteria that are installed in one of two actions, according to whether or not the criteria are met.

An example

You have two values. In a cell that has a value of 65 years and in another cell that has a value of 23. If the function that allows us to do is do a test and you can say that we want to see if the value of 65 is above 23. When the numbers are connected in a statement, the result is that 65 is greater than 23 and becomes a real return of the region.

The syntax of the IF function is as follows – IF (logical test, the results of true and false results)

But we can now create the example we did earlier to get started, just open a worksheet in Microsoft Excel. Address in cell A1, type the text, IF the test conditions. In cell A2, type the text – the numerical value 1, A3, type the text – Numeric value 2, and in cell A5, enter the text what is the biggest?

Now we need to test numbers in our Excel spreadsheet, enter in cell B2 of the address value 65 and the direction in cell B3, enter the value 23. In cell B5, we must create our formula. Using the above example, we want to know if the value in B2 is higher than the value of B3. If the condition is true that we restore the text – the numerical value 1 and the condition is false, if we want to send the text – Numeric Value 2.

The structure of the IF function will look like this = IF (B2> B3, "value 1", "value 2")

What can be seen in the previous function is the text values are quoted. Always work with the text in the text should always Formulas price around him. If you type the above formula in cell B5 management should see the text – numerical value 1. If you change the value from B2 to 12 now, the outcome of B5 should be – the numerical value 2.

The IF function is a very varied and you can test an unlimited number of conditions necessary for the future, it can even be nested IF functions within IF functions, but the important thing is that for each function in the syntax should look IF the same as above.

  • Share/Bookmark