Best teachers and best score price/quality & Service Management!
Read more
+31 (0) 20 - 2050324
info@dictsolutions.com

Basic VBA Excel training (2 days)

Map
GENERAL
Target audience
Foreknowledge and level
Duration
Exam details
Extra information
Questions?
During the Basic VBA Excel training 2 days you will learn everything about the basic principles of programming with functions, variables, conditions, loops, debugging, error handling and statements, but also creating macros in applications.  

Basic VBA Excel training course description

By following this Microsoft Excel Visual Basic for Applications (VBA) training you spend less time on your standard activities. This is because you learn to make the macros in applications, with the associated principles such as loops, debugging, error handling, functions, statements and conditions.

If you are not yet familiar with Microsoft Excel, first follow the Microsoft Excel Basic training (1 day) for this training it is expected that you are already reasonably proficient with Microsoft Excel.

If you already have experience with Microsoft Excel Visual Basic for Applications (VBA), check out the Advanced VBA Excel training (2 days).

Content basic VBA Excel training

Visual Basic for Applications (VBA) with Microsoft Excel

  • VB editor: Create macro buttons and play + record the macros
  • Projects
  • Modules
  • Working with variables
  • Objects Model
  • Procedures
  • Working with cells, sheets, and files in Visual Basic for Applications (VBA)

Basic Principles for Visual Basic with Applications (VBA) with Microsoft Excel

  • Events
  • Arrays
  • Variables
  • Loop structures: with repeats for the "do loop" and "for next"
  • Determining conditions with IF

Programming in Visual Basic with Applications (VBA)

  • Solve any Excel problem logically with VBA
  • Executing code in calculations.
  • Build and use functions
  • Logical Troubleshooting In Visual Basic With Applications (VBA)

Security Visual Basic with Applications (VBA)

  • The VBA code security

Visual Basic with Applications (VBA) object model

  • spreadsheet
  • Range
  • Application
  • Workbook

Debugging Visual Basic with Applications (VBA)

  • Preventing mistakes
  • Debugging (error analysis)
  • Making code to fix mistakes

User interaction Visual Basic with Applications (VBA)

  • Input box: input and output
  • Start forms
  • Building Input Forms

Target audience basic VBA Excel training

The target group of the VBA Excel training are (experienced) Microsoft Excel users who want to use Visual Basic for Applications (VBA) to use the macros in Microsoft Excel and to automate or change the Microsoft Excel functionalities.

You are expected to have some advanced knowledge of Microsoft Excel.

Foreknowledge and level basic VBA Excel training 

As stated earlier, you should already have knowledge of Microsoft Excel, otherwise the level is MBO+.

It is of course also recommended that you have access to Microsoft Excel users who have Visual Basic for Applications, look for licenses at Microsoft.

Training duration

basic VBA Excel training 

This course lasts 2 days with a possible extension to a third day, depending on your level of knowledge.

Exam details basic VBA Excel training 

There is no standard exam available for this Excel training, but on request we can test the knowledge of the students with regard to Microsoft Excel Visual Basic for Applications (VBA) by means of a test.

Free implementation workshop / implementation session at Basic VBA Excel training incompany training

If you register your company for a Basic VBA Excel training via D-ICT Solutions, you can always have one of our trainers/consultants visit you (or virtually) for an implementation session Basic VBA Excel training. During this afternoon or morning you will receive advice regarding the optimization or organization of Basic VBA Excel training within your organization by an experienced consultant.

Do you have a question about: Basic VBA Excel training (2 days)

Please feel free to contact us if you cannot find a suitable date.

Basic VBA Excel training (2 days) video lesson
Basic VBA Excel training (2 days) Appendix

FAQ

Lowest price guarantee for the best courses (also for in-company), by working with our own teachers!
We can always provide courses in multiple languages: including German, French, English, Dutch and Italian!
1st place for: best trainers, Price/Quality and Service Management in 2022 and 2023!
Accredited trainers with a lot of work experience, so many examples from practice!
Always more options available because we have our own teachers... Ask about the options!
Look below for a number of examples of option dates, fill in the number of participants and make a reservation!
30,00
700,00
Your shopping cart is currently empty.

Back to shop

Depaus Holding BV / D-ICT Solutions
Verrijn Stuartweg 1A,
1112 AW Diemen
KvK 34143398
VAT NL810633474B01
Bank 45.50.16.429
+31 (0) 20 - 2050324
info@dictsolutions.com
license linkedin Facebook Pinterest youtube rss Twitter Instagram facebook-Blank rss blank LinkedIn-blank Pinterest youtube Twitter Instagram