Microsoft Excel Tutorial Sorting Data

In this video youll learn the basics of sorting in excel 2019 excel 2016 and office 365.

Microsoft excel tutorial sorting data. For example you can sort employees first by department and then by last name. How to sort in excel. Set multiple cascading sorting rules such as sorting alphabetically by state and then by county. You can arrange a list of names in alphabetical order compile a list of sales figures from highest to lowest or order rows by colors or icons.

It explains how to sort numbers in increasing order as well as sort. This excel video tutorial provides a basic introduction into sorting and filtering data. Sorting is one of the most common tools for data management. You can sort a range or table of data on one or more columns of data.

Sorting data is an integral part of data analysis. Create totally custom sorts to order your data by any rule you set. You need tools that allow you to organize your data according to specific criteria for example alphabetically sort surnames or apply specific filters to a worksheet to only display data that meets specific filter criteria. Here are three excel data sorting techniques youll learn in this tutorial.

In excel you can sort your table by one or more columns by ascending or descending order or do a custom sort.