Excel Statistics 03: Data Analysis Sorting & Pivot Tables

See two of Excel's great Data Analysis tools: Sorting and Pivot Tables (PivotTables).

This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel ExcelIsFun Girvin

Category:

Education

Tags:

• Excel
• 2007
• Statistics
• Data
• Analysis
• tools
• Sorting
• Pivot
• Tables
• (PivotTables)

[roses999us]

would you please tell me how to sort this data? Excel turns out: 832 Washington A 832 Washington 1 832 Washington 10 832 Washington 11 832 Washington 2 832 Washington 22 but I want: 832 Washington A 832 Washington 1 832 Washington 2 832 Washington 10 832 Washington 11 832 Washington 22 Thank you!

[ExcelIsFun]

Most programs use ASCII characters. There are 255 ASCII characters. Sort is based on these. I will send you an e-mail with more detail.

[BurnKilluminati]

Hey if the data in the column you have highlighted changes when you click sort, but the other columns do not change, does that mean that the data in other columns is incompatible with the original data selected, or does it only mean that sorting will only change data in the columns that are highlighted?

[ExcelIsFun]

I do not understand what you are asking.

But, if the data set has field names (column headers with different formatting) at the top, and records in rows and no fully blanks columns or rows, then click just one cell in the column that you want to sort and then click the sort button.

Did that help/

[veracabasal]

sir what is your website? i want to download your files too..

[ExcelIsFun]

search for:

excelisfun

Then go to the YouTube channel and watch the video that automatically plays - it shows it all.

[Jaderoccs]

Is there a way to sort pivot tables by date. For example I want the pivot table to automatically sort / display from July 2010 to June of 2011. I'd like to learn the trick to not manipulate the cells once the PT is complete, but for all pivot tables

[roses999us]

thank you so much! since I couldn't find a better way to do it, I just simply changed the single digit number to double digits such as 832 Washington 01, 10, 11, 02, 22, that way it turned out to be 832 Washington 01, 02, 10, 11, 22 instead of 1, 10, 11, 2, 22..