About this course
This one day course is for advanced Excel users who have never used Visual Basic for Applications (VBA) and who would like to learn how to automate repetitive tasks. This course moves at a fast past and is an introduction to the basics of editing macros.
What you will learn
- Record relative and absolute macros.
- Run macros from buttons and shortcut keys.
- Edit macros in the VBA Window.
- Make macros more flexible by adding user prompts.
- Create VBA code to split up text strings.
- Loop macros using VBA.
- Create macros that run other macros.
Recent reviews
Most of the day was excellent, interactive, interesting. Plenty of opportunity for questions, really friendly knowledgeable trainer. The last 45 minutes, when we went into Power Pivot / Power Query, didn't go as smoothly: it wasn't polished.
Good day very helpful with my learning.
The food ran out really quickly, we were the last cohort to go to lunch and there was no real food left. People were offered Pret vouchers which was good, but it would have been nicer to have eaten together. Otherwise I have no complaints.