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

Download files:

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

Buy excelisfun products:

[TheXenoEnder]

As a Software Engineer who has used Excel for many years both to break down data for debugging and to build ad-hoc reports, this video contains almost every feature you'll ever need in Excel. I found this while trying to point a friend to some educational material and this video is above and beyond my expectations.

[elobous]

You're awesome. Tutorials in my country are weak but I didn't want to spend fortune for "professional" courses, I passed the test at interview and got a job after watching your tutorials. THANKS

[keikorono]

3:00 Proper data setup
4:45  Sort w/ 1 criteria
6:48  Sort w/ 2 criteria or more
10:05 Sort by color
11:33 Filter w/ 1 criteria
15:20 Filter w/ 2 criteria or more
16:30 Filter by color
16:55 Filter by numbers 
19:31 Filter by dates
20:27 Filter by partial text
21:10 What are Pivot Tables
28:50 PivotTables w/ 2 calculations or more
33:28 Grouping numbers
35:53 Filter in a Pivot Table
38:47 Column Charts from Pivot Table
42:30 SUMIF
46:16 COUNTIF                 

Formulas for comparing two lists:
47:39 MATCH function
49:17 ISNUMBER
49:50 ISNA  

52:16 Import from CSV file *
54:01 Import from MS Access

[dexterloki]

Never heard someone more excited about Excel than this dude

[mella_butter]

You must press End to get to the bottom.  Then slowly scroll up until you see "Highline Community College Professional Development Day 2012 (Data Analysis in Excel):
            Download: START Excel Workbook.xlsm"

It took me way too much time to find and these lessons are so helpful.  Just a heads up for fellow Excellers!  

[livejesuschrist]

I was finding it hard to understand pivot tables but you made pivot tables easy for
are you in the Guinness book of world records for explaining excel piece by
you are a

[TheDanny]

Thank you for a great tutorial, very helpful. Your enthusiasm is infectious as well as inspiring. Wish more teachers were like you.

[mahmoedghazy]

9 years later, i'm learning from you . thanks <3

[ashahassan]

Simple. Clear. Great teacher. Thanks so much. I'm glad i found your tutorial.

[zubairHP]

I wish you were my teacher, you taught me more in an hour than most people!

[excelisfun]

I am glad that the video and time linked table of contents helps!

[musaisha]

I have to be honest, this is the best online class that i have been to. Thanks a lot.

[excelisfun]

I am glad that you liked the videos and that they helped! (Actually, if you find an old Guinness book of world records from the 90s, you will find that I was in it for most boomerangs consecutively caught without a drop and for juggling two boomerangs most times ) lol

[luuuluuu]

I took this tutorial. I've completed it. I like it very much. I'll give you 5 Stars if users are allowed to rate. I've subscribed to your YouTube Channel and I'm currently learning the "Excel Statistical Analysis" for Excel 2013! All in all, very good tutorial!

[ceelcade]

I love this teacher, he is the only one has excel for free youtube online that is helpful. the rest garbage.  keep up the good work.

[Pappiah]

This is by far the best tutorial I have ever watched and FREE.

I'm a Entry Level Merchandiser and I am trying to upskill myself. This has helped tremendously

[shoaib]

thanks alot ! i start my new job next week and you've helped me brush up on my Excel.

[Tisbebe]

I've worked with excel fit many years (self taught) and tutorials like this help do much for me to refresh and learn new ways to work with excel!

Thank you so very much for so elegantly explaining step by step your video!

[excelisfun]

You can buy the "Slaying Excel Dragons" DVD from amazon. It has 53 videos that teach Excel from beginning to end.

[swtprsn]

Am a big fan of you... Always use to come here to brush up my knowledge every now and then... Every time I watch your videos, I learn something new... You are doing a great job... God Bless You with all Goodness in life... :)