The final basic usage of Excel, and the final part of the Excel Basics Course is Excel VBA Automation for Beginners. Firstly, what is meant by ‘automation’? To do automation, you first must have a ‘process’ to automate. A process means manual work in Excel: those tricky and onerous jobs, often involving copy / pasting data around Excel, that take hours and leave you thinking ‘there must be a better way!’
Well, with automation in Excel’s coding language, there is. In the final part of the Excel Basics course, I introduce you to the fundamental concepts and techniques of Excel VBA whilst working through a ‘real-world’ task. The aim of the exercise is to get some manual work done ‘at the click of a button’ and I am sure that, after completing these sessions, you will appreciate the potential to apply Excel VBA to your work.
Yes, coding means a big step up in difficulty. But, I promise, the results will be worth it. Get your coder hat on and let’s get this adventure started …
Session Titles And Learning Outcomes
SESSION 1: Your First Excel Macro
- know how to set up your system for VBA
- write a short macro in the VBA editor
- insert a button and assign a macro to it
SESSION 2: Interacting With Cells Using A=B
- understand concept of a=b
- put a value in a cell using Excel VBA
- move data between cells using VBA
- use a cell entry with VBA to transfer data
SESSION 3: Excel VBA Variables For Beginners
- understand what a variable is
- declare a variable
- assign a value to a variable
SESSION 4: Position Control With Excel VBA 1
- use the dot cells referencing technique
- use the dot cells technique with a variable
SESSION 5: Position Control With Excel VBA 2 And More Variables
- use the offset method to control position
- understand the two main variable types - integer and string
SESSION 6: Excel VBA Loops For Beginners
SESSION 7: Combining Excel VBA Techniques In A Powerful Macro
- use .xlup to find the next empty row
- combine VBA techniques together to create a powerful macro