Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:00
So now this. Listen, I'm going to talk about important data from worksheets, and we're going to go straight to Excel, and it's a we're going to import from texts and we're going to import C S V files. So
00:16
sees REFILES, although it's considered to be text file is actually
00:21
away to import data from work sheets. So worksheets and some other, for example, financial programs or business management programs. They usually export data. Uh uh to cease refile if data heaven yells. So we're going to select this.
00:39
See every file and if you look at it has excelled Aiken. So it means
00:46
it's ah,
00:48
it's considered to be, ah, worksheet fall
00:54
and then we get the same
00:57
extinct put wizard.
00:59
So
01:00
it's the limited starting grow Mighty has Heather's. So we did the same thing
01:07
and it's a comma because it's
01:11
since me
01:12
and just go here
01:15
and say Finish.
01:19
And now it's asks you they wanted to put it in existing worksheet or new work. So remember when we opened these files before it opened? New Excel file here it will place it in our work ship, so it's a different story, and this is fundamentally different. So
01:38
it's placing it here because
01:40
my
01:42
ah
01:44
cell that I have selected was here.
01:47
So I want to work with it. I will just
01:52
put it here. And here it is. So here's the data
01:56
and, uh,
01:57
essential difference toe opening. This
02:01
is that
02:04
it's now subjected to query.
02:07
And when you delete this,
02:13
it's
02:15
just
02:15
you're not deleting that the file. You just delete the data. So you have important it in the wrong position. You can move it over here,
02:25
placed here
02:28
and again do the same thing,
02:46
and it places where have this in? This starts with the cell you have selected, so this is
02:55
fundamental difference.

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