Office 2013 Class #41: Excel Basics 23: Sort and Filter, Basic Data Analysis (24 Examples)

This video teaches:
1. Data Analysis: Sort, Filter, PivotTable (00:21 min)
2. Proper Data Set required for Data Analysis features (01:20 min)
3. Single Cell selected BEFORE clicking Sort, or Filter, or PivotTable (01:37 min)
4. Sort A to Z for single column with button (02:20 min)
5. Sort Z to A for single column with button (03:11 min)
6. Sort Z to A on single column and have whole data set sort (03:31 min)
7. Sort data with NO FIELD NAME (04:56 min)
8. Sort by Color (05:47 min)
9. Add a second level of sorting in Dialog Box (07:22 min)
10. Reorder Sort in Sort dialog box (07:50 min)
11. Sort based on Multiple Columns. Sort whole data set based on ONE column (08:10 min)
12. Sort upon two columns with buttons (Major Sort Last) (08:41 min)
13. Sort upon two columns with Sort dialog box (Major Sort on Top) (10:44 min)
14. Sort data set based on three columns (12:44 min)
15. Filter (14:02 min)
16. Filter with Filter check box to Extract Records to a new location (14:48 min)
17. Date Filter to Extract Records to a new location (16:10 min)
18. Top 10 Number Filter to Extract Records to a new location (16:49 min)
19. Filter with three AND criteria to extract records to a new location (17:32 min)
20. Filter with two OR Criteria to extract records to a new location (19:23 min)
21. Filter and get zero records in your data set: 1) Incorrect Q or 2) There are no records that match (20:13 min)
22. Search Filter (21:31 min)
23. Excel Table feature: Totals row to make calculations based on a Filter or Criteria (22:07 min)
24. Add new record when you have a Total Row in your Excel Table (24:57 min)
Excel Table Total Row to make calculations with Criteria or Conditions
Highline Community College Busn 216 Computer Applications Class Office 2013 (Fun With Computers) taught by Michael Girvin. Excel Basics. Learn Excel, How To Excel.

[excelisfun]

Office 2013 Class #41: Excel Basics 23: Sort and Filter, Basic Data Analysis (24 Examples) 

[Fimled-by-Anya]

The tutor for Excel in the whole world. I am just amazed by your appetite in sharing knowledge. Simply great and you should be really really proud!

[vinapatel]

You are an awesome at teaching excel. Step by step very easy to follow you are simply great. Love it.

[karidupree]

I am in an online class to learn excel. Your tutorial videos are fantastic! They help reiterate what I am learning. Thank you so much!!! :)

[unicornsarereal]

Brilliant explanation. How many times have I wrecked my data by highlighting the columns instead of clicking on a single cell... Now I know... Friday is my final day of Excel training, and final assignment... I am confident I'll do well, thanks to you and your tutorials.!

[fabycroft]

I have been trying to learn excel for years...finally. thank you!

[tabhuchandrika]

Simple, Understandable & Helpful
Thanks For It :)

[CramRS]

I'm actually interested in how you make the events/timeline markers.  Was it using video manager/editor or loaded from an existing program?

[napoleansilveira]

its really great....Keep it up.
Can I get data of office 2013 #41 & Office 2010 # 35 for practice.. thank in advance

[gautamkhanna]

Awesome video. Just close to 500k subs. 😍

[codyt.]

Can you do a video about Sorting a list of Addresses? If someone trys using Sort on the full address, Excel will sort the address by the 1st character. We need to sort by the Street name, then by the house number. =Left(A1, Search(" ", A1)-1) for the house #...

Then, I need to organize the Addresses by even numbers and odd numbers. A to Z on the even numbers, Z to A on odd numbers.

I found out how to reorganize the addresses by watching your videos. I want to see if you have a better way..

[dineshguptha]

What is the shortcut for this Sort function?