Data for Excels
Working with data in Excel means keeping information in a clean tabular layout, with one header row, one record per row and one field per column. Excel Tables add filtering, sorting and structured references, and cleaning tools such as Remove Duplicates, Text to Columns and TRIM fix messy imports.
Stage: Data Skills · Part of the Excel roadmap · Last reviewed 19 November 2026
What to learn in Data
- Convert a range to an Excel Table and use its structured references in formulas
- Sort and filter data on several columns, including custom orders
- Remove duplicates and split text into columns with Text to Columns
- Clean text with TRIM, CLEAN, UPPER, PROPER and the TEXT function
- Apply data validation and drop-down lists to keep entries consistent
Data interview questions
Why convert a range to an Excel Table?
A Table grows automatically when you add rows, keeps formulas consistent down a column, supports filtering and styling, and allows structured references such as Sales[Amount]. Charts and PivotTables based on it update as the table expands.
How do you remove extra spaces from imported text?
Use the TRIM function, which removes leading and trailing spaces and reduces repeated spaces inside text to one. Imported web data may also contain non-breaking spaces, which TRIM does not remove, so SUBSTITUTE with CHAR(160) may be needed.
Where Data fits in the Excel roadmap
Data belongs to the Data Skills stage (beginner level). Organise and analyse.
Other units in this stage
Back to the full Excel roadmap