Intro to Excel

Course
Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:01
So we're close to the end of this module, and let's just do a short recap off what you have bean able to learn in this module. So at the beginning, you have seen how to sort data in excel using ah, either
00:21
pretty find fast sorting. We'd just one level
00:25
or two. You sort button and do the sorting with more than one level of sorting.
00:31
Um, then you have seen what the filters are and how are they used.
00:37
And after that, we had two lessons about grouping on grouping cells and creating sub totals,
00:44
which are similar in the in function. Although subtitles do more than just group, they also creates up totals off the certain dating in a certain calm.
00:58
Then you have bean able to see how to validate dating a cell and how to create drop down lists, which is very important if you're creating templates or files that somebody else should use toe, enter data in it.
01:15
This way, you can prevent them from entering wrong kind of data or data that is not in the range that is expecting these cells.
01:23
So if somebody's to enter the measure temperature
01:27
outside their house, you can limit that, for example, for anywhere in the world to be between minor, 60 and plus 60. Because
01:40
that's,
01:41
uh, that's the limit in which
01:45
the most extreme temperatures were ever measured.
01:48
Um, but you can also limited to some other limits, whichever you find useful. You can also prevent somebody from entering text data in a cell that should have, ah, just the numbers or entering negative numbers,
02:07
not in the cell that
02:07
the should have. Ah,
02:12
um should be used for Principal Square Road or entering zero in a cell which will be used in some other function to divide something because that will generator. Also, you have seen that you can create drop down lists in which
02:29
user just has to click on the the arrow
02:31
and choose one off the possible given answers or possible values to fill in the cell.
02:40
And finally, you have seen how to consolidate data from different sheets.
02:46
Now, before we end this lesson in next video, you will have the explanation on how to do
02:53
Ah, the labs for this module, you will also have ah, pdf file which explains you how to do the same labs manually, step by step.
03:08
So thank you for listening. And, uh,
03:13