Excel VBA Training
Creating, editing and coding VBA (Visual Basic for Applications) macros is an essential skill for anyone seeking to develop custom Excel spreadsheet applications and automate repetitive data management processes. With AcademyX's Excel VBA training class, you will be able to design feature-rich applications that control Excel's built-in components. For example, with VBA, you can create a financial report that updates automatically based on real-time data, and design custom forms that allow users to connect to spreadsheets, initiate complex calculations, perform compound sorts on rows and columns, and update reports at the click of a button. You can make your Excel applications more usable for novices and automate tedious tasks to improve the productivity of your team.
Our Excel VBA training walks you through the techniques used by professional application developers. We fortify your skills with "try-it" exercises, and provide plenty of shortcuts and hints to get you up and running with VBA in no time.
Getting Started with VBA
The VBA editing environment is like a cockpit - a comprehensive editing environment that includes the code editor, management windows, wizards, inspectors, and plug-ins - making it easy for you to manage projects and assemble code. Knowing how to use these tools efficiently will save you time and effort in building advanced features into your applications. This introductory training session will show you how to:
Working with Expressions, Variables, Functions and Procedures
The fundamental building blocks of VBA syntax are expressions, variables, functions, and procedures. Whether you're new to Visual Basic or a veteran, our training will teach you the best practices for organizing your statements and expressions into procedures and functions, and then later into larger modules. Our Excel VBA training combines comprehensive walkthroughs with hands-on exercises as you learn to:
How to Program Excel Components as Objects
VBA is an object-oriented language, offering all the benefits of object-oriented program design. VBA represents all Excel spreadsheet components, such as forms, worksheets, charts, and PivotTables, as objects that you can call and control using their built-in properties and methods. Understanding how to use objects is not only important to learning Visual Basic, it is central to building professional-quality Excel spreadsheet applications. The walkthroughs and exercises in our Excel VBA training will make you an expert. Specifically you will learn how to:
Working with Forms and Controls
This critical Excel VBA training section will show you how to create professionally designed forms that meet industry-standard user-interface guidelines. You'll learn how to use VBA forms to create dialog boxes and windows to help end users interact with your application. We'll also teach you how to best use the VBA UserForms object's toolbox of controls, such as option buttons, check boxes, text-editing controls, and scrollbars. After this part of the Excel VBA training, you'll know how to:
Debugging Code in Excel VBA
Even well-designed programs can produce unexpected results - bugs - in specific situations. An application developer can spend as much as one-third of their development time debugging their programs, so knowing how to identify bugs quickly is essential to rapid program development. Our training will show you how to:
Handling Errors in Excel VBA
A properly designed and debugged program can still encounter unplanned error events. For example, a user may attempt to save a worksheet when the disk is full, or a procedure can receive a value that is out of range. The solution is to handle errors gracefully, so that when an error occurs, your procedure takes an action, such as giving the user an option to save the file in another location. Our training explains what error conditions are likely to occur, and then walks you through creating your own handling procedures. By the end of this session you will be able to:
Excel VBA training offered at four locations::