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

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

Comments

Pour Bald says:

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

Adarsh Humne says:

Wonderful!!!
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:

Bloop!

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:

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

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

*

Human Verification: In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.


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

Please click below to support us on Facebook!

Send this to a friend

▷ Other ReviewsVehicles▷ Show Cars▷ Motorbikes▷ Scooters▷ Bicycles▷ Rims & Tires▷ Luxury BoatsFashion▷ Sunglasses▷ Luxury Watches▷ Luxury Purses▷ Jeans Wear▷ High Heels▷ Kinis Swimwear▷ Perfumes▷ Jewellery▷ Cosmetics▷ Shaving Helpers▷ Fashion HatsFooding▷ Chef Club▷ Fooding Helpers▷ Coktails & LiquorsSports▷ Sport Shoes▷ Fitness & Detox▷ Golf Gear▷ Racquets▷ Hiking & Trek Gear▷ Diving Equipment▷ Ski Gear▷ Snowboards▷ Surf Boards▷ Rollers & SkatesEntertainment▷ DIY Guides▷ Zik Instruments▷ Published Books▷ Music Albums▷ Cine Movies▷ Trading Helpers▷ Make Money▷ Fishing Equipment▷ Paintball Supplies▷ Trading Card Games▷ Telescopes▷ Knives▷ VapesHigh Tech▷ Flat Screens▷ Tech Devices▷ Camera Lenses▷ Audio HiFi▷ Printers▷ USB Devices▷ PC Hardware▷ Network Gear▷ Cloud Servers▷ Software Helpers▷ Programmer Helpers▷ Mobile Apps▷ Hearing AidsHome▷ Home Furniture▷ Home Appliances▷ Tools Workshop▷ Beddings▷ Floor Layings▷ Barbecues▷ Aquarium Gear▷ Safe Boxes▷ Office Supplies▷ Security Locks▷ Cleaning ProductsKids▷ Baby Strollers▷ Child Car Seats▷ Remote ControlledTravel▷ Luggages & Bags▷ Airlines Seats▷ Hotel Rooms▷ Fun Trips▷ Cruise Ships▷ Mexico Tours