Hello and welcome to our new video
In this video we are going to learn
in any worksheet of excel
how we can
insert an equation
now what is an equation
if I ask you
what is area of circle
you will simply say pi r square
but I tell you
that you have to write pi r square
in a cell
then how will you write
because pi symbol is not available
I have never seen a symbol like pi on keyboard
till date
so how will we write this equation
it is not possible
isn't it?
either we will go to google
and copy and paste
this is the only thing
if I ask you not to copy and paste
then how will you write
or let's take some other formula
x plus y square
so what is the formula
x square plus y square plus 2ab
now how will you write this equation
in excel
it is little difficult
even if we try
but do we have any option available
in excel
the answer is yes
to write equations easily
we have
an option available
let's see
where we can see it
first of all we have to open excel
so let's open excel
so I have written excel
and here excel
will open
excel 2016
here it is
now where I have to go
which tab I have to go
for equation
you have to go to insert tab
so let's go to insert tab
you will go to insert tab
here in last
a group of symbols is given
in which equations are written
so you will see here
many formulas
or equations are given here
area of circle
binomial theorem
other than this
Fourier series
Pythagoras theorem
so many things are given
if I want any of these equations
in my sheet
so what I can do
I will click here
and it will come on my worksheet
let's take Pythagoras theorem
so I will click here
now its size is small
let's increase its size
go to home
from here I have increased its size
so that visibility will be good
a square plus b square
equals to c square
this is Pythagoras theorem
now it was very easy to write this
why?
because we have used equation
the option given for equation
if I say that I don't want to use equation
then what will you do?
so I select any cell
and I ask you to write a square
so what will you do?
I write a and then I write 2
now if you write a2
then it is not a square
or I asked you to write pi
so we can write pi in English
like this
I increase its size
like this
you can write pi like this
you can't write mathematics pi
that's why
by using equation
we can make things easy
now let's see what we can do with equation
when I add any equation
then I have
two tabs
added
like we saw in header and footer
when we inserted pictures
then we saw that
tabs are added in ribbon
so here also two tabs are added
one is of drawing tools
and other is of equation tools
if I click on drawing tools
then what does it mean?
that you have to change
color of this equation
or change its boundary
for all these related
options
where will I go?
but if I want to do
things related to equation
then where will I go?
then I have equation tools
here we can do things
here I have many options
like ink equation
this is very important
you can call it a feature
ink equation makes things easy
for us
so let's see
so we understood that
we can change equation
by going to options
we can add
we have added this equation
I will add one more equation
again go to insert
delete it
when I go to equation
then I have
taken this equation
of binomial theorem
increase its size
by going to home
and
let's
do it here
so that
we can see the difference
it should not overlap
each other
so this one
I have an equation
so now
the question arises
if I want to change in this
this equation is already made
if I want to change in this
then how can I do it
let's see that
so here if I want to change
k equals to 0 is written
by deleting it I can write
k equals to 1
you can do these things
or here
I have
deleted n and wrote m
so all these things
you are able to do
apart from this let's go to tools
let's go to drawing tools
so from here
let's change
its background color
so I have
changed its background color
let's make it smaller
so from here
we can do these things
if I want to change text color
so I can change text color
from here
I have many options
let's keep this
text color
apart from this
let's go to equation tools
what is there in equation tools
which is very useful
there is a link equation option
which is very useful
let's see that
we have gone to equation tools
now what is this
these symbols are given
if you want to add any symbol
plus minus symbol, infinity symbol
equals to symbol
note equals to symbol
if I click here
you can see
note equals to symbol is added
let's remove the controls
I click on it
both the options come back to me
when we go to equation tools
you will see here
all these equations
are same
you will get an option
ink equation
when you click on it
you will get
a drawing
window
drawing pad
in this drawing pad
you can
simply write anything
with your mouse
let's try
suppose I want n by 2
for n by 2
I divide here
and write 2
I did this
it is showing you
n by 2
if I insert it
you will see
n by 2 is inserted
let's do it here
after c square
if I want to add something
I click on equation
I come back to ink equation
after that
I do n by 2 again
let's take another symbol
what else
you can take sigma sign
I want to take sigma sign like this
so I made sigma sign
like this
it is shown in preview
and I insert it
you will see here
that symbol is added
so you can
write anything in drawing pad
you can insert it
it is a very good option for us
what else
if you want to
add bracket
you will get so many brackets
if I want to add this bracket
it is added
I want to write something
like m
it is written
it is very easy
if I want to work with mathematical equations
what I will do
I just have to
use drawing pad
and write things in drawing pad
I just have to
use equations
I will go to equation option
I will get equations
and I will insert it
what else
do we have
what else
fraction option
if you want to do fraction
delta y upon delta x
all these things are available
you can try all these things
I think it will be clear to you
how to work with equations in excel
I will meet you in next video
till then you keep practicing