Basic Excel - Developing Your First Spreadsheet

Developing your first worksheet can be an exciting time but there are a few things you need to be aware of. When entering data into a cell, the data is normally going to be text, numbers or a formula. If you enter a text or numeric value into the cell, the value isn't going to change. These values are known as Constant Values. Technical Data used in the field explained in it courses in Islamabad.

If you enter a formula in a cell, the values in that cell may change. For example the formula may contain references to cell addresses and if you change the value in one of those cell addresses it will change the result because Excel will recalculate the value.

The golden rule in using Microsoft Excel is that before you enter a value into a cell you must make the cell active. Once you have done that, you can enter the data required.

One thing to note is that when you press the Enter key to complete the data entry, the cell below the cell you entered data in will be selected. This is the default way the Enter key works in Microsoft Excel however you can tell Excel to move to the left, right and up. To achieve this you select the Tools menu, then select the Options command and the Options dialogue box will be visible. Some more details of it courses in islamabad  are as under.

Select the Edit menu and change the value in the drop down box to the value you require. If you want to turn this feature off de-select the Move selection after Enter check box.

Entering text is a straightforward process, select the cell and then type the text. Now text is considered to be letters, numbers and any other characters that you can print using your printer. There are a number of issues that must be understood when utilising Text in combination with numbers. If you type in text with a number eg 89 Albert Street or Target Budget 2004, Microsoft Excel will treat the data as text regardless. It should also be noted that some characters are treated as numbers such as the decimal place, comma and dollar sign. TSK Training for Skills and Knowledge is the best institute in Rawalpindi Islamabad for Pakistani Students who wants to join it courses in Rawalpindi.