Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:00
Okay, let's do the short recap about this module turn. Miss Module, You have
00:06
being able to see how
00:09
date a CIB orchid in excel
00:12
what kind of performance you can important Excel.
00:16
And most importantly, what is the difference between opening a file in different format than Standard Excel file and importing it? So the difference is that when you open a file, the Oper Open
00:29
brand you worksheet with this file in it, and when you import it, you can place it wherever you want inside your vile or on the worksheet, or you can put it in the new worksheet, but it stays in the file. So if you want to aggregate a lot of data from different files in one
00:48
Excel file, you do that by
00:52
importing it off course. You can do that by opening all these files and then copy pasting. But it's a little bit more work, especially if they contain lot of data. And if you have to import it from,
01:08
do them to put it on the honor on a single worksheet, it can be a problem can be a tedious work. So,
01:19
uh, this is why you do the importing Also, you have seen how to clean this data. How tow Remove some unwanted rose. How to feel missing things. Or if you import by mistake, uh,
01:37
all they think one column than how to separate it and so on and so on. So these things are important when working with the data from different files.
01:49
And in the end, you have also seen how to export data meaning how to save it as,
01:57
uh, other former rather than Saturday Excel file format.
02:04
So this is all about this special and the thank you so far for
02:10
progressing with this course.

Up Next

Intermediate Excel

Being an intermediate level user of Excel can help save a user hours of work time and take full advantage of the Excel application. Taking an intermediate Excel training will help students advance their skills and pass an intermediate Excel exam.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor