Sort - Perform Multiple Column or Level Sorts on Data
This Excel sort tutorial will show you how to perform a sort on multiple columns of data at the same time in Excel. This means that you can refine sorting to include multiple different criteria and multiple levels at the same time. This will allow you to create more sophisticated and useful sorts in Excel.
Tutorial Length (mm:ss): |
6:16 |
Sign Up to View Tutorials
|
Downloadable Files: |
Yes |
Microsoft Office Program: |
Microsoft Office Excel |
|
|
Keywords: |
training sort sorting excel multiple levels columns data advanced refine criteria |
This Excel sorting tutorial will show you how to quickly and easily sort data in Excel using the mouse. This method allows you to forgo using the Ribbon menu to sort data and will increase the speed and efficiency with which you sort data in Excel.
Tutorial Length (mm:ss): |
3:03 |
Microsoft Office Program: |
Microsoft Office Excel |
|
|
Keywords: |
training sort data excel quickly fast easy easily mouse spreadsheet efficiency efficient |
This Excel sorting tutorial provides an overview of how to sort your data in Excel. This tutorial includes an example of sorting numbers and text. As such, you will learn how to sort numbers from lowest to highest and highest to lowest (ascending and descending order) and how to sort text in alphabetical order and reverse alphabetical order (A to Z and Z to A). Also, this tutorial covers some other things to watch out for when you sort data within your spreadsheets in Excel.
Tutorial Length (mm:ss): |
4:42 |
Microsoft Office Program: |
Microsoft Office Excel |
|
|
Keywords: |
training sort excel sorting data spreadsheet alphabetical numerical alphabetically atoz order reverse text numbers |
This Excel sorting tutorial shows you how to sort data from left to right, also referred to as sorting rows. This is a skill that will help you to organize data that is presented left to right in Excel. This works especially well with things such as sales data that is listed by day, week, month etc. across a spreadsheet. This is a more advanced method used to sort data and will help you to better organize your data in Excel.
Tutorial Length (mm:ss): |
5:26 |
Microsoft Office Program: |
Microsoft Office Excel |
|
|
Keywords: |
training sort excel data sorting left to right rows row numbers text analysis |
This Excel sorting tutorial will show you how to sort text in Excel from A to Z and Z to A (alphabetical and reverse alphabetical order). This is a seemingly basic sort but does require that you format your data in a certain way. This is a great tutorial for those just starting out sorting in Excel.
Tutorial Length (mm:ss): |
2:29 |
Microsoft Office Program: |
Microsoft Office Excel |
|
|
Keywords: |
training sort data excel sorting text alphabetical order lowest highest |
This Excel sorting tutorial will show you how to sort numbers in Excel from lowest to highest and highest to lowest. This is a seemingly basic sort but does require that you format your data in a certain way. This is a great tutorial for those just starting out sorting in Excel.
Tutorial Length (mm:ss): |
2:45 |
Microsoft Office Program: |
Microsoft Office Excel |
|
|
Keywords: |
training sort data excel sorting numbers numerical lowest highest |
This Excel sorting tutorial will show you how to sort dates and time in Excel. This tutorial covers some of the things to watch out for when you need to sort this type of data and how to ensure that the sort is performed correctly. This is an important type of sort to use in Excel when you need to view your data across a timeline.
Tutorial Length (mm:ss): |
5:13 |
Microsoft Office Program: |
Microsoft Office Excel |
|
|
Keywords: |
training sort data sorting excel date dates time times numbers earliest latest |
This Excel sorting tutorial will show you how to sort data based on cell color, font color, and icon set. This will allow you to refine your data by color and increase the ability to analyze the data. This sorting tutorial also briefly covers conditional formatting in Excel, which is tied together with sorting based on font color, cell color, and icon set. This is an advanced sorting technique in Excel and is thoroughly covered in this tutorial.
Tutorial Length (mm:ss): |
11:06 |
Microsoft Office Program: |
Microsoft Office Excel |
|
|
Keywords: |
training sort data sorting excel cell font color icon set sets conditional formatting format advanced |
This Excel sorting tutorial will show you how to sort one column or a small group of columns in Excel without sorting or rearranging the adjacent columns. This means that you can sort subsets of your data and not affect or change the order of the rest of the data in the spreadsheet. This is a very important feature of sorting in Excel and will help you to better organize and refine your data. This technique allows for a kind of mini-sort to be made within your data in Excel.
Tutorial Length (mm:ss): |
3:55 |
Microsoft Office Program: |
Microsoft Office Excel |
|
|
Keywords: |
training sort data sorting excel one column next subset adjacent data set table advanced |