Microsoft Excel Tutorial for Beginners - The Beginner's Guide to Excel - Excel Basics Tutorial
 |
| Excel Tutorial for Beginners part-2 |
In Microsoft Excel, in the Microsoft Excel for Beginners
Education series, we were talking about using shortcut menus in our lecture
number six. The way we did the first lecture number one, it had five parts.
Now, in lecture number two, it has five more parts. So, in the tutorial number
six, the first thing we talked about was using shortcut menus. Here, the
shortcut menu that comes up is as we write here, let's say we wrote one. And
you repeated it on some things, at some places. Now, when you select, right
click anywhere, this shortcut menu comes up. You can see that the font is also
coming up directly. You can increase any font and its live view is also
happening. And similarly, right click on the bold telecine line and you can see
that shaping is also there. The standard color is its theme color, back color
and similarly, by right clicking on the font color, the font color is selected.
And these things are displayed in front of you. So I have created these things
in front of you. Now, I will show you a style as well. Just like shortcuts,
some styles also appear. See, we have home and cell style. You can select any
cell style from these. So, this is a readymade cell style. After that, if you
apply this to any one thing like this, then if you want to do the same thing in
another place, then without going to the previous command, you can simply press
A four. This will also perform the same action that you have repeated last.
This can also be done with FA and control-W. Repeat the last action with both
the things. In Max Word, Max Excel and in Pan Access etc., where mostly it is
in Word Excel, repeat the last action is F4. I will give you another example of
this. I have created a new sheet. In the new sheet, let us write Pakistan here.
And here Now here I have bolded it, so instead of bolting it here I will press
four, it will be bolted, that is, repeat the last action. The second thing is
that I have dulled it like this for the entire row, so here instead of dulling
it, I will just press f4, then this too repeat the last action will be dull, so
this proves that if you use A4 or Control +W then it comes in repeat the last
action, so remember one thing in the shortcut menu which is called recently or
common common use commands, it is not recently, it is common use commands and
the second thing is that you can change the cell style, the third thing is that
you can repeat the last action using f4 and control plus Y, you can work with
it, well after that this shortcut menu of yours, as I told you earlier, it can
be done by selection I right clicked on it and a shortcut menu came up. This
shortcut menu does not have any relevant commands. It does not have any
commands in it. It just has the most commonly used commands. And you can
understand that it is a mini tool bar that comes in front of you. You have to
make a selection. So this is our first thing which we call using the shortcut
menu. The shortcut menu is used in this way. The next thing is Customizing Your
Quick Access Toolbar. Customizing Your Quick Access Toolbar which is the Quick
Access Toolbar and is present at this place. We call it Quick Access Toolbar.
Well, to customize it, you see a small button here and it opens. So its first
question is how to display the Quick Access Toolbar below the ribbon. How to display
the Quick Access Toolbar below the ribbon. How is it displayed? The first
question is, there are a few commands in it. There are one, two, three, four,
two, three commands. You can see by clicking on the menu, you can see that it
is showing with the title bar. Click here and click show below the ribbon. Then
it will come below the ribbon. To remove it, click here again and now the
ribbon will come to the top. And one more thing, here I will tell you another
command, its name is unto command which is here. You can give this unto
command. The previous action that we did was unto delete, that is, we deleted
it earlier. If we press control G, it will come back. I select all these and
delete them. I realize that I did something wrong. Either I press control G and
it will come back. Similarly, I select this and change its color. So I feel
that the color is wrong. So I press control G and it will come back. When I I
delete them like this, select them and delete them, right click and then if I
press Control G then it will come back. So some things can come back. These are
called undo commands. Control G does this. Its shortcut is and secondly, one
action cannot be undone. For Apple, you have saved this file from here. You can
just browse and give it any name and just press save. Now this cannot be
undone. The file has been saved. All the actions in the file menu cannot be
undone. If you export it, it will be exported. It cannot be undone. So I told
you two-three things. One more thing I had to see here was that I have undo'd
this undo command. You can add it with Control G and there was another command
related to it. It was how to add and access new commands to the Quick Access
Tool Bar. How to add new commands to the Quick Access Tool Bar?
Let's try this also practically. This is our Quick Access
Toolbar. You right click here and I add Short Sentences here. See, now click
again and add Short Sentences. Then click again. If you want to create a new
command, then go to More Commands and see here, I add L Center to it. Ok, so
you see, the center is also added. To center anything, I do it from here. Now I
can do it from here also. Ok, so customizing can be done in Quick Access
Toolbar. Commands can be added. Like, they can be added, they can also be
removed by right clicking. See, you can remove commands and remove them also.
So both things can be done. Things can be added and can also be removed. Yes,
take a new sheet. Now we have finished this. The next thing is customizing. And
the next thing is Working with Dialog Boxes. Working with Dialog Boxes What are
Dialog Boxes? Dialog Boxes are of two types. Firstly, we have Typical Dialog
Boxes and the second is Step by Step Dialog Boxes. Okay, both types are there.
Firstly, we have Typical Dialog Boxes. These Typical Dialog Boxes are like the
ones that come in our file, Save As or Save as, then it comes in Browse. This
is a Typical Dialog Box. We cannot do anything behind. If you see behind, it is
not clicking anywhere. You have to save it or cancel it. When you cancel it, then
you can do something behind. Okay, and like this, I will give you another
example, that is Auto Correct. If you come in the file, then it comes in More
option, then this option has come. This is such a thing that here also you
cannot do anything on the bag. You can not do anything behind it. You have to
click OK, you have to cancel, only then you can do something. This is called a
typical dialogue box. The next thing that comes to us is what is called a step
by step dialogue box. This step by step dialogue box asks you a question and it
means I want to make one into 100. So suppose I came to home and here I did
find and select and here it came in replace. This replace dialogue is find one
and replace with 10 and replace all. When I replaced it, you will see here that
we can click back, whereas in the previous step by step we could not click. So
this next step by step dialogue box is where the steps are completed, it is
closed, we do our work, it is closed. So we had two types of dialogue boxes. I
told you about the typical dialogue box. Without working in the box, one cannot
press OK or cancel, that is, one cannot work on the worksheet without pressing
OK or cancel. And step by step dialog boxes do not get OK, they close, but they
have the specialty that one can work during this. Next we have the Navigating
dialog box. Navigating in the dialog box means moving here and there by
keyboard. With the help of keyboard, I come to the final place, find and
replace. Well, here I am here, here I am pressing find and replace. Now suppose
I am here, so first of all, the tab key is used to work here. You can see that
to move the tab key, I am pressing it, it is moving from place to place. And
secondly, you press Alt here, here the Alt key is not working. And this Tab key
is used to move forward. If you have pressed reverse, then the Tab key is used
to move forward. So Shift Tab can reverse it.
Okay, the tab key is there, suppose I am on Find, then
you can go to Replace with the right arrow key, you can go to Find from the left.
Now you can do Alt D, that is, here it is clicking up, you can move forward and
backward from left right.
Replace Alt D and Alt P, you see, I clicked on Find Place
here by shift tapping, when my cursor comes there, my cursor comes there
[Music], okay, we were looking at the dialog box, you can move anywhere with
the help of keyboard tap key, and if you want to tick the match case in any
command, then the space bar is used, if you click once, it becomes fine, if you
click the second time, it goes down like this, the tick gets cleared, so this
was the next thing that I told you, working with the dialog box, I am telling
you about navigating. You had activated the controls here, it is active, it is
active, so you can use this space, similarly this comes back, here also you can
see I pressed space, it has opened, move up and down with the help of arrow
keys and whatever you want to select, enter it there, this can also be done,
this was the main dialog box, just like in front of format, you can see three characters,
if you enter it here, then a separate dialog box opens, if you cancel by
skipping, then skip, this will also close, so this was doing navigation, the
first command was navigation, sorry, it is going on, yes it is going on, okay,
let's go ahead, the next command is with me, using tab dialog box, I have done
navigating, now using tab dialog box, these are the tab dialog boxes, these are
the tab dialog boxes, these come in front of me or you in this dialog, the way
we see, This is the formatting
Click here to see the font
The entire dialog box is in front of us
Now if you want to move here, then you can do control
page down and control page up. You can see that the tabs are changing from down
as well as up. Well, here I wanted to tell you that you can control the tab
dialog boxes from control page down and control page up. The rest of the work
is done in the same way. If you tap, you will go inside and you can replace or
change anything. After that, the next thing that comes to our mind is Task Pane.
Task Pane was used a lot in Mac Office 2016. Now if we insert any picture here,
for example, I copy any picture and bring it here, I insert it here and bring
any symbol, you can say insert this, I bring any of our Word Art, bring any
Word Art, then here we write Microsoft Excel, Microsoft Excel and now you can
insert this. See, this came in front of us. As soon as I clicked on it, you can
see here that the shape format comes with us. Now the command here is called
task pan. Its task panes are very diverse in nature. They can be closed. For
example, when you click on an empty space, you can see that the shape format is
gone. The use of task panes was more common in Office 2016. Now in Office 2021,
task panes have been reduced a lot and most of the work is done through the
ribbon. So this was our task pan which we cleared. The next thing is using task
pan. This is using task pan. Okay, so let's say that special task pan for
selected items. Items that come in front of us to select special items. Next,
there is a little practical that I would like to tell you about the first
worksheet. First of all, I will close this file with Control Double, I will not
save it, I will create it again, so first of all, we will see the command that
comes to us, now we will have to create Creating Your First Excel Workbook. If
you want to create your first worksheet in Excel, then there are some things
that I will tell you along the way. First, how do you start your worksheet? You
can start it like this, brother, this Excel worksheet is New from the File menu
and its Control + N key is Control + End key, OK, and you can open it from File
and New, Blank Workbook. It has opened, OK, and you can close it with Control
D, you can also bring a new sheet with Control A, that is, Control A, and the
close command here will be, Janaab Control + Double, this will be, and Control
A will close the new Control Double active file here, after that, I have
created this first sheet here, first of all you Here we will create months and
on the other hand we will write projected sales. We will create two things
here. So first of all, we have to repeat the command that comes here, fill in
the month names. I fill in the month names. It does some work in Excel itself.
Whatever the month number is, from here to a13, that is, you can see this small
point here. You keep the mouse here and click on it. Till a13, that is, till
December, you keep the mouse here and close it. Then you will see that the
month names are automatically repeated and appear in front of you. Now we have
the projected sales in front of us. I will make it a little bigger by pressing
it here and here I will write its sales. Which is in the month, it is
approximately 00 00 dto 500. You can write 500. After writing this, you will
write a formula here in b3 equal to and that is b2 and will attach it steric
steric is used for attaching 103 p percentage now when you enter the number
then you will see 517 has come i.e. this is about 3.5 increment in everyone's
cell if I drag this and take it to 13 p then you will see everyone's cell has
come separately every ma is updated so here you will note another thing that in
the first two cells what is called decimal places was not there in the first
two cells after that it started getting generated first there is two then five
five has been generated so I auto filled it till here now the next thing comes
format numbers I have entered cell data in front of us so now formatting number
comes formatting numbers decorating it according to your wish arranging formatting
numbers ok Yes, in this we will do like this, in formatting numbers, we will
select numbers, come to home, come to group and here you will come to number
group and here you will come to general, then you see general currency and from
here you will select currency, I have made it currency, usually in the country
where we are here, RS is used and two dual places are used, dual places, okay,
I will see this, currency has come, after currency, if you come down, in number
format, something like euro etc. is coming, let's put it in English, by
selecting it, sorry by selecting it, you can make it in English like this, it
has come dollar, okay, so if you want, you can also change its format number by
selecting it, the way it comes up here, here number general no specific and if
you do it in currency in number, then Now the next thing that comes after this
is can you decrease the decimal places of this or if you click here then you
will see ink
Increase decimal places and decrease decimal places are
two. Each one has two decimals. So if I click on them twice, you can see that
the decimal places have been closed. You can select any cell and close the
decimal places like this. I have worked in format. Now the next thing that we
have is making your worksheet look a little fancy. If you want to decorate it a
little better, then what will you do for that? Select all your cells and keep
the same thing here. Do Control A. Then also it will happen automatically. It
will be set as much as your worksheet is. So you have done Control A. And after
that you come to Insert, then you come to Tables. Here you click on Table and
press OK. You can see that it has been made very nicely. So this is the default
style. Which has come in front of us. If I click on it, then this table design
will also come here. Okay, here its style also comes. This style is in front of
you. You can select any style. Okay, so the work we were doing was to make it a
little fancy. So this is done. Next comes the summing of the values. What do we
do for this? Click on any cell anywhere. Like I click here and here. Now what
will you do, you will come inside the table two. So see this here. After
inserting home, you will see here the table formatting style. This is insert
data. Page layout. This is insert table. And in the table we will see here that
okay, so I was talking about summing. We are giving a project to sum the
values. So here I want to sum it. So after coming to home you will come here on
auto sum. If you click on sum here, then you will see that all these have been
summed and deposited here below, so this was the method of summing, in which
the values are summed, apart from that how to make a chart, to make a chart,
you will click anywhere on any cell and come to insert, here you will come to
chart and click on commented chart, anywhere, usually this is the chart, okay,
it says that you select the names and columns etc. yourself, so it is better,
set it and click on the chart, then you will see some editing of it here,
simple, okay, so you are seeing that a simple chart has been made in front of
you in which month wise details are given that how much is the earning and it
has been shown through wave, so this is a simple chart, if you want, you can
change its format, you can make it in any way, you can see below there are
other types of charts also, so the format is After that, change the chart type,
change the chart type, whether you want to make it pie or column, as you wish,
you can display it as you want. This was our first document, which is called a workbook,
we created it, so I showed you the work of creating a chart, after that there
is printing your worksheet. To print your worksheet, you will see that the
print preview is displayed in front of you. Since we do not have a printer, how
many copies do you want to take out, press the print button and the print will
come out. You have to select the printer here. No, so the Fox PDF printer which
is selected is yes, this thing is very important. Do you have to take out the
entire sheet or do you just have to take out the selection. Now I will show you
the difference between print active sheets and print selection and this entire
workbook, selection and active sheet. If I just print directly, then it will be
printed completely. So if I just make the selection, that means I can print
only from here to here. I want to print till 10000 I don't want a chart, you
select it, file print and here it is called print, here it is called print, the
selection is just print, it has disappeared, now only the selection is printed,
so the rest of the settings are portrait landscape, you are seeing, do you want
to print a page or landscape, do you want to print portrait or landscape, okay,
this setting is done, after that there is the page size, legal and A4 are used
more or letter, after that let the margin remain, do not set it, no scaling
happens in scaling that many times your columns go on more than one page, so
fit column one page or rose both of these are more useful, then fit sheet one
page this is also useful, by shuffling it takes all the data on one page, after
this you can print, if you want to see the next page then it will be like this
and from here you can print If I can print then what will the printer do now
when it will make a PDF of it and give it to us in the form of a PDF. See, I
have made a selection of the PDF and if we zoom out then you will see that the
portrait has been printed. If it was done from this side then it would have
been bigger from the long side. So I have told you how to print. A few commands
are used to print from Control P and this command is called saving workbook.
Saving your work is usually done by saving in a file or by pressing Control S.
The use of this command is for printing. Write it here by pressing Control P
and similarly, the semi workbook will be Control S and apart from this, save S
will be done manually.
If this is a 12 year old shirt, then when you start saving, you tell it your location, browse and tell the name of the file, tell the type of file, then it will be saved, usually the type is Excel workbook and here the name of the file is there, then click on save here, so this is a simple way to save any file, we can save the workbook here, so okay, this was the lecture till here, our today's lecture is over, when I got this..........................
No comments:
Post a Comment