Member-only story
Data cleaning in Excel often involves various tools and functions to manipulate, clean, and organize your data. Here’s a list of some commonly used data cleaning tools in Excel along with their shortcuts:
1. Data Form:
- Purpose: Converts a range of data into an Excel Table, providing additional filtering and sorting options.
- Shortcut:
Ctrl + T
2. Excel Tables:
- Purpose: Tables can be created using the “Insert Table” option in the “Insert” tab.
- Shortcut: No direct shortcut.
3. Transpose:
- Purpose: Transposes rows and columns, switching the orientation of your data.
- Shortcut:
Alt + E, S, E
4. Remove Duplicates:
- Purpose: Removes duplicate values from a range of cells.
- Shortcut:
Alt + A, M
5. Sort:
- Purpose: Sorts data in ascending or descending order.
- Shortcut:
Alt + D, S
6. Filter / AutoFilter:
- Purpose: Filters data based on specified criteria.
