00:00To learn computer and to become a computer expert, subscribe to our channel STExpertService
00:05So in today's video, we are going to talk about Top 10 Excel Shortcut Keys
00:09Which can be asked in your interview question
00:13Now if you have to be asked this shortcut key in the interview question
00:16Then it is obvious that this will not be an ordinary shortcut key
00:19So let's start the video and for this you have to watch the video till the end
00:24Because you should not miss any shortcut keys
00:27So let's start this video without wasting time
00:30So we have come to our computer screen
00:32As we have talked about Top 10 Excel Shortcut Keys
00:36So let's talk about number 1
00:38So number 1 is COUNTA
00:40COUNTA means to count, A means all
00:43So simply for this we will write ==
00:45And COUNT
00:47So simply we have a lot of options here
00:49But you don't have to worry at all
00:51And simply we have to double click on COUNTA
00:54So after that it says select value
00:57So simply what we have to do is
00:59We have to select value
01:01After selecting the value, it says enter
01:03So we have to enter
01:05So basically you can see our value
01:07It has come to us 17
01:09So basically by selecting 17
01:11Here we can see SN number 17
01:13And by doing COUNTALL
01:15It has shown 17 which is very good
01:17Now let's talk about COUNTABLACK
01:19So basically in these children we will see first
01:21Which children did not give the exam
01:23So their numbers will be blank
01:25So we will write ==
01:27And simply COUNT
01:29And COUNTABLACK
01:31Now we want to see
01:33Which children did not give the exam
01:35We want to see their blanks
01:37How many children did not give the exam
01:39So you can see that 3 children did not give the exam
01:41Which is exact value
01:433 children did not give the exam
01:45Now let's talk about COUNTA
01:47We will write ==
01:49And double click on COUNTA
01:51And simply we have to select value
01:53So as soon as we select the value
01:55Simply we have to press ENTER
01:57So you can see that it has shown COUNT
01:59But here we have to press X
02:01Here also X
02:03So you can see that
02:05It has reduced 14 to 14
02:07So what does it do?
02:09It selects the digit
02:11It does not select all
02:13It selects all
02:15And only COUNT will select the digits
02:17Which will be the value of X
02:19It will not select
02:21But if we enter
02:23Then it will change
02:25But we will do it again
02:27So that we do not have to change the list
02:29Now let's talk about SUM
02:31SUM means to collect all
02:33So simply we will write SUM
02:35And double click on it
02:37And simply we will select all
02:39And we will collect the value
02:41Simply we have to press ENTER
02:43So you can see that
02:45SUM has come to us
02:4753.27
02:5075
02:52But if we want to calculate the AVERAGE
02:54So we will write AVERAGE
02:56So simply we have the AVERAGE option
02:58We will select all
03:00And if we press ENTER
03:02It will calculate the AVERAGE
03:04But we need 2 digits after AVERAGE
03:06So we will press CONTROL ALT
03:08And 1
03:10So it has shown us AVERAGE 3.84
03:12So how easy it is?
03:14Now let's talk about SHORTCUT 3
03:16Which is MAXIMUM and MINIMUM
03:18We want to see who has taken the maximum number
03:20And who has taken the minimum
03:22The one who has taken the maximum number
03:24Will be our TOPPER
03:26So we will write MAXMAX
03:28And simply we will select the RANGE
03:30You can see that after RANGE
03:32We have 5
03:34So the one who has taken 5 out of 5
03:36Is ANJALI G
03:38So she has basically topped
03:40She will definitely be rewarded
03:42Now let's talk about IS EQUAL TO MEAN
03:44So those who have less number
03:46They should work harder
03:48So that they can be successful
03:50So basically 1.8 is the lowest
03:52So 1.8 is what we have
03:54Basically HAMZA SHAHZAD
03:56So he has taken the lowest number
03:58So he must be feeling insulted
04:00Now let's talk about
04:02Our SHORTCUT NUMBER 4
04:04Which is CONCATENATE
04:06CONCATENATE means to join
04:08It means to join this or this
04:10Or any two things
04:12We write the formula
04:14CON is equal to CON
04:16So basically double click on CONCATENATE
04:18Select VALUE 1
04:20So we have selected VALUE 1
04:22Basically HASAN KHAN
04:24After that COMMA
04:26VALUE 2
04:28We have basically selected the SCORE
04:30We want to join them
04:32So you can see HASAN KHAN 2.4
04:34HASAN KHAN and his SCORE
04:36He has added
04:38So we want that after HASAN KHAN
04:40After the POINT
04:42Is equal to
04:44The same formula CONCATENATE
04:46So after that we select HASAN KHAN
04:48COMMA
04:50And after that we will write DOUBLE QUOTES
04:52And in DOUBLE QUOTES
04:54We will enter SPACE
04:56After that we have to put COMMA
04:58Then we have to select the SECOND VALUE
05:00And simply we have to press ENTER
05:02So you can see that we have
05:04Basically SPACE
05:06Now let's talk about
05:085 SHORTCUT KEYS
05:10This is COUNTIF
05:12We want that
05:14In Saffron, White and Green
05:16We want that
05:18We want that
05:20We want that
05:22We want that
05:24We want that
05:26We want that
05:28We want that
05:30We want that
05:32We want that
05:34We want that
05:36We want that
05:38We want that
05:40We want that
05:42We want that
05:44We want that
05:46We want that
05:48We want that
05:50We want that
05:52We want that
05:54We want that
05:56We want that
05:58We want that
06:00We want that
06:02We want that
06:04We want that
06:06We want that
06:08We want that
06:10We want that
06:12We want that
06:14We want that
06:16We want that
06:18We want that
06:20We want that
06:22We want that
06:24We want that
06:26We want that
06:28We want that
06:30We want that
06:32We want that
06:34We want that
06:36We want that
06:38We want that
06:40We want that
06:42We want that
06:44We want that
06:46We want that
06:48We want that
06:50We want that
06:52We want that
06:54We want that
06:56We want that
06:58We want that
07:00We want that
07:03We want that
07:05We want that
07:07We want that
07:09We want that
07:11We want that
07:13We want that
07:15We want that
07:17We want that
07:19We want that
07:21We want that
07:23We want that
07:25We want that
07:27We want that
07:29We want that
07:31We want that
07:33We want that
07:35We want that
07:37We want that
07:39We want that
07:41We want that
07:43We want that
07:45We want that
07:47We want that
07:49We want that
07:51We want that
07:53We want that
07:55We want that
07:57We want that
07:59We want that
08:01We want that
08:03We want that
08:05We want that
08:07We want that
08:09We want that
08:11We want that
08:13We want that
08:15We want that
08:17We want that
08:19We want that
08:21We want that
08:23We want that
08:25We want that
08:27We want that
08:29We want that
08:31We want that
08:33We want that
08:35We want that
08:37We want that
08:39We want that
08:41We want that
08:43We want that
08:45We want that
08:47We want that
08:49We want that
08:51We want that
08:53We want that
08:55We want that
08:57We want that
08:59We want that
09:01We want that
09:03We want that
09:05We want that
09:07We want that
09:09We want that
09:11We want that
09:13We want that
09:15We want that
09:17We want that
09:19We want that
09:21We want that
09:23We want that
09:25We want that
09:27We want that
09:29We want that
09:31We want that
09:33We want that
09:35We want that
09:37We want that
09:39We want that
09:41We want that
09:43We want that
09:45We want that
09:47We want that
09:49We want that
09:51We want that
09:53We want that
09:55We want that
09:57We want that
09:59We want that
10:01We want that
10:03We want that
10:05We want that
10:07We want that
10:09We want that
10:11We want that
10:13We want that
10:15We want that
10:17We want that
10:19We want that
10:21We want that
10:23We want that
10:25We want that
10:27We want that
10:29We want that
10:31We want that
10:33We want that
10:35We want that
10:37We want that
10:39We want that
10:41We want that
10:43We want that
10:45We want that
10:48We want that
10:50We want that
10:52We want that
10:54We want that
10:56We want that
10:58We want that
11:00We want that
11:02We want that
11:04We want that
11:06We want that
11:08We want that
11:10We want that
11:12We want that
11:14We want that
11:16We want that
11:18We want that
11:20We want that
11:22We want that
11:24We want that
11:26We want that
11:28We want that
11:30We want that
11:32We want that
11:34We want that
11:36We want that
11:38We want that
11:40We want that
11:42We want that
11:44We want that
11:46We want that
11:48We want that
11:50We want that
11:52We want that
11:54We want that
11:56We want that
11:58We want that
12:00We want that
12:02We want that
12:04We want that
12:06We want that
12:08We want that
12:10We want that
12:12We want that
12:14We want that
12:16We want that
12:18We want that
12:20We want that
12:22We want that
12:24We want that
12:26We want that
12:28We want that
12:30We want that
12:32We want that
12:34We want that
12:36We want that
12:38We want that
12:40We want that
Comments