Top 30 Data Cleaning Tricks in Excel Excel Data Cleaning Course
Learn the top 30 data cleaning tricks in Excel with this comprehensive course. Get the most out of your data with these simple and effective tricks. Get the full advanced Excel course library and keep yourself updated with Yoda Learning. ▼
ADVERTISEMENT
Course Feature
Cost:
Free
Provider:
Youtube
Certificate:
No Information
Language:
English
Course Overview
❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [July 20th, 2023]
This Excel Data Cleaning Course provides an overview of the top 30 data cleaning tricks in Excel. It covers topics such as how to change the case of text, remove extra spaces, find the length of text, convert numbers stored as text back to a number, add a chart inside a cell, add missing zeroes in cheque numbers, join text from different cells, use wildcard characters with Find and Replace, delete wildcard characters with Find and Replace, use MS Word's Find and Replace over MS Excel's, replace one cell color format with another in the entire worksheet, apply basic Text to Columns to split the text, keep zeroes when applying Text to Columns, clean numbers, convert numbers with Dr. and Cr. to positive and negative numbers, rectify incorrectly formatted dates using Text to Columns, use LEFT and RIGHT functions, increase the power of LEFT and RIGHT formulas using the SEARCH function, and use the MID function.
Pros & Cons
Practical and useful tricks: Users appreciate the practicality and usefulness of the tricks taught in the course. They mention specific tricks like tilting to replace certain characters, converting text to column dates, and inserting "Zero" before numbers. These tricks are seen as valuable and effective in data cleaning tasks.
Clear explanations and demonstrations: Users find the tutorials in the course to be well-explained and easy to follow. They mention that the instructor provides clear explanations and demonstrates the tricks effectively.
Lack of practice materials: Some users express a desire for practice materials, such as a downloadable practice file or the dataset used in the videos. They mention that having access to these materials would allow them to practice along with the instructor and reinforce their learning. The absence of practice materials is seen as a drawback by these users.
Limited new information for advanced users: A few users mention that they already knew most of the tricks taught in the course. While they acknowledge that certain tricks still work like magic, they feel that the course may not offer much new information for advanced Excel users. This limitation may make the course less appealing to users who are already proficient in Excel and data cleaning techniques.
Course Provider
Provider Youtube's Stats at AZClass
Discussion and Reviews
0.0 (Based on 0 reviews)
Start your review of Top 30 Data Cleaning Tricks in Excel Excel Data Cleaning Course