Sort - Sort Data Alphabetically and Numerically in Excel
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 |
Sign Up to View Tutorials
|
Downloadable Files: |
Yes |
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 |
This Excel tutorial shows you how to very quickly create a Chart or Graph using a keyboard shortcut in Excel. You will learn how to create a chart within the current worksheet or tab and also within a separate chart tab. These shortcuts will save you a lot of time and increase the speed with which you create spreadsheets in Excel.
Tutorial Length (mm:ss): |
3:32 |
Microsoft Office Program: |
Microsoft Office Excel |
|
|
Keywords: |
training keyboard shortcut graph chart create excel make quickly insert data |
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 date and time tutorial shows you how to add days, months, and years to a date in Excel. This tutorial covers this complicated subject in a step by step manner and thoroughly explains everything along the way. Adding days or months or years to a date is an often required task and, once you watch this tutorial, will be very easy for you to do. As well, this tutorial covers multiple different ways to add months to a date in Excel, which is annoyingly more complicated than adding days or years to a date in Excel.
Tutorial Length (mm:ss): |
17:48 |
Microsoft Office Program: |
Microsoft Office Excel |
|
|
Keywords: |
training date time excel dates month day year times calculate compute formula function add |