From the course: Learning Data Analytics: 1 Foundations

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Cleaning data using Excel macros

Cleaning data using Excel macros

From the course: Learning Data Analytics: 1 Foundations

Start my 1-month free trial Buy for my team

Cleaning data using Excel macros

“

- You may find in an organization, they're using older methods of cleaning data. They may be using Excel Macros. It could be that that vowel just hasn't been touched in a while, or they haven't adopted tools like Power Query. It's important to know when you inherit a file, you inherit the knowledge, and the style of the person who is responsible for that file. However, macros are a great way to determine what needs to be cleaned, and also a great opportunity for process improvement. Okay. Let me show you how to record a few macros, and show you how to look inside a macro. Okay. I'm in my spending trends survey, and every time I download this data, I see the same type of information is structured exactly the same. The only difference is there's new data each time. Okay. So I have my developer tab turned on in my ribbon. You can go to customize your ribbon to turn it on if it's not there. I'll choose record macro. This will be step one. This step one will copy the sheet. Okay, I'll go…

Contents