Find Updates on Training Delivery, Online & Hybrid Training Courses at ITCE in View of COVID-19. Learn more here >>

Browse our Online Live training portfolio here >> 

Visual Basic for Applications – Microsoft Office Excel

B2001 2 days

The course present the extended with Visual Basic for Application functions of Microsoft Office Excel.

Overview

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.


Instructors

Antoniya Neycheva

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.

Register






Once you submit your registration, we will get in touch with you to confirm your interest and attendance.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close