Automate Data Processing & Transformations with Excel VBA

Work directly in VBA Editor to develop code that will automate your data processing and transformations.

Created by: Carl Walenciak
Data Analytics Specialist

What Will I Learn?

• Importing and exporting data
• Work with data directly in the Excel VBA Editor
• Develop a data preperation workflow
• Learn how to structure data for efficient transformation.

Requirements

• Access to Excel.
• Beginners knowledge of Excel VBA
• Understanding of Subroutines, Functions, Variables, If Statements and For Loops

Target audience

• Analyst who would like to automate there data processing task with Excel VBA.
• Someone with the beginners knowledge of Excel VBA who wants to take the next steps to advance their skills.
• Someone who has worked in other programming languages like python, who has only used libraries but would like to build functions from scratch and see the inner workings.