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
Reviews
4.8 rating, based on 5 Class Central reviews
-
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 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
-
Perfectly Briefed and very easy to understand for beginners and very detail described and with Good Example and with practical