Data Cleaning in Excel - Text Functions and Power Query

Data Cleaning in Excel - Text Functions and Power Query

Simon Sez IT via YouTube Direct link

- Clear Formatting

6 of 17

6 of 17

- Clear Formatting

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Data Cleaning in Excel - Text Functions and Power Query

Automatically move to the next video in the Classroom when playback concludes

  1. 1 - Introduction
  2. 2 - Why Clean Data
  3. 3 - Widen Columns in Excel
  4. 4 - Delete Blank Rows in Excel
  5. 5 - Fill Empty Cells in Excel
  6. 6 - Clear Formatting
  7. 7 - Remove Duplicates
  8. 8 - Format Columns
  9. 9 - Numbers Stored as Text in Excel
  10. 10 - Changing Case Using the Text Functions
  11. 11 - Find and replace in Excel
  12. 12 - Importing Data into Excel from a Text File
  13. 13 - Using Text Functions to Extract Data
  14. 14 - Import Data into Excel from an Access File
  15. 15 - Combining Files in Power Query
  16. 16 - Basic Clearing in Power Query
  17. 17 - Updating Queries in Power Query

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.