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.
Overview
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
Related Courses
Related articles
Reviews
4.8 rating, based on 8 Class Central reviews
-
I personally find the course very insightful and easy to learn especially for that fact that I had no Tech background at all and it was thought from the basis which made it very easy to understand.
I want special thank the school for putting up such a beautiful program online and also finding it wise to make it free and easily accessible, especially for people like who might not have the resources to pay for the program and still want to develop and improve ourselves especially in transition into tech, am most grateful for this great opportunity and do my best to represent the school well in the global world. Thank you and God bless. -
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!
-
I really enjoyed this course a lot. I especially loved how it was fast paced yet easy to keep up with and understand how to clean your data in Microsoft Excel.
-
Izaque Francisco NatalÓptimo curso, mais deveria disponÃbilizar legadas em português,pois facilitar muito para as pessoas que não possuem domÃnios na lÃngua inglesa. -
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!
-
Wonderful class, am honoured to be part this class. I have learned and understand more about Excel, Data Cleaning, Removing duplicates
-
Faisal AsadPerfectly Briefed and very easy to understand for beginners and very detail described and with Good Example and with practical
