Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Data Cleaning in Excel - Text Functions and Power Query

Simon Sez IT via YouTube

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
Learn how to clean data in Excel using text functions and Power Query. The course covers identifying and fixing errors, formatting issues, and data inconsistencies. You will master skills such as widening columns, deleting blank rows, filling empty cells, and removing duplicates. The teaching method includes practical demonstrations and step-by-step guidance. This course is designed for individuals who need to analyze data in Excel and want to ensure their data is error-free and well-organized.

Syllabus

- 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

Taught by

Simon Sez IT

Reviews

4.8 rating, based on 5 Class Central reviews

Start your review of Data Cleaning in Excel - Text Functions and Power Query

  • I learnt more about Excel and how to use it in its full form. Excel is such a complex tool in data analysis and by doing this course I learned how to do one of the most important steps of data analysis which is data cleaning.
  • This course was fantastic! The material was engaging, the instructor was knowledgeable, and I learned so much. Highly recommend!
  • Rodrigo Aislan Mathias
    I recently completed the Excel course on data cleaning, and it exceeded my expectations. The instructor provided clear explanations and practical examples that significantly improved my skills. The hands-on exercises were particularly helpful in reinforcing the concepts. I now feel confident in tackling messy datasets and efficiently cleaning them for analysis. This course is a must for anyone looking to enhance their data manipulation skills in Excel. Highly recommended!
  • Usman Ibrahim
    Wonderful class, am honoured to be part this class. I have learned and understand more about Excel, Data Cleaning, Removing duplicates
  • Profile image for Faisal Asad
    Faisal Asad
    Perfectly Briefed and very easy to understand for beginners and very detail described and with Good Example and with practical

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.