Excel Visual Basic (VBA) for Beginners – Use Excel VBA to Cleanse a Dataset Part 4/5

This Excel VBA for Beginners series is aimed at Excel users just starting out with code, or those who have never coded, and who are curious about it. Too often, Excel users find themselves engaged in tricky manual tasks that take up time and create stress. Data cleansing is one such task. If you have ever gone through a list of data and looked for mistakes (in the spelling of people’s names, for example) then you have done a data cleansing task. It probably was not much fun! With a little coding knowledge, it is possible to dramatically speed up this kind of task, reduce the stress, and kick start your coding journey. Welcome to Excel VBA for Beginners!

DOWNLOAD the file and read the article here:
http://tinyurl.com/hnc897h

Video 1

Video 2

Video 3

Video 4 (this video)

Video 5

If you develop confidence in these areas, it won’t just save you time, it will transform the way you work with Excel spreadsheets.

I would love to hear from you – did the series help, and what are you trying to get done using Excel VBA?

For regular spreadsheet hints and tips and more on the #ExcelRevolution:
https://www.facebook.com/TigerSpreads…
https://twitter.com/TigSpreadsheets
http://tigerspreadsheetsolutions.co.uk