Sale Date Ended
Data Cleaning is the process of detecting and correcting (or removing) inaccurate and incomplete data.
There’s no point of generating reports from your data when it’s not clean and usable; all your reports will be faulty, and you can’t take any decisions based on them.
Excel’s Advanced Data Cleaning techniques help you become the Sherlock Holmes in detecting this inaccurate and incomplete data!
Why is Data Cleaning important? Why should I invest 3 hours in learning it?
Let’s say you want to carry out some marketing activity to your current 35000 customers. The customer database that you are currently maintaining maybe full of mix data like: -
What all will you learn (completely hands-on) in these 3 hours?!
What you need to know about Excel beforehand?
It’s an intermediate level course, not for absolute fresher in Excel.
This training is meant mainly for anyone who is comfortable with basics on Excel like formatting data & entering some formulas.
If you know basics of formulas like Sum, Sumif, Countif, $ sign in formulas, Vlookup, etc., it will be a great learning experience for you during the course.
Trainer @ Passion, Entrepreneur @ Work, Dancer @ Heart!
Rushabh Shah, certified Microsoft Office Specialist (MOS) in Excel, has trained 1500+ working professionals and MBA students in Excel & Data Analytics. After 8 years of job experience, he started www.DLTC.co, a corporate training company in 2014.
LinkedIn -> www.linkedin.com/in/rushabhjayeshshah/
Full Profile -> www.RushabhShah.net
Blog -> www.ExcelRush.com & www.YouTube.com/ExcelRush
What you need to get to the workshop
o Windows users - Excel 2010 or higher version (2016 or Office 365 version preferred)
o Mac users – Excel for Mac 2011 (2016 or Office 365 version preferred)
Mac users, must ensure you have Excel. Numbers (from Apple) won’t help for this workshop