8 hours 33 minutes
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
sees REFILES, although it's considered to be text file is actually
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.
See every file and if you look at it has excelled Aiken. So it means
it's considered to be, ah, worksheet fall
and then we get the same
extinct put wizard.
it's the limited starting grow Mighty has Heather's. So we did the same thing
and it's a comma because it's
and just go here
and say Finish.
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
it's placing it here because
cell that I have selected was here.
So I want to work with it. I will just
put it here. And here it is. So here's the data
essential difference toe opening. This
it's now subjected to query.
And when you delete this,
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,
and again do the same thing,
and it places where have this in? This starts with the cell you have selected, so this is
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand