Hmm I want to change the way it looks
I don't like it this way
See we have some options here in the ribbon from home tab
Alright! and this is our font group
Look at this
You can use bold italic etc from here
Similarly you can change the font colors
cell colors font size hmm
font style. However from here you cannot apply superscript and subscript
click on the right mouse button
In the name of Allah, the most merciful and compassionate
May peace be upon you
My name is Abdul Haseeb and today we are here
with our fourth session
Today we are going to start our fourth session and this is the first tutorial of fourth session
Topic of this tutorial is Excel Fonts (Please watch the complete video till the end. It will benefit you I guranteed Inn Shaa Allah)
Let me tell you first that our fourth session
will be about the formatting
Alright! we learn few things about formatting in our previous tutorials
because few of those things about formatting
were needed at that time. But now we will understand
formatting in detail
and without wasting any time
let's begin but before we start
I want to aplogize because I was not uploading tutorials
from a long time
and we take too much time in launching our fourth session
before that I was uploading on regular basis
but
actually I was very busy
and because of that
I was unable to make and upload new tutorials
but now I am back so Inn Shaa Allah
I will try my best to upload regularly
and I will confirm my new schedule
of uploading related to tutorials very soon Inn Shaa Allah
and we hope that you will cooperate
with us. So let's begin
Ok so you guys may be familliar with this data
those who watch our previous tutorials must have knowledge that we use this data once before
but today the purpose of this data is not the same
look what actually happens sometime
as we have all this data today
what we wanna do is that
we want to increase the size of some values or text from this data so that it becomes more visible
For example the names of the months here and this average
and all these totals
I want these to be more visible and bit large in size
so we have different things
or may be I want to change its font
basically what I wanna say is that
I hmmm
want to change its look
I want to see it in some other way. I don't like it in this way
so here we have some options from the ribbon in home tab
and this is our font group. Alright
We have some options here like we have this font option
Calibri this font is selected by default
okay now here we open fonts
and the amazing thing is
sorry I am sick today
that's why I am facing difficulties while speaking
hmm the fonts we have
this is an amazing feature of excel that whenever we move the cursor on different fonts
It shows us the preview behind the fonts list
It shows us that what our text will look like by selecting that particular font
softwares with such feature are very useful
there are many other softwares that don't give you a preview
and it can create many issues
such softwares waste lot's of time. But we don't have such problems with excel
You can see we have too many different fonts here
if you are doing something related to buisness
then this font Times New Roman might be the best fit for you.
Now what I say don't change the font let it be as it is
because font...hmm
for example I am not getting what I want from changing the font
as I want it to look big a little bit and its not happening by changing the font
so we also have solutions for that
here is the font size
font size is mentioned on the right side of fonts. Click on it
You can see that it is showing us the preview of font sizes as well
from here I can increase its size according to my needs. Okay I make it too big and it is looking awkward
let it be like this
looks better now. Now text is so thin
I want it to be a bit thick. So what I do now there are different ways to do that
there is B written right here for bold
and if we hold the cursor on it excel will also show us its hot key
we click on it and the text is bold now
similarly by clicking this button again we turn it back the way it was before. You can also do this by using its hotkey ctrl+b
so we can bold the values like this
okay let's understand this one thing
you may have observe
that whenever we bold the text in excel
It takes more horizontal space
for example we select these cells like this
you see the border of the cell that is created when we select the cells
the letter E of average is almost at the center of this border
but if we make it bold then it completely penetrates the border
when we bold the text in excel
it takes more of the horizontal space mostly
we don't give value to such things but it is important for us to understand this factor
so
therefore
if you select the numbers from here instead of text and then we make them bold
so you see they don't take any extra space
if you bold the numbers instead of text
then numbers will remain on the same place they were before but if you bold the text in excel
then text takes more horizontal space
so this is one thing. Moreover
changing these fonts or make the
text bold there are different ways to do that.
I show one of them
Other than that there is a button in font group called
Dialogue Box Button
sorry
if you click on it there are many different
fonts
you may have not all these fonts I download many of them
how to download and install these fonts I will tell you about that
later on Inn Shaa Allah
there are different fonts okay
and you can change the font from here
like you do before from the ribbon
you can also bold it from here
easily or let it be regular as it is rightnow
you can change the font size from here
you can do such things from here also
these are two or three different ways to do that.
Moreover
there is one more important thing to understand that
for example
a very common formula of H2O is mentioned here
we read it
so how do we write this H2O like this
for example if I write H2O here
and press the enter key
It will look like this and its not happening
so what I will do to make it like that one over there
I will turn it to edit mode
I already told all the ways to turn a cell into edit mode in my previous tutorials
here I am using one out of three
which is to double click on a cell and it will turn the cell into edit mode
now what I do here
press the right mouse button click on Format Cells
and from Format Cells select subscript
we select the number 2 so that the excel apply subscript feature
on number 2 only from H2O
so you see that you can perform this task from Format Cells also
and if for example
its not
compulsory in every situation to use font group from above
if for example you want to bold these values
then select them and press the right mouse button
and it will open the Mini Toolbar
We discuss mini toolbar in our previous tutorials
and now you will learn more of its uses here today
you can bold these from here
and you can make them italic etc
you can change the font color
cell color, font size hmmm
you can change font style
you can change font themes
you can do many such things
but you cannot apply
subscript and superscript from here
but what you can do is that press right mouse button go to Format Cells
from here you can use strikethrough etc but you can't perform these tasks from mini toolbar
and here it is
its done. Ctrl Z undo
go again
you can do subscript or superscript as well
so all these things are included
in font formatting I hope
that now you understand formatting
that is related to fonts
and I am sure that you will like the video Inn Shaa Allah
and as I told you earlier that I am sick rightnow
and facing difficulties while speaking
but still I hope that you understand it all well
so if you like today's video then click on the like button and also subscribe to our channel
and please don't forget to share our videos
also please click on the notification bell icon so that whenever we upload a new video then you will get the notification
and Inn Shaa Allah we try to upload quickly from now on
and please remember us in your prayers because if you don't pray for us
then we can't achieve our goals
moreover
right now its our
formatting
session and you will learn many new things in this session also Inn Shaa Allah
and those who are new with us
and they are confused about things like formulas etc etc
so they can
watch our previous tutorials
because as I mentioned earlier that we
are not going to repeat and repeat the same things over and over again
that is why we discussed all these things in detail to clear the concept
and please make sure that you do comments on our videos
and take care of your selves Inn Shaa Allah we
will meet you in the next tutorial
Allah Hafiz!
For more infomation >> Storm Track 8 Web Weather Video - Duration: 2:05. 
Không có nhận xét nào:
Đăng nhận xét