Data Sorting and Filtering

DESCRIPTION: Tables in Excel can become quite large over time. Eventually, manual searching and reorganisation is inefficient. Luckily Excel has built-in sorting and filtering functions that allow you to reorganise based off certain parameters such as date or letter and even filter if a particular field matches a criteria you set. In order to elevate yourself to the next level of Microsoft Excel, sorting functions are a must as they will open the door to more advanced filtering functions and possibly if you’re so inclined, database development.

TARGET AUDIENCE: This is for beginners approaching intermediate levels.

DOWNLOADABLE FILES: 

DIFFICULTY: Beginner

COURSE OUTCOMES:

  • Basic sorting by letter and number
  • Primary Key theory to maintain original data structure
  • Custom sorting based on different columns
  • Sorting by colour
  • Sorting using multiple columns at once

MORE SHORT COURSES