Data Cleaning in Excel - Text Functions and Power Query

Learn essential data cleaning techniques in Excel using text functions and Power Query in this comprehensive one-hour tutorial. Discover how to prepare data for analysis by addressing common issues like formatting errors, text-stored numbers, and data gaps. Master skills such as widening columns, deleting blank rows, filling empty cells, clearing formatting, removing duplicates, and formatting columns. Explore advanced techniques like changing case with text functions, using find and replace, and importing data from various sources. Dive into Power Query to combine files, perform basic data cleaning, and update queries. Follow along with downloadable resources to enhance your Excel data cleaning proficiency and improve your data analysis capabilities.

- Introduction
- Why Clean Data
- Widen Columns in Excel
- Delete Blank Rows in Excel
- Fill Empty Cells in Excel
- Clear Formatting
- Remove Duplicates
- Format Columns
- Numbers Stored as Text in Excel
- Changing Case Using the Text Functions
- Find and replace in Excel
- Importing Data into Excel from a Text File
- Using Text Functions to Extract Data
- Import Data into Excel from an Access File
- Combining Files in Power Query
- Basic Clearing in Power Query
- Updating Queries in Power Query