Master Data Cleaning Essentials on Excel

Useful vocabulary

Pronunciation/dictation practice

These are the terms most relevant for an Excel class focused on cleaning and preparing data:

1. Cell – the basic unit in a spreadsheet where data is entered.

2. Column – vertical group of cells in a spreadsheet.

3. Row – horizontal group of cells in a spreadsheet.

4. Data set – a collection of data organized in rows and columns.

5. Autofit – a feature to automatically adjust row height or column width.

6. Replace – a tool to find specific text or values and replace them.

7. Formula – a calculation entered into a cell to process data.

8. Function – a predefined formula like LOWER, TRIM, or PROPER.

9. Lower – function to convert text to lowercase.

10. Trim – function to remove extra spaces from text.

11. Proper – function to capitalize the first letter of each word.

12. Paste as values – replacing formulas with their resulting values.

13. Text to columns – splitting a single column into multiple columns based on a delimiter.

14. Duplicate – repeated entries in a dataset that can be removed.

15. Blank cells – empty cells that can be filled with a placeholder like N/A.

16. IFERROR – function to handle errors in formulas.

17. Header row – the top row that contains column titles.

18. Formatting – changing appearance, such as bold, color, or gridlines.

19. Gridlines – the faint lines separating cells in a spreadsheet.

20. Visuals / Charts – graphical representation of data for analysis.

Speaking practice

1. What type of tasks do you usually use Excel for, and why do you find it helpful?

2. Can you share a time when Excel helped you solve a problem or organize information efficiently?

3. Which Excel feature or function do you use most often, and how has it made your work easier?

4. Have you ever faced a challenge in Excel that you couldn’t solve at first? How did you overcome it?

Excel Workshop

Link to the video

Link to download the Import file

Link to the result