Riaz Academy
Lecture # 2 Basic Excel Data & Formatting – Ultimate Excel Course in Urdu
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.
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:
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…
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.
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.
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.
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.
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”.
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.
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.
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.
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.
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.
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.
“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.
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.
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”.
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.
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.
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.
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.
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
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