Advanced Data Cleaning Techniques in Excel,Advanced Data Cleaning Techniques in Excel Workshop,Advanced Data Cleaning Techniques in Excel events,Data Cleaning Techniques in Excel Workshop

Advanced Data Cleaning Techniques in Excel - Workshop in Mumbai, Maharashtra, India on December 2017 by DLTC.co

Workshop Information


Advanced Data Cleaning Techniques in Excel


Workshop Title
Advanced Data Cleaning Techniques in Excel
Event Type
Workshop
Workshop Date
14-12-2017
Last Date for Applying
13-12-2017
Location
Mumbai, Maharashtra, India

Publish / Maintain / Marketing / Hosted By
Organization Name / Organize By
DLTC.co
Organizing/Related Departments
Training
Organization Type
Engineering and Technology
Workshop Category
Technical
Workshop Level
State/Province/Region
Related Industries

Education/Teaching/Training/Development

Computer/Technology

Location
Mumbai, Maharashtra, India
Get In Touch

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 theSherlock 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: -

  • Mobile numbers may not be 10 digits (India nos.) – SMS marketing cannot happen if the numbers not in order
  • Email ID’s have spelling mistakes @gmale.com, @gmali.com, @yahooo.com, @hotmal.com – Emails will keep bouncing back even though you have the correct email id.
  • You want to carry out city-wise marketing activities, but the city names are messed up – you would not know how many city-wise customers do you really have?
  • You download data from a back-end system which is all merged into 1 cell. You want the data to be usable quickly.

What all will you learn (completely hands-on) in these3 hours?!

  • Data Structuring correctly
  • Standardizing data at input stage
  • Identifying missing data in a large set
  • Identifying Duplicate & Unique Records
  • Selecting cells based on various types of selections
  • Cleaning, Extracting, Combining Text
  • Find & Replace advance options
  • Working with and Cleaning Numbers & Dates
  • Paste Special
  • Advanced Vlookup technique to streamline data in required format

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

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

Others Details

What you need to get to the workshop It’s going to be completely hands-on, must carry your laptop. Windows users - Excel 2010 or higher version (2016 or Office 365 version preferred) 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 A notepad & a pen. Super Excitement to learn and then apply your learnings ;-) RSVP Call – Carolyn 98922 58067 Email – Learn@DLTC.co

Registration Fees
Free
Registration Ways
Email
Phone
Address/Venue
91 Springboard, B wing, 5th floor, Ackruti Trade Centre, MIDC, Andheri East, Mumbai, Maharashtra, India.  Pin/Zip Code : 400093
Official Email ID
Learn@dltc.co
Contact
Carolyn

carolyn.dltc@gmail.com

   9892258067
Get In Touch