Automate Data Processing & Transformations with Excel VBA

This course will cover an area that most leave out, working directly in the VBA editor to process and transform your data. We are going to work with Excel VBA like any other programming language such as Python or R, and not just like an add-on to Excel that just formats your worksheets.

We will first start with a refresher on arrays and objects. Then we just jump into getting data from worksheets and other workbooks. In any business setting a lot of data you will receive will be in an Excel workbook, so it is important that you can gather this data programmatically.

In our transformation section, we will be building 14 functions to help process and transform your data. This will all be written from scratch. This section is meant to give you functions that you can immediately apply in your day job, but more importantly, it will help you start thinking about how you can start building other functions to add to your toolbox. We will then improve those functions by learning to work with header names instead of working with indexes.

Finally, we have your ERP project. This is where you will use what you learned to help solve a real-life scenario that comes up a lot in business, data migration to a new ERP system.