❗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.
