You’ve completed the beginner course in VBA, or have some experience. Now challenge yourself with the next step. Advanced VBA is a learner-friendly course that takes you through more powerful features, expanding the possibilities of what you can make with VBA.
VBA, or Visual Basic for Applications, is like Excel on steroids. As an advanced feature, it can seem intimidating at first. But with just a little VBA knowledge you’ll be able to automate tasks in Excel and turbocharge your data handling capabilities.
WHO'S IT FOR?
PC or Mac with a full version of Microsoft Excel (any version from 2003 to 2013 or Microsoft 365).
Not a requirement but a benefit to have some work-related projects to which you can readily apply what you learn.
Individuals and professionals who are familiar with VBA and want to take their knowledge to the next level.
Accountants, bookkeeppers, teachers, salespeople, managers, graduates. The list just doesn't end with Excel.
Modify a variety of standard behaviors, such as double clicking, opening files and saving files.
Learn external libraries, and how you can extend VBA’s capabilities beyond standard Excel options.
Modify the Excel user interface, including the “Ribbon” and context menus to interact with your VBA code.
ABOUT THE AUTHOR
Simon Hurst, BA ACA
Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years during which he has provided a wide range of training services to professionals of all levels. His expertise lies in all the main Microsoft applications and he's been running hands-on Excel training courses for over 20 years, dealing with all aspects of Excel from basic competence to advanced data analysis. He is able to bring these years of practical experience to our Excel and Advanced Excel courses, ensuring that the courses explain advanced concepts clearly and concisely, and with real, practical applications and even the occasional joke.
"Learning and development had not been created as a continuous activity. Training was often one off interventions with the impact difficult to measure. Filtered has helped us change that in a short period of time. The cultural change it has driven in terms of reinforcing an expectation of continuous learning at all levels is the biggest achievement to me."
"We partnered with Filtered because we liked the idea of learners being able to tailor resources based on their knowledge gaps. The quality of reporting data provided allowed us to calculate an ROI of £1.80 for every £1 invested in a licence."