This individual crash course will give you an overview of Macros/VBA and its application to Data Analysis. At the end of the course you will be able write a VBA code and your fundamental knowledge of programming will prepare you to expand your skills further.
The course specifically covers:
- Overview of Macros
- Types of Variables
- Custom Functions
- Form and Message Boxes
- Conditional Statements: If, Then, Else, Select Case
- Loops: For-Next, While-Wend, Do-Loop
- Error Handling
- Practical Applications: Data Consolidation, Automating Dashboards, Pivot Tables and Graphs
"Jacek is one of the smartest people that I have worked with. His ability to provide huge swathes of in-depth analysis are impressive to say the least and his brain is seemingly able to compute huge amounts of data whilst his Excel skills are second to none."
- James Kaye, Director and Co-Founder at Big Ideas Machine
You may also be interested in: