Welcome to this Excel basics video tutorial. being best at Excel is one of the most valuable
skills you can offer to your employer or your team members in this tutorial i will be showing
you the very basics of excel that you need to know in order to get started with Excel
There are some slight differences in various Excel versions but most part you will be learning
in this video will be applicable even if you are using the older or a newer version than
the one I am using my basic profession is mechanical engineering and I have been using
Excel for the last twenty years and as a beginner you might be thinking why Excel is so important
in this modern workplace environment and the reason is that Excel provides you an extensive
set of features for managing and analyzing data so when you click on Excel icon on your
computer you will be presented with this screen on the right hand side you see all the files
which you have recently opened in Excel program on the left hand side you have new where you
can start a new document open where you can open any document from existing files from
your computer you have to click on this PC it will show you all the folders in your computer
similarly you can open a document from your online storage and then you can save or save
as document when you finish.So, this is these are the items on the left hand side so if
you want to open a new document then you will be presented with a bunch of templates you
can use any of these templates if you wish but as a beginner we will be using a blank
document and the Excel document is called workbook if you click on this workbook then
you will be presented with this blank workbook on the left hand side at the bottom you can
see this is sheet1 so this area is called sheet or a spreadsheet it has columns as you
can see A,B C and there are a large number of columns after Z and if you click on this
arrow here you can see that after Z it starts AA, AB and so on the rows are numbered 1,
2, 3 as you can see on the left hand side you can have thousands of rows and columns
more than you might ever need so don't worry about the exact number it keeps increasing
in every new version but if you do want to see, so just press and hold ctrl and press
down arrow so as you can see that there are large number of rows you can see this number
here so these many rows are available to you so in order to go back press and hold ctrl
and then press up arrow so you will be at row 1 so if you want to see what is the last
column then you just press and hold ctrl and right arrow so this will be the last column
and there are about sixteen thousands or so columns are available to you so you might
never need this much rows and columns but Excel provides this to you. so in order to
go back just press and hold the ctrl and press left arrow and you will be in column 1 so
at the top you can see there are many tabs available "File" I have already shown you
"Home" is the tab where most of your time will be spent. This whole area this whole
area is called "Ribbon" and as you can see there are lines these gray lines in between
so all these icons within these lines are one group of commands so these are Excel "commands"
so this is one group similarly this group of commands is one group and the intersection
of any column and a row is called a "cell" so I am here on the first cell and in Excel
every cell has a name so the way we name this cell is that first we put the name of the
column and then the number of the row so this cell has a name A1, similarly this has a name
B1 and if I put my cursor here so this cell has a name G11. The next thing you want to
know is the range in Excel so whenever you select more than one cell let's say I select
these two cells now this will become a range and this range also has a name. Because there
are only two cells in this range but there could be ranges like this so this range has
a top left cell which is H4 and the right bottom cell which is N13 so this range the
name of this range will be H4:N13, H4:N13 is the name of this range when you are putting
data in Excel technically it does not matter whether you put the data in columns or in
rows but before you start putting your data in this Excel sheet you should plan your data
entry. Although there are no hard and fast rules but there are certain things which you
will learn with experience that putting certain kind of data in columns and certain kind of
data in rows is always useful. so let's take one example this is a simple table. In this
table we have few courses. The price of a course and then the number of courses sell
in every month so this is just an example These are not real numbers. SO the purpose
of this example is just to show you how to edit cells and these type of things. One thing
you should note is you always, you almost always never have to type all the data in
your Excel there are many features you can use and you can avoid typing you can speed
up the process of data entry if you know the commands so assume that we have to enter this
data so there are few things which you have to type because this data will not be in the
Excel sheet in the beginning you might have this data on your diary or on your some other
record so there are few ways to bring data direct into the Excel sheet but that we will
be discussing later on. Let's assume that you have this data written somewhere on your
diary and you have to enter this in your Excel sheet but there are few things which you cannot
avoid and you have to type for example in this data I have these course names then the
prices and all these number of sales you have to copy from some websites where these courses
are being sold and then you have to enter in Excel. But there are few things you can
quickly automate for example these six numbers you can just place them very quickly. Similarly
if your data has months Jan, Feb, then you can quickly place these months as well so
let us assume that we have all this data typed so I just copy this and I paste it here. For
pasting just right click and when you paste there are a lot of options to paste so if
you use the first one it will keep the formatting of this data if you use the second one it
will not keep the formatting so the other things we will discuss in the next videos
but in this video we will be using this first option so I just paste this data so let's
see how to enter these numbers you just type the first number 1 then at the lower right
hand side you can see this little dot and when you hover over this dot you see this
plus now what you do is you press ctrl and keep it pressed now you press the left mouse
button and keep it pressed as well and now you drag upto the last row and now you first
release the mouse button, the left mouse button and then you release the ctrl. And now these
numbers will be entered and now for these months, you just place your cursor here and
type "Jan" the first month and then you simply drag this plus sign when you hover near this
corner, it will become plus just press the left mouse button and keep it pressed and
then drag this and all the months will be added. As you can see that there is some formatting
going on here just click on the first cell above January and you type "Sales 2019 and
now you notice that these four columns are combined into one column so in order to do
that you just select these four columns and then one way to combine is to press "Merge
and Center" just press this and this will be combined and then you can of course make
them bold and increase the font size in order to match this now the other way to combine
is if I press ctrl+z to Undo this the other way to combine is select all these and then
on the right hand side in this group in this cells group you have a command "Format". Click
on "Format" at the very end there is "Format Cells" and then this dialog box will appear
and then you have to check this "Merge Cells". so this will merge the cells If i press Ok
here these are merged but the text is on the left hand side In order to put the text in
the middle in the same dialog box you have horizontally centered and vertically bottomed
so you have to select centered in both horizontal and vertical horizontal center, vertically
center and then Ok. Now the text will be centered both horizontally and vertically. So this
is how you merge cells. In order to increase the size of the row, you just hover over the
row until you see this double sided arrow and then you just drag this this will increase
the size of the row. Similarly to increase the size of the column you hover over the
column until you see this double sided arrow and then you drag towards right column size
will increase. Now for example i type a long text here let's say I type "this is the sale
figure of April" As you can see here that it seems that this text is going into the
second cell but actually it is not All this text is still in the first cell from where
we started this text and the way you can check it either you can drag this and you can see
that this whole text is in one cell OR if you click on this cell and then you see here
at the top you will see that all this text is in this cell and if you want to edit this
text. If you click on this and start typing for example "The" you will see that the text
disappeared because when you start typing over this text, it removes the previous text
so if you want to just edit this text let me do cntl+z to undo if you want to edit this
text so there are two ways. One is you click on this text and then click on this top bar
wherever you want to put something just click and a cursor will appear and then you can
type anything you want the second way to edit is you quickly double click on this cell if
you quickly double click again a cursor will be inserted in this cell and then you can
edit this is how you edit this cell so now let's delete this now these things you have
to off course type so I just copy and I can paste here if I use the second option 123
is written here this paste option will not keep the formatting it will paste the text
in simple words but the first option will keep the formatting intact so therefore I
am using the first option now we have to "Bold" these as well so just select these and press
the bold and you can also increase the font size now these things we have to copy off
course and as you can see that now I am pasting these three columns so where I want to click
paste on the first cell, I right-click and paste so it will keep the text in three columns
so this is how you can paste if you are pasting text from more than one columns and when you
finish then you can save it by going into "File" and "Save As" and then you can give
it a name and it will be saved If you want to save to a particular folder, then you press
on this "Browse" and then on your computer wherever you want to save you can save this
file Now one more thing which is most commonly used is If for example I have some text here
and I press "Enter", my cursor will go to the next row, If I want to go to the next
column, then I have to press "Tab" and when you press "Tab", you go to the next column
when you press enter you go to the next row and if you want to go back for example you
go tab to the next column then if you press shift+tab, you come back so this is how you
browse into columns and rows just keep in mind that when you press enter you go to the
next row not to the next column if you want to change the color of the text you click
here and you can choose any color. If you want to change the background of the text,
then you click on this and you can change the background of the text. If text is too
long, for example this text is let's say anything its too long but you don't want to go to the
next column, you want all your text to stay and look in this column then you press this
"Wrap Text". "Wrap Text" and it will show all that text in one cell by increasing the
height of the row, Now the last thing I want to show is for example this column is occupying
a lot of space. If I want this column to have the appropriate space which is required for
this word "Price", then what I'll do, I will click on this border of this column and the
next column and when I see this double sided arrow, I quickly double click, now this column
will be just enough wide to accommodate the most lengthy word in this column which is
price and if you want to do this for all these columns then you select all of those and then
just double click anywhere and it will resize the just enough width. SO this is it for this
video, I hope that you find this video useful.