The course presents the extended with Visual Basic for Applications functions of Microsoft Office Excel. The course consists of a series of modules which emphasize on the programming and controlling program flow.
Gain knowledge in working with Visual Basic for Applications
The goal of the course is not just comprehension of the instruments for working with the product, but development of skills to choose the right tool in order to receive the demanded result.
Combine theory with practice
The training is enriched with many demonstrations, practical exercises and scenarios to ensure quick and effective learning.
Put what you’ve learned into practice
After the completion of the course, you will be able to apply your knowledge practically in accordance with the business environment that you work in.
Antoniya is Business Productivity Consultant and Trainer. She is a highly skilled IT professional with more than 10 years of experience in developing solutions and training programs based on Microsoft technologies. Her expertise focus lies in the field of MS SharePoint, MS CRM, MS Office, Business Intelligence and Microsoft e-Learning Gateway solutions implementation.
What you’ll learn
In this course you will learn how to:
- Create macros
- Create and test macros and functions in the editor of VBA
- Understand the structure of the code of the application
- Declare and use variables
- Expand the Microsoft Office Excel environment with new functions
- Use various constructions (if..then..else, for…next, etc.) for the management of the code execution
- Use the objects Application, Workbook, Worksheet, Range.
Frequently Asked Questions
Who should attend?
The course is intended for advanced users of Microsoft Office Excel who want to upgrade their skills in Enhancing Microsoft Office Excel VBA.
Can the training be customized?
Yes. If you are organizing a training for a group of people from your organization, we can discuss what your goals for the group learning outcomes are. This training can be customized to include more real examples from your everyday work that have challenged the team!
What version of Microsoft Office is used during the training?
The training can be based on Microsoft Office 2010, 2013 or 2016 depending on the needs and requirements of your group or organization.