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.
- 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