This is a two-day training course tailored to give experienced Excel users the skills required to use Excel’s VBA (Visual Basic for Applications). Lead by dedicated instructors with expertise in the Microsoft Office package, you’ll learn how to confidently navigate and utilise the VBA editor to run, edit and debug VBA code. We’ll teach you how to get started with VBA and provide you with a solid foundation on the Excel Object Model along with the associated properties, methods and events which are the building blocks of the VBA programming language.
Raising the Bar training courses are carefully designed so that all students achieve the best possible learning outcomes. You'll be guided by industry experts as you learn earn through clear instructions, insightful demonstrations and hands-on activities. Our class sizes are small so that all students can learn in a supportive environment and we provide all equipment so you just need to show up. Upon completion, you'll leave with brand new skills and knowledge of Excel VBA, with the ability to automate standard features and develop programs. You will have gained the proficiency required to write code and use a range of common programming techniques using Excel VBA.
When you finish the Excel VBA Basics course, you’ll receive a certificate of completion and a course manual you can work through at home to further develop your VBA skills.
Who Should Attend This Course
The Excel VBA Basic Training Course is designed especially for students who already have an advanced knowledge of Excel and utilise these skills on a daily basis. Participants should have working knowledge of how to record and run macros and must be able to confidently nest functions before undertaking this training. This course is perfect for users who want to automate and customise complex calculations and processes in their current work flows.
Typically, students who attend this course already have a high level of confidence with Excel and know how to create professional and productive spreadsheets using Excel’s more complex and technical features and formulas. This course is right for you if you’re an experienced Excel user who wants to learn the basics of using VBA, write code and employ various programming techniques. We’ll familiarise you with the software and teach you how to use VBA securely, run and debug code from the VBA editor, work with variables, loops, perform tests, interact with the user, build your own User Defined Functions, learn how to handle errors and create and implement Excel Userforms.
Our public training courses are available in our North Sydney training facility throughout the year. For students in other cities, group training sessions are available by appointment for companies in Sydney, Melbourne, Adelaide, Canberra, Brisbane and Perth.