So Yo what’s up Youtubers. Welcome back
to my channel. I am Divyansh and you are watching
DJ’s Creativity and in this video I will
be telling some of the most important and
basic excel functions and formulas which you
need to know if you use it. So friends, let’s get started.
 
SUM: This is the most basic function used
in Excel. This basically gives the total of
the numerical values from the area specified.
To apply this function, go to cell where you
want the sum too be displayed. Then type in
=SUM and then a bracket. Now, you need to
select from where we need the sum. Then press
ENTER. You will see the sum of the values
displayed
DROPDOWN LIST: Sometimes in spreadsheets we
see some drop down lists where we can choose
a value which is available. To do this, go
to the cell where you need the Drop-Down List
to be made. Then, go to the DATA tab on the
ribbon. From there, click the Data Validation
button. In the pop-up box which appears, go
to the Settings tab and from the drop-down
list for ‘Allow’, select List. Then, a
new bar appears from where you need to select
the table from which you want the list to
be made. After that click ENTER. The, press
OK. You will see a small arrow like triangle,
clicking on it you will see a drop-down list
of the things which you selected. In my case,
it is the product name. From here, we choose
any product of our choosing.
SUMIF: This function is used to display a
specific value from a set of values given.
For example, when you select the product as
Laptop, the value displayed is 1000, which
we have specified as the value of Laptop.
To use this function, type =SUMIF and then
a bracket. As you can see, here we have to
select range, which will the total data which
contains the requires things. Here, I will
select the whole table containing the products
and the values. After that, put a Comma (,) and
then we need to enter the cell for which we
want the corresponding value to be displayed.
Now, we need to select the range in which
we have the corresponding value. After this,
press ENTER and then enter the product name.
You can see the specified value of the product
is displayed. Here, the cost of Laptop is
given as 1000. If we select it as Tablet,
the value comes out to be 500 which is the
corresponding value of Tablet.
IF: This is used if we want a certain thing
to be displayed if a specific criteria is
met and the other if it is not. To apply this,
type in =IF and then a bracket. Then we need
to select the value from where we want the
criteria. Let it be Total Sales and then we
need to write the criteria. I am writing if
it is greater than 7000. Then a comma and
now we need to select the value to be displayed
if the criteria is met. We need to put there
in inverted commas (“ ”) Let me choose
if the Sales are greater than 7000, then the
value be NICE. After a comma, we need to enter
the value to be seen if the criteria isn’t
met. I will be putting it as average. After
that press ENTER, and you will the specific
value according to the criteria. As you can
see, the total sales are greater than 7000,
so it has displayed the answer as NICE. Now,
if we reduce the value of one of the products,
let it be 600 and press ENTER, then the sales
go down and the value changes to AVERAGE.
CONCATENATE: This is used to compile some
large amounts of data. For e.g. We have a
lot of names for which we have the first and
the last name separated. We want the full
name to be displayed in another column for
some other work. To apply this, we need to
type =CONCATENATE and then after the bracket,
we need to specify the first text. Here I
am selecting the first name. Then, add a comma
and now we need to enter the second text.
If we give the last name here, then there
will be no space between the names. To add
spaces, just put two inverted commas with
a space in between (“ ”). Then after another
comma, we can specify the second text and
so on. Here, the second text will the Last
Name. After that, press enter, and you are
done. As you can see, you will see the full
name put together. See
So friends, that’s all for today. If you
liked the video, give it a big thumbs up,
like, share, and subscribe to my channel.
Meet you in the next video. THANKS FOR WATCHING
