0:00
hello and welcome to tutorial's point in
0:02
this video I'm going to show you 15
0:05
basic tricks that you need to know in
0:06
Excel we have this sample data sheet of
0:09
ID store name country region and so on
0:12
and on this data set we are going to
0:14
perform 15 basic tricks to level up our
0:17
Excel game so without wasting time let's
0:20
get started the first trick is you want
0:23
to get to the bottom of this data but
0:25
there are thousands of rows so instead
0:27
of scrolling down you simply going to
0:29
press control and down arrow and you are
0:31
at the end of your data to go back you
0:35
can simply press control up arrow and
0:37
you are at the top of your
0:39
data next I want to edit this cell
0:43
without using the mouse so I will press
0:45
f2 and then I can delete the value and
0:49
value let's say I want to select my
0:52
entire data I can do that by pressing
0:54
control shift right arrow and then
0:56
control shift down arrow and all of the
1:01
selected next let's say I scroll down
1:05
and I do not know what this column means
1:07
or this column means right so we want to
1:10
freeze these top headers so that we can
1:12
easily navigate through our data to do
1:15
this we simply press alt
1:17
wfr and if we scroll down as you can see
1:20
the top headers are fixed now now notice
1:24
that the row Heights and column widths
1:27
are not properly aligned to fix this we
1:29
simply we select our data by pressing CR
1:31
a and then press alt H O A to autofit
1:37
row height and then alt h o i to autofit
1:41
column width and we have proper widths
1:45
Heights next let's say I want to copy
1:48
this Philippines value over here now
1:51
instead of copying and pasting I'll
1:53
simply press controlr and as you can see
1:57
this copies and pastes the exact value
2:02
side now let's say I want to paste
2:06
Brazil here instead of Indonesia now one
2:08
way is to Simply crl C copy and then crl
2:12
+ V paste it but instead we can simply
2:14
press contrl D and as you can see this
2:17
copies and pastes the exact value that
2:22
cell all right enough of the copying and
2:24
pasting things now let's say here I want
2:27
to change this value of France to some
2:29
other country now one way is to remember
2:32
the name of every country written in
2:34
this column or simply we can use the
2:36
shortcut alt and then down key and we
2:38
have all the list of countries present
2:40
and then we can just select any country
2:43
let's say I will select bellarus and
2:45
click on it and we have bellarus here
2:48
now let's say I want to select this
2:50
entire row of bellarus now instead of
2:53
dragging my mouse something like this I
2:55
will select any one row and then I will
3:03
selected now similarly I want to select
3:06
this entire column of country without
3:08
using the mouse so I'll simply press
3:11
control and then space and the full
3:15
selected now next let's say I want to
3:19
insert a row about this one to insert it
3:23
I'll just simply select this row and
3:25
then I'll press control shift plus and
3:30
similarly if I want to insert a column
3:33
right before this column B I will simply
3:36
select this column and then press
3:38
control shift plus and we have a new
3:41
column here let me undo it for
3:45
now now let's say I want to move this
3:48
row with the country of Italy to
3:51
somewhere right before Brazil to move
3:54
this entire row I'm going to select it
3:56
with the help of shift space and then I
3:59
I will just hold the shift button and as
4:03
you can see here when I move my cursor
4:05
the icon changes now I'll just drag it
4:07
down and let's say I want it above
4:09
Brazil I'll drop it and as you can see
4:12
we have it above the Brazil
4:15
row next I want to go to a specific cell
4:19
now to do that we have a shortcut I'll
4:21
press crl G and here as you can see we
4:24
already have this reference I'm just
4:25
going to remove it and here we are going
4:27
to put the cell number let's say I want
4:33
530 and if I click on okay it takes me
4:39
530 now we have the last trick let's say
4:42
for uh this sale I want to show some
4:45
specific information let's say we will
4:47
ask to show this is a medicine to do
4:50
that I'm just going to select this cell
4:53
then I'll press shift F2 and here as you
4:56
can see we have a small comment box here
5:00
I can see this is a medicine and hit
5:04
enter and now if I hover over this cell
5:06
as you can see we have this information
5:09
that says this is a medicine you can do
5:12
this for any Cale so that will be enough
5:15
for this video these were some of the
5:17
very small but very important Excel
5:20
tricks to level up your Excel game now
5:23
this file will be available in the
5:25
description for you to download and
5:26
practice now make sure to like this
5:28
video share share it with your Exel
5:30
friends and I will see you in the next
