10 Things you can do Easily in Excel under 10 Minutes
123 Steps
106 followers
20 Video Views·Oct 18, 2022
Hi, welcome back to excel baby steps. This is our final video in this video
I want to show you 10 quick tricks that you can do in excel 10 things that you can do in excel
Each taking less than a minute. So let us get started. We don't have that much time
The first thing is, uh, how can you automatically sum a bunch of values? So let us say you have a set of values like
10 20 and 30 and you just want to sum up sum all these three values
So select all these three and then click on this little thing here
Okay, that symbol sigma symbol so you can automatically sum average count numbers max or min
So that's the first thing
And then excel will add the formula for you
So you just have to select a bunch of cells and then hit this thing and excel will insert the sum value in the next
cell
the second thing that I want to show you is
How can you save a excel file as a pdf?
Okay, now that this file has nice little uh expense sheet I want to save it as a pdf
You can do that. You can just select if you have office 2007
release to r2
You can do this. Of course, if you do not have r2 then you can install a save as pdf
Conversion tool like primo pdf or something
And then you can do that. So select this and then save as pdf or xps
So from here you can select the first step pdf and then say publish
Excel will create the pdf file
And then it will open it for you nicely
I'm, not sure if you can see this whole thing
Sorry for that
So this is the pdf
Okay
Okay. So the third thing that I wanted to tell you is how can you insert an organization chart in excel?
So let us add a new sheet by clicking on this little button you can also do that with shift plus f11 key
and then
insert
smart art
Hierarchy
So these are various types of organization charts
Let us select something that is fun this one
So let us show the organization chart of a hypothetical
Company so ceo
Vp hr
vp it
vp finance
vp marketing
Okay under the vp marketing you have somebody like gm marketing
Under him there is an intern
Okay, so this is a simple chart. Nothing too fancy and we have done this
In less than a minute so you can create a very quick chart
You can format them by selecting this and then choosing the colors or layout you want or something
And you can have a fancy thing
You can even have a 3d box. I'm not sure why you would want to do that
but then you can do that you can change the colors to
Something like that very quickly you can do this, okay
the fourth one that I want to show is
All the sheets have same color. So why not add some color to them right click on this and then select tab color
And then set a color like that. So that tab will look in that color different color
You can set different colors and
Of course, it will look quite ugly if you keep on doing this
but you can
Have some meaningful set of colors
for example
All the sheets where you are entering data can be in blue color and all the sheets where you're doing some calculations can be in
yellow or red color
okay, so that's
Then remember in this worksheet workbook, we have added a pivot table showing the category by summary totals
so I want to
Put a small button here when when I click on that I want to jump to that pivot table instead of navigating like this
So you can do that for example
Here right click here
to go to
P
Pivot and then i'm sorry for that because we have typed adjacent to the table excel thought it's part of the table
So i'm just moving it here click here to go to pivot
And then select insert
hyperlink
Okay, select insert hyperlink and then say places in this document and I want to go to the sheet 4
Click ok
So now you have a hyperlink that's pointed to the sheet 4 click on that and you will come back here
so you can add hyperlink not just to yourself, but even to a shape for example, this is a shape and
You can right click on it and then set hyperlink
sheet 4
So when somebody clicks on that it comes here
So when you right click on this and say edit text
click
You have made a button for yourself, of course, it's not fun. It's not completely beautiful, but then you have created a small button that hooks
then
What if you wanted to paste this table into powerpoint? So let us just select the entire pivot table
And then hit ctrl c
Come back to powerpoint. This is powerpoint here
And then press alt e s at this point excel will powerpoint will show you paste special
And select something like enhanced meta file or device independent bitmap
So I select that
And I get this nice table into powerpoint
Okay, so that's how you can paste excel you can do that for charts and anything anything works
And finally, I want to show you something
Let us say you have a cell here that is in bold
Chandu
And this is bold underline and you want to
That's my wife named jyotsna
And I want to apply this formatting to her as well. So select that cell click on this little paintbrush thing
That's called format painter and click on jyotsna and the formatting is applied to her
So this just works for any kind of thing even if chendu had
some background color
You can apply that to jyotsna as well. That's called format painter
Come back to our sheet as we scroll down. We are not seeing these things on the top in the filtering options
So what I would like to do is I would like to create a freeze here
So that I am scrolling only from row three onwards. You can do that by selecting row three
And then go to view option
And then select freeze panes
Click on the freeze panes
So now first two rows are frozen on top
Whatever I scroll I will just keep on seeing the first two rows. So that's freeze
similarly
Let's just unfreeze
You can also insert a split
See this small bar here at this corner and this corner
So let us drag that here
I get a split so I'm seeing the same sheets, but in two windows
I can scroll this independently. I can scroll this independently
But when you scroll down you will both of them will scroll down
Okay sideways scrolling is independent, but down scrolling is synchronized
So to get rid of the split again drag it all the way to the end
Okay, so now it's gone
So that's split
Then we realize that
Of course these things are there. Let me just get rid of this thing
home
clear all
I'm just going to remove that as well. We don't need that anyway
so
We realize that from column f onwards we are not using the excel that much
This is all empty, but you can keep on scrolling until the cows come home
Okay. So what I think is it's better to unhide all those things. You don't want to see them
I'm not using them anyway. So here is how you can do this
Select column f by clicking on it and then use ctrl shift
Left sorry right arrow
And select everything to the right of it and then right click
select hide
So now all those columns are hidden. I'm just seeing up to e
You can do that for rows also so that it keeps you gives you a clean worksheet. Okay, so that is
In a nutshell 10 different things that we can do a quick summary of what we have done
We have inserted auto sum using this thing. We have saved as pdf. We have inserted an organization chart
here
we have
Added some colors to this thing one thing that I forgot was inserting a symbol
So let me show you that if you want to insert a euro symbol or something fancy like that
Select the cell double click on it and then click on this symbol thing from insert menu
And then select a symbol that you want for example
Normal text and then
There are a lot of symbols so you can select anything for example this symbol
And then close so that symbol will come up there. Okay, so that's the
Fourth one then we have arranged the tabs in different colors. We have added a button
So when we clicked on it, we went to the pivot table
We learned how to paste into powerpoint or what we have learned to use this
Paintbrush format painter thing to set the formatting of two different cells to the same way
we have understood how you can
Set a freeze so that only the first two three or rows are visible all the time
And then we have learned how to hide everything that is not useful
So that's 10 things in 10 minutes. I hope you have enjoyed this lesson
Thank you so much for watching excel baby steps. You have fun. Bye. Bye
