Header Ads

Lecture # 2 Basic Excel Data Entry & Formatting - Ultimate Excel Course in Urdu

Lecture # 2 Basic Excel Data & Formatting - Ultimate Excel Course in Urdu

Lecture # 2 Basic Excel Data & Formatting



In this video I'll show you how to enter, edit and delete text and numbers in an Excel spreadsheet. Whenever you want to modify the content of a cell you first have to select it. You will know that you have selected a cell thanks to the black borders that the cell will have once it is selected.
In addition to that the respective row and column of the cell will be highlighted in orange, as you can see here. I've selected D4 and column D and the fourth row are highlighted. It is quite easy to enter content in a selected cell. You should simply start writing For example, I'll type the days of the week:
we will have Monday, Tuesday, Wednesday, and so on...
In order to tell Excel to accept the value that we we have written, we can hit Enter, one of the arrow keys or TAB.The difference is that if you hit Enter when entering the data, the next cell that you will be at is the one below, while TAB will instead move you to the right. We have the same thing with numbers. Next to each of the days of the week, I'll type the numbers from 1 to 7. You can see that Excel aligns text to the left and numbers to the right.
It is quite possible that sometimes when you start modifying a cell you will change your mind about doing it. By pressing the Escape key the modification that you made would not be carried out. As you can see I typed 8, but then pressed the escape key and the cell remains blank.
None of the changes that I performed during "Edit" mode are performed. We can use the F2 key when we need to edit the content of a cell. it activates the formula bar and we can start writing. We can change the content of the cell and then click Enter.
If you want to delete the content of a cell, then you have two options: use the Delete button on the keyboard or that Clear command in the "Home" tab. The difference between the two is that Delete leaves any previous formatting that you had, while Clear is able to remove the entire content of the cell. This is how you enter, edit and delete data in Excel. In our next lesson we will learn how to format our spreadsheets. 
There are many different options that will allow you to format the cells of your workbooks. You can find them either in the "Home" tab of the Ribbon or through a right-click and selecting "Format cells".
As you can see you can change the font and font size of the selected cells from this part of the "Home" tab. Let's say that I would like to select multiple cells and change their font to "Arial". I will select the cells first, and then change their font from the box containing all fonts that are available in Excel.
I'll also change the Font Size of these cells. Let's change it to 12. See? Pretty easy to do, right? We can use these buttons in order to put emphasis on text and numbers.
For example, I'll click on this button and the selected cells will be put in bold. I'll click again and the bold effect is removed. We have the same thing with the "Italic" and "Underline" buttons. It is very easy to create borders for the cells that we have selected. I will click on the "Borders" button and select the type of border that I would like to apply.
I think I'll select the "all borders" option. and voila... we have our borders.
Similarly, we can add all other types of borders. We just have to select, which type of border we want. In case we want additional options, we can click on "more borders" or open the "format cells" menu.
We will be able to find additional options under the "Border" tab.
We can select a border's thickness and color. For example, I will select a thicker border with a dark blue color and apply it to the outer borders of the selected cells.
Here's the end result. If we want to change the fill of the cells that we've selected we can do it from here. I'll color the selected cells in grey. In a very similar way, we can change the font color of the content within the cell by using the button on the right. Let's change the font color to white. Here it is. Let's provide a practical example. We have the following table,  which contains three fields: "Name", "Company" and "Telephone number" As you can see, the table does not look very good right now. We need to use Excel's formatting options in order to improve its appearance.
First off, I'll select the cells of the first column and align all of them to the left. We can use the "Align left" button in order to do that. Then I'll do the same thing with the cells from the second column. Let's select them and click "Align left".
Very well. The third column is aligned to the left Given that these are telephone numbers, I would like to have them on the right. I'll select the cells and click on "Align right". Do you notice that the data in the top row does not seem aligned? The first and the third columns are somewhat below the second one. Let's select the cells of the top row of the table and align them to the top. That's better.
Now, let's add a few extra formatting details to the table. Let's change the fill of all cells to white. I'll select the cells and use the "Fill color" button in order to change their fill. Here it is. Now we need to emphasize that the top row is the title row of the table. I will change its font color to dark blue and I'll put it in bold. That's better.
The final detail, which will complete the table will be to add a border below the title row. Let's open "Format cells" and select the "Border" tab. Here we can choose the thickness of our border, its color and exactly where to place it. I will use a dark blue color given that the text is in dark blue. And here is our end result.

Not bad for a start, right? These commands allow us to organize our data very neatly and efficiently. It was a pleasure showing you some of the formatting options in Excel.
 DOWNLOAD FROM THE FOLLOWING LINKS

http://riazacademy.blogspot.com/

But before Download, Please Like us  on Facebook and Share this book on your social media, so that you can be informed about new future books.
EXERCISE



Google-Drive Links  :  Click Here to Download

SOLUTION
Google-Drive Links :  Click Here to Download

No comments

Thanks for Your Precious Words :)