Analyzing Your Excel 2013 Data
- 2/15/2013
- Using conditional formatting to showcase data trends
- Adding sparklines
- Understanding Excel formulas and functions
- Performing common calculations
- Subtotaling data values
- Entering formulas
- Troubleshooting formulas
- Working with functions
- Creating and modifying data tables
- Sorting data
- Filtering worksheet data
- Creating PivotTables
- Viewing data instantly with Quick Analysis
Sorting data
Because you can use Excel 2013 for more than just numbers, you might want to take advantage of it to store all kinds of information such as customer lists or inventory databases. You can use Excel’s Sort tool to organize the information in your worksheet and sort it in a way that’s meaningful for you.
Sorting is easy in Excel. You can choose an Ascending or Descending sort, or you can customize the process by sorting your information on the elements and in the order you specify.
Do a simple sort
Click any cell in the column of data that you want to sort.
Click the Data tab.
Follow either of these steps:
In the Sort & Filter group, click the Sort Ascending button.
In the Sort & Filter group, click the Sort Descending button.
Create a custom sort
Select a cell in the data range or Excel table that you want to sort.
Click the Data tab.
Click Sort.
The Sort dialog box opens.
Click the Sort By arrow and select the criterion by which you want to sort.
Click the Sort On arrow and select the criterion by which you want to sort.
Click the Order arrow and then select the order in which the column’s values should be sorted.
Click Add Level.
If necessary, repeat steps 4–7 to set the columns and order for additional sorting rules.
Click OK.
)