Ladies and gentlemen welcome to this course of Microsoft
excel
First question is what will we learn from this course?
All the basics
A student needs or a professional needs or someone wants to
learn a new skill
We will cover all those basics one by one
in the video
So the name of Microsoft excel, the name of powerpoint or
the name of word
You must have heard it sometime
You must have heard it in your school time.
You must have heard it in your college time.
It is such a useful tool
Everyone should know the basics of it
So we will focus on it
So first of all, we will understand what is Microsoft excel?
Where is it used? We will see this thing
Okay, if someone has no idea
So this course is also for him because we will cover
everything with this scrap
So first of all, let's see how Microsoft excel looks like
So let me open it and show you once excel
Then one by one I will tell you how to open it
Microsoft Excel looks like this you can see some boxes ok
if you are not familiar with it then don't worry, we will
cover it
so now the question is what is Microsoft Excel if I have to
tell you in two lines then it is a spreadsheet program
you may not have understood what is the meaning of
spreadsheet program so when we opened it here you can see
it looks like a sheet so this is called a spreadsheet you
can see boxes on this sheet what is the basic meaning of
spreadsheet we will put data in these boxes we can
manipulate it, change it, display it so what is this, it is
a spreadsheet program we are going to work in this apart
from this, where is the use of Microsoft Excel where is the
use of Microsoft Excel
so you may have seen in news channels graphs are shown,
like in COVID-19 graph is shown
that what is shown on x-axis numbers are shown on x-axis
that how much death is there in COVID-19 and what is shown
on y-axis, month is shown
March, April, May, ok so with whose help you can make that
graph with whose help you can show a chart with whose help
you can show a chart one by one we will see these things
and make it so first of all I will close this and I will
tell you what is the way to open Microsoft Excel so we have
three ways to open Microsoft Excel first way is traditional
way and what is that traditional way on the desktop, there
will be a start button when we click on this start button
you have to come down to E you
to come down to E you will see Excel 2016, version may vary
I use 2016 it may be your laptop or your desktop may be
2013 or 2007 but I will recommend you to download latest
version so that you can get maximum features so we will
open Excel 2016 simply click on it and a window will open
in front of you so this is the first way to open Excel
which is traditional way apart from this there are two more
ways which we will discuss what are they, they are
shortcuts if possible, take a notebook and note those
shortcuts so that it will be easier for you
I will close this we have understood the first way what is
the second way the same window sign will be available on
your keyboard so what you have to do is you have to press
that window sign you will get S alphabet on your keyboard a
window will open like this below you can see type here to
search so what you have to do is you have to go here and
enter Excel
I have entered Excel and here I can see open, I will single
click on it and the same interface will open the same
window will open which we saw in the first way so what is
this, this is the second way
I will close this and show you the last way what is the
third method on your laptop we will press the window sign
again this time we will not press S we will press R
this is how a run dialog box opens here what you have to do
is you have to put a simple Excel and press enter this is
the same interface this is the same window which we saw in
the first method which we saw in the second method so these
are the three methods to open Excel prefer the second or
third method so that you look pro so that you know that
there is a shortcut so we will mostly prefer the second or
third method so let's close it and open it again so we
understood what Microsoft Excel is
is a spreadsheet program and what we do in it we enter the
data so let me open it
when we open the excel for the first time, then we see
something like this like this
in this portion we see green and here we see white so what
are these things?
are you able to understand these things?
so let's see this first
here it is written as recent in recent whatever work you
have done you have saved that file somewhere so what is
this that I have worked on a file and I have saved that
file so what it will show me it will show me the name of
that file on which I have done the latest work after that
it will show me the files which I have worked on books.xlsx
now I will tell you what is this so what is this this is an
older file on which I have worked what is this file, this
is an older file on which I have
before this is open other workbooks, we will talk about
this later what it means is that by browsing the file which
is saved in the storage like our drives, c drive, d drive
you have saved a file there and from there you can pick up
a file and open it, so we can do that from here so this
thing is clear to us on this file I have worked on the
latest we will visit this again when we will put some data
on a file and save it then I will open it again and show
you then you will understand the name
that file and you will see it at the top the things which
you can see in the white portion here is a blank workbook
and here you can see search for online templates now what
are these templates, something is written here it is
suggesting me business templates, personal templates
planners, trackers, lists, all these are templates so the
question is what is a template so what is a template it is
a pre-designed sheet and it has been designed and given to
you like there is a software of canvas or
is an application, if you have ever seen or used it so what
happens in that you open that application you have to
choose a template and you have to edit the things here also
the same thing, we have to edit like I clicked on the
business template so here you can see a lot of templates
related to business
I have to prepare an invoice for a business so what is this
here is a template of invoice here I have to edit the name
of the company
I have to put my company's name instead of my company's
name now these templates are for those people who are
non-tech people who don't know excel that much templates
are made for those people so that they can go straight and
edit things
I will work on a template because if you make it from
scratch it will take a lot of time so what we do we work on
templates which is easy for us
I will close the template
So we have seen business templates, there are many
templates like I have to prepare the monthly budget of the
company, I have a template, okay, apart from this, what are
the templates we have, we see
Here if you go to personal, you can choose personal
templates like loan calculator
You just have to edit things You can prepare a to-do list
of household, we have many such templates available
Apart from this, you will get to see many templates in the
section of planners and trackers
Here you will get to see the templates in the list
In the budget, if you want to prepare a budget of a monthly
company or personal monthly budget then what it can do
simply click on this template
And what things will he get to see?
I will show you
Budget I went to personal monthly budget
Here is my personal monthly budget
In this personal monthly budget
Let's see
As it happens that everyone's income is different
Everyone's expenditure is different
So now I got this template
So now what I have to do Simply I have to make changes in it
Like dollar
Here this amount is written something else What I have to
do here
I have edited it
Now I have to
Put my projected balance
Here What I put I put dollar 2,3,4,5 I changed it
Here the amount I put earlier was something else
Now it is something else
So in this way
What you can do
You can change things
here it is written that you can edit anything here it is
waste removal, instead of waste removal you have to write
something else you can do that, I don't want it, I just
want waste so I can also short it here so it changed, so
working in a template is easy like this you must have
understood how to work in a template so you can choose any
template and work in it
I will close it from here
So, we understood that we have multiple templates available
You can search online templates from here
You can download and use it
Apart from this, there is a blank workbook
We are going to do our work on the blank workbook
We will open the blank workbook
Click on it
Now what we are seeing is the interface of Excel
Which you will see for the first time when you open it
Now what I can see in this
A, B, C, D, E, F, G, H, I, E
This is what we can see
Here we can see some counting
Apart from this
If someone finds this interface strange
Because no one must have used it before
Then I will tell you everything one by one
What is this?
Here you can see boxes
There are many boxes here
What is the meaning of this box?
What is the meaning of this?
What is it called?
So, first of all, we start
Let's start with these boxes
Select any box
Like I selected this box
This box is called a cell in Excel
Understood? So what we will do in this cell
We will enter data in this cell
Like if I want to enter data on it
I have to enter my name
Or if I want to enter numerical data
So what we will do simply
Like I put 23 here
Apart from this
I have selected this cell
I have put my name in this cell
Here I have put my name
So whether it is numerical data or alphabetical data
You can put it in this cell
So all these boxes that you can see
All these boxes will be called as Cells
Now one thing you will notice that when I select this cell
and whatever data I will put here you will see it here you
will see it in this section this is called formula bar
formula bar is very important we will cover it in next
videos here for now whatever data I will put you will see
it here
I will put 25
you can see formula 25 in formula bar now when we put
formula in excel always remember one thing we are working
on data but we are working through cell we should know the
name of cell like this cell has data and this cell has data
I have to add these two data I have to sum them so I should
know the name of this cell now how will we know the name?
before knowing the name let's understand what are
A, B, C, D, E, F, G, H, I these are called columns so what
is this?
A column
B column, C column, D column
E column, F column and in counting these are called rows
like this is one row
And what is this?
What is this whole?
column understand row and columns so how much it will be
one question is how much it will be in this spreadsheet how
many columns or rows will be there how to know this so what
you have to do you have to do a simple thing let me tell
you a short cut if you want to know column number you have
to press control button in your keyboard and the keys of
arrows in keyboard you have to press down arrow key ok see
here we have come to the last row ok how much it is
10,48,576 we have so many rows now if I want to go back
then what I will do is
I will press the control button and I will press the up
arrow key and I will go up in the same way what I have to
do if I want to know how many columns are there in my
spreadsheet then what I will do is
I will press the control button and the right arrow key and
I will reach xfd this will be the last column now I have to
go to the starting column here you can see a name this is
called a name box in which you can see the column name now
the column name or the cell name is made up of which two
things let me tell you, first let's go back
I have pressed the control plus left arrow key
I have come here to the starting cell now here you can see
in the name box A1 is written now what is the meaning of A1
A1 means the name of the cell in which the column will come
first and then the name of the row what is the name of the
column? A what is the name of the row? 1 so what is the
name of this cell? A1 you will always see this in the name
box you can select any cell for example, I have selected
this what is here? D is the column and what is the number
of row? 5 so what will be the name of my cell?
D5 and where will I see this? in the name box now one more
thing comes with cell cell and active cell now what is the
difference between these two?
all the boxes that I can see on this spreadsheet
I can call all those boxes as cells ok but the ones in
which I enter the data ok like currently I have clicked on
this cell ok what I will call this cell
I will call it as active cell ok and the rest of the cells
you can call them as normal cells ok like I have to sum
this cell and this cell
I will explain again what is active cell for now what is
active cell which cell I will call the one in which the
data is stored on which I have to perform the operation
that will be called active cell everything is clear till
here ok
After this, let's see what is written here like book 1 and
excel
So what is book 1?
You must have seen that you save any file
Generally, when you save, you put a name for it
But now we saw that we opened excel directly, so we did not
put any name
When we did not put any name, then what happened here?
By default, excel took a name and put it as book 1
So what is this?
This is the name of the file on which we are currently
working
We can change this and we will do it
After this, what is this thing that is written in excel?
This is the name of our software
So what is first?
The name of the file and then the name of the software
So many things are clear to us
After that, what is this?
You can see here that there is a file
Home, Insert, Page Layout, Formulas, Data, Review, Views
What are these called?
Please tell me
so let's go one by one from here to the file this whole
section till here this whole section is called ribbon now
what is ribbon? inside the ribbon all these things are
there now what is inside the ribbon? inside the ribbon
there are tabs like file tab or home tab inside the home
tab also you will see insert tab page layout formulas tab
data tab review tab, view tab so what I will call all
these? tab so this whole portion you can see this whole
portion I will call ribbon inside the ribbon tabs
available with different names like home tab, insert tab
now inside the home tab some groupings are there like on
the home tab when I clicked see this portion this is
clipboard group after that font group after this alignment
group number group styles group cells group editing group
and along with this you can see a small button what is the
purpose of this? generally we don't have to use all these
things like cut, copy, paste normally we use this so all
these things we can't present inside the
because then it will become glitch type what we have done
is we have kept the main things inside this if I want
anything else and like this a window will open inside which
I can do other things is it clear? now let's close this
cancel this so I understood first of all what is ribbon?
what is inside the ribbon? multiple tabs are there
groupings are there clipboard group, font group like this
till here everything is clear we have seen the formula bar
that whatever we will write inside the cell
will we see that? inside the formula bar apart from this we
have seen here what will come inside the name box? my
cell's name will come after that if we go down here we can
see sheet 1 and after this here is plus sign now what are
these sheets? generally what we do is here are multiple
sheets if I click on new sheet then one more sheet will
open blank sheet will open on plus sign if I click again
then sheet 3 will open now what are these sheets? suppose
you are in college in college there are
classes like BCom class, BCA class
MCom class now what I have to do is I have got a task that
I have to prepare a data in this sheet where I have to put
student's roll numbers and their names but that should be
of BCA students and then I was told again that you have to
do the same for MCom and BCom students so if I do
everything in this single sheet then it will be very
difficult for me so what I do? what I do in sheet 1?
I put data of BCA students what I do in sheet 2?
I put data of BCom students what I do in sheet 3?
I put data of MCom students now the names of these sheets
we can change now I want data of BCA students so I can
rename it and I can write here
BCA
I have written BCA and entered it, so this is the BCA sheet
I have to do BCOM here, then what I will do, I will right
click and here again I will do rename and now what I have
to do
I have put BCOM and then I have entered understood, we can
also change the name of the sheet what will happen with
this, now I will not be confused
I know that the sheets of BCOM students are different and
on the third sheet
I can put the name of BCOM, so till here it is clear
after that we can see the zoom option like you can see this
cell if i want to reduce or increase the size of this cell
or if i want to increase the size of this workbook then we
will click on the plus sign let's see what happens are you
watching? what happens with the plus sign? it keeps on
zooming in and how much we can zoom in? we can zoom in up
to 400% and if you want to zoom out then you can use the
minus sign you can zoom out and how much you can zoom out?
you can zoom in up to 10% when i
in 10% then you can't see anything because the size of the
cell or the size of the workbook has become so small that
it is not possible to work so let's set the default size to
100% so till here it will be clear that when we open the
excel then what kind of interface we can see and in this
interface the boxes that you can see what are they called?
they are called cells and the cell that is made together if
i have to give a definition of a cell then what will be the
definition of a cell? where
column and where my row intersect cut each other there what
will i call that place? i will call that place cell for
example, the column of K has one line here and the row of 6
has one line here one point here, one point here and one
point here so this whole portion this whole area i will
call cell so the definition of cell will be clear ok after
this what we have to do? after this we understand that this
button what is the use of this button? this is directly
written save button what you can do
here? you can save things from here you can save a file
directly so for this video that's all ok watch it again if
you didn't understand in next video we will know in depth
what we can do in excel take care [Powered By Dubverse]