Microsoft Excel #07: Importing Data & Working with Graphs

I walk you through important a large amount of data (i.e. from the Internet) and converting it to columns. I then go over multiple graph styles and techniques.

Category:

Howto & Style

Tags:

• Microsoft
• Excel
• tutor
• tutorial
• learn
• cell
• row
• column
• formula
• formulae
• formulas
• average
• sum
• tips
• beginning
• intro
• using

[CoolPapa83]

You an excellent tutor & I really enjoy watching your videos. But do you think that you could maybe elaborate on making a chart with data that has more than 1 column?

[freetutorials]

I have it on my list. Sorry it took so long!

[maxwoob]

how do i transfer this to a normal paper size?

[freetutorials]

Do you mean "full screen" or do you mean when you print it?

[Fawcks]

Thank you very much! This helped me write my report a ton. I feel so silly for being my age and not knowing how Microsoft Excel works. Thanks again, you're a life-saver.

[freetutorials]

You are VERY welcome. Let me know if I can help with anything else!

[ochysam75]

I am working with a large set of data at the moment , I sincerely dont know what to do with it. I need to create graphs from it. Can you help me?

[gcflearnfree]

We get asked this question a lot-we'll definitely point people to this video

[aden512]

i wana prepare monthly report from one data source in excel. i want a template whichb should retrieve all data if change the month. can some one help me please

[sista1stlady]

You're a Great instructor. I love your voice. It's very easy to follow what you are saying.

Is it possible that you could do a tutorial video on surface and contour charts? And how about for a law enforcment setting, for example a contour chart that would show a hot spot, or a large number of crimes during a certain time of day and day of the week.

Thank you for your talent and expertise. Your public is certainly benefiting from you.

[401dashan]

thnk u very much

[MissConceptions1]

Oooh this is sooo excellent... you are such a GREAT teacher thank you sooo sooo much!!

[dimasfirmanda]

can I plot data with different time step in one graphic? for example, I have 2 kind of temperature data, 1st is hourly temperature data in one day and 2nd is 10 minutes temperature data in one day

[carolin999]

Thanks from slovakia....

[animalfarm1988]

Thanks a lot. I am also the one that don't know much about excel. I was nervous because I will start internship soon and my work will involve excel...

But, Your tutorial videos has been helpful. you helped me. Thanks a lot. I know better than before.

[upinflamezzz]

I am very good with excel, but last week everytime I open excell now my spreadsheet pops up as a small closed box in the upper left hand corner. I can't fix it. What gives?