Preview lessons, content and tests

Computer Science & Programming solved. All in one platform.

1. To trial the platform and take tests, please take a few seconds to SIGN UP and SET UP FREE.
2. Searching for something specific? See our text overview of all tests. Includes 'real teacher' use videos.

Sorting and Filtering in Excel

When you have a list of numbers or data in a spreadsheet, the need to sort them (alphabetically, or perhaps in ascending or descending order) becomes obvious In addition to sorting, you may find that adding a filter allows you to better analyze your data. When data is filtered, only rows that meet the filter criteria will display and other rows will be hidden. With filtered data, you can then copy, format, print, etc., your data, without having to sort or move it first. 

Video (Sorting Data)

Video (Filtering)

www.teachyourselfpython.com