Download workbook:

http://people.highline.edu/mgirvin/ExcelIsFun.htm

Learn the basics of Data Analysis at Highline Community College Professional Development Day 2012:

Topics in Video:

1. What is Data Analysis? ( 00:53 min mark)

2. How Data Must Be Setup ( 02:53 min mark)

Sort:

3. Sort with 1 criteria ( 04:35 min mark)

4. Sort with 2 criteria or more ( 06:27 min mark)

5. Sort by color ( 10:01 min mark)

Filter:

6. Filter with 1 criteria ( 11:26 min mark)

7. Filter with 2 criteria or more ( 15:14 min mark)

8. Filter by color ( 16:28 min mark)

9. Filter Text, Numbers, Dates ( 16:50 min mark)

10. Filter by Partial Text ( 20:16 min mark)

Pivot Tables:

11. What is a PivotTable? ( 21:05 min mark)

12. Easy 3 step method, Cross Tabulation ( 23:07 min mark)

13. Change the calculation ( 26:52 min mark)

14. More than one calculation ( 28:45 min mark)

15. Value Field Settings (32:36 min mark)

16. Grouping Numbers ( 33:24 min mark)

17. Filter in a Pivot Table ( 35:45 min mark)

18. Slicers ( 37:09 min mark)

Charts:

19. Column Charts from Pivot Tables ( 38:37 min mark)

Formulas:

20. SUMIFS ( 42:17 min mark)

21. Data Analysis Formula or PivotTables? ( 45:11 min mark)

22. COUNTIF ( 46:12 min mark)

23. Formula to Compare Two Lists: ISNA and MATCH functions ( 47:00 min mark)

Getting Data Into Excel

24. Import from CSV file ( 51:21 min mark)

25. Import from Access ( 54:00 min mark)

Highline Community College Professional Development Day 2012

RequestThrottled: AWS Access Key ID: AKIAIJ3LCSVBRWZPCMOA. You are submitting requests too quickly. Please retry your requests at a slower rate.

Its is a great video. Good work and I am thankful to you as you are teaching us 🙂

Wonderful!!!

That helped a lot.

i am trying to get a job in data analysis but with no luck.

your video is so helpful and really easy to digest. thanks so much!!!

Thanks for uploading a very useful excel video

Awesome video! You’re the best! Thanks so very much!!!!! 🙂

thank you very much!

Best guide

Super bro you are the one…..

I Love you man. You are really good at explaining

You are an awesome teacher. Do you have other videos covering Excel Advanced topics.

Thank you..You are a great teacher

what a great freaking video. thank you!!

Thoroughly enjoyed! Thank you for taking the time to teach us! All the best!

You sound like Ross from friends! Great content!

It is a good video and very useful!

May i have the same excel file download on the video. The download link provided is lapsed. Tks!

You are a BLESSING!!!! You help me in my OFFICE PRODUCTIVITY

Can anyone help me? I am trying to make an excel sheet that will generate a number when data is entered. Example, column headings will be , number of total surveys, number of total bad surveys, % of total good surveys, *how many surveys needed to get to 90%.

I can’t figure out how to create the formula that will give me the last heading *

4,303,782,908 turn this into millions form

Thank you so much for making this video tutorial! Even though there are many online resources for Data Analysis in Excel, I really like this video because it has many examples in one video. Instead of having to find multiple videos for each type of example, I can just watch one video and saves me a lot of convenience. The explanations are also done very well!

When you realize Ross Geller is teaching you Excel

Thank you so much !!! Your work is unbelievable. Thank you!!

can you please add the link to this excel dataset below? I am not able to find it

i wish more people would get as involved with MS access as they do with Excel. have learned many new tricks with your videos. well done

I did not expect import data wizard exist. Thank youuuuuuuuuuuuuuuuu

thanks dude

Now this is a channel worth subscribing to. Thank you so much. You have no idea how much you’ve helped.

Bloop!

How do you create the pictures that you already have set up when starting out the pivot table sections? How do you make the pivot table data into a picture format for us to see? thank you

Mate, you are awesome! Thanks

SWAP “1-PSD/AFX-12” TO 12-AFX/PSD-1 IN EXCEL

CAN YOU HELP

Wow, Thank you so much for posting this tutorial! This is very helpful!!! You explain Excel data analysis in a way easy to understand.

Thank you so much for this video. This really helped me learn a lot.

Another excellent tutorial! Thanks again.

That WAS an epic video! Thanks!

What a great teacher he his! Simply wonderful & clear!

Thanks for creating such videos.

Hyperlink how to link in DA Sheet & D, S(3). Please help us.

I can’t find where this excel is to download it. Can someone help me out?

Thank you, awesome tutorial!

Thanks a lot for putting it in a simple and understandable manner.

One great question for you? When you are doing “filer” for just top ten, it does work but I was trying to do top ten once I have did that filer with other criteria and it does not work. So, I wonder, we can only do top ten before doing any kind of filer with criteria ..right?

Could not find the Workbook. Would you mind pointing me to it through your web page? Thanks in advance.

awesome thanks so much

Thank you, that was an excellent tutorial.