Excel Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012

Download workbook:
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)
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)
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)
19. Column Charts from Pivot Tables ( 38:37 min mark)
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


Pour Bald says:

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

Adarsh Humne says:

That helped a lot.

Mauricio says:

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

Crusty Butter says:

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

Zakir Ahmed says:

Thanks for uploading a very useful excel video

Denise P says:

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

Angelique Gabrillo says:

thank you very much!

Masumbuko Mwakalasya says:

Best guide

Practice Makes Perfect Deepak Gauniyal says:

Super bro you are the one…..

Moshtaq Jalaly says:

I Love you man. You are really good at explaining

Maria Pond says:

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

Abilash Aravind says:

Thank you..You are a great teacher

Slava Litvin says:

what a great freaking video. thank you!!

Kojo Asare Encore Rehearsal says:

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

Zelle Boutique says:

You sound like Ross from friends! Great content!

Shane Lean says:

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!

Sheila Marie Grijaldo says:

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

Jose Morales says:

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 *

aasu grg says:

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

Alicia Rasmey says:

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!

Kamal Hijazi says:

When you realize Ross Geller is teaching you Excel

panmexili says:

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

Super Woman says:

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

Caroline Jc says:

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

Abdo Mansoor says:

I did not expect import data wizard exist. Thank youuuuuuuuuuuuuuuuu

niyasthampi says:

thanks dude

Kenneth Thomas says:

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

Andrea Porras says:


Daniel L says:

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

Eug Zvering says:

Mate, you are awesome! Thanks

Vishal Panchal says:


kryssy2490 says:

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

shreya majumdar says:

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

Michael Rozenveld says:

Another excellent tutorial! Thanks again.

Patricia Lee says:

That WAS an epic video! Thanks!

Borgaonkar - ACTSol and Associates says:

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

Thanks for creating such videos.

Ansul Singh says:

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

Ani glop says:

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

Angel Gruev says:

Thank you, awesome tutorial!

Shyam kumar says:

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

Super Woman says:

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?

Chuck Hamdan says:

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

lolane kevira says:

awesome thanks so much

Olwen Anderson says:

Thank you, that was an excellent tutorial.

 Write a comment


Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!