Data Cleaning using Excel VBA - Data Cleaning, Data Preprocessing and datanalysis Examples

Рет қаралды 11,061

Күн бұрын

This Excel VBA Tutorial explains data cleaning using VBA code with simple examples. VBA Code to split cells in excel, split text in excel, remove duplicates, merge cells in excel, merge two columns,
excel clear formatting,excel remove formatting, find blank cells and remove blank cells etc. We can use VBA Code to automate data cleaning, data preprocessing and data analysis tasks to save time in excel.

Пікірлер: 19

@ricardocalleja 3 жыл бұрын

Very useful. Thanks

@ExcelDestination 3 жыл бұрын

You are welcome

@bassisessaidexcel 4 жыл бұрын

Merci

@ashishmohan4707 4 жыл бұрын

Hi amazing sir this is really really useful for everyone and request to you can you plzz upload more video same kind of real time example thanks sir. And one suggestion from my side i donot know wheather this good or not bt plzz reply can you please also upload those excel file also thanks

@ExcelDestination 4 жыл бұрын

Thanks Ashish. I try to reply as much as possible. Sometimes comments are more and time is less. But I try my best to respond as much as possible. I am going to start Live Chat Soon on each Sunday to answer maximum number of question. Thanks again for your comment.

@ashishmohan4707 4 жыл бұрын

@@ExcelDestination thank you sir

@mahendraprajapati9809 Жыл бұрын

Very nice information. This information is too much required. Thank you very much for this video. But to remove duplicate code is not working for me

@jonnathanjon1 4 жыл бұрын

Can you please show a single vba code on how to trim and then remove duplicate for a range of data in a single VBA script. The range should not be defined such as A1: A10 but for the active worksheet and for the Active "selected" range. I wanted to use this script as a Ribbon Add in which should work for any worksheet that I open . I guess your tutorials covers a lot what I need.

@ExcelDestination 4 жыл бұрын

Thanks for watching. I can provide you the required code. You can share your requirement at exceldestination@gmail.com. thanks again

@jonnathanjon1 4 жыл бұрын

@@ExcelDestination Thank You sent you an email. Appreciate sharing your knowledge on this subject.

@archanaaa2514 4 жыл бұрын

Sir for vba interview purpose how much skill we should be perfect in vba?

@ExcelDestination 4 жыл бұрын

More knowledge + less confidence.............. or Less knowledge + high confidence............any combination would work.

@archanaaa2514 4 жыл бұрын

Sir, how to write code for 2 task at a time? like How to write code for trim function and blank cell simultaneously? Within same sub routine how to code?

@ExcelDestination 4 жыл бұрын

whatever code you would write within subroutine that will be executed while calling of that subroutine. So, you can write code for 2 tasks, 3 tasks, 4 tasks......as many you want.

@archanaaa2514 4 жыл бұрын

Sir, am not getting code related to arrays. How to understand dis?

@ExcelDestination 4 жыл бұрын

I have created one tutorial for "Split Cell", where I have used array concept. You can watch that at kzfaq.info/get/bejne/d6qHiZCG1c_JgmQ.html

@mariantonys 2 жыл бұрын

Sir, the code for remove duplicates did not work for me

@harekrishntiwari3378 4 жыл бұрын

Sir I have question, Sir why in industry we have to choose writing a code in vba , when we have an option as Power Query where this could be done in Just few Clicks.

@ExcelDestination 4 жыл бұрын

Good Question. I would say there are multiple tools available in market to accomplish same task. It depends on different factors like comfort, choice, cost etc. I have seen people using command line still, instead of using drag and drop functionality. Anyways, Thanks for your question!