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
please continue with this course

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor