Microsoft Office Excel VBA
- Cost-effective bespoke training
- Trusted and experienced
- Fully accredited with reputable trainers
- Train online or at your premises
- Tailored 1-to-1 and group training options
- FREE training plan & support
With this course, you will gain the skills to write Visual Basic for Applications (VBA) within the system of Microsoft Office Excel for your Leicester business. You will have the expertise to understand, analyse and master the art of making macros in order to optimise your experience in Excel. VBA is known to be an ‘assisting hand’ with Excel, allowing you to have more freedom with your methods and commands within the system.
VBA is an effective built-in tool that will allow you to write your own commands and is not only used in Excel but is a foundation language used in programmes such as Powerpoint and Word.
As you will become familiar with the functions of Excel, you will see that VBA is a great asset to have with the many tools that Excel has to offer. Tasks such as repetitive commands and creating custom functions will be available to contribute to your Excel experience and with your project.
- Using and Editing Macros
- Exploring the Visual Basic Environment
- Subs and Functions
- Variables
- Decision Making Tools
- Looping Tools
- Basic Arrays
- String Functions
- Controlling Excel
- Working with Collections
- Error Routines
- Debugging Code
- Creating User Forms
- Adding Buttons in Excel
