Description 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. Further information Provider: Happy Duration: 1 Day
Locations:
London
Contact Information Happy
3rd Floor
Locations
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.
Duncan M 13 Mar 19
Good day very helpful with my learning.
Oliver W 29 Jan 19
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.
Alexa H 29 Jan 19
Ran out of food :(
Russell D 29 Jan 19
Generally happy with the course. Felt it could have been better tailored to our specific needs, especially since we booked it as a team.
Sam B 29 Jan 19
Read more reviews >
020 7375 7300
Email