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

Advanced VBA Excel training 2 days

Map
GENERAL
Target audience
Foreknowledge and level
Duration
Exam details
Extra information
Questions?
During the Advanced VBA Excel training 2 days which is the continuation of the Basic VBA Excel training – 2 days more is being programmed. The student learns modular programming to use a macro more effectively and effectively. During the Advanced VBA Excel training 2 days, a link is also made with macros that are controlled by Microsoft Word and Microsoft Access.

Advanced VBA Excel training course description

After following this Advanced VBA Excel training for 2 days you will be able to extend, master and compile advanced macros. The training lasts 2 days but a third day is optional, this is determined by your level of knowledge.

Topics Advanced VBA Excel training 

Databases Microsoft Visual Basic for Applications (VBA)

  • Using Microsoft Access data in Microsoft Excel
  • Using Special Selection

Interacting Microsoft Visual Basic for Applications (VBA)

  • Compiling advanced forms
  • Combining the list boxes in forms
  • Choose multiple options from drop-down lists

Charts Microsoft Visual Basic for Applications (VBA)

  • Charting with Visual Basic for Applications (VBA)
  • PivotTables with Visual Basic for Applications (VBA)

Modular Programming Microsoft Visual Basic for Applications (VBA)

  • compose email from Excel with data from Microsoft Excel
  • Using “For Each”.
  • Objects: add, move, close, open and close
  • File System Object (FSO)
  • Faster code reuse
  • Working with Sets
  • Working with Find
  • Combining data from Microsoft Excel and Microsoft Word

Special cells in Visual Basic for Applications (VBA)

  • Search for: last cell, empty cells, formulas and numbers & texts

Search within Visual Basic for Applications (VBA)

  • Search single values ​​and all occurring
  • Search in multiple magazines

Introduction to VBScript (VBS)

  • Outside of Microsoft Excel Programming
  • Controlling Excel and Word
  • Debugging

If you are looking for related training courses, it is best to go to the overview page Microsoft Office trainings to look. Before you can participate in the training, you must be at the level of the Basic VBA Excel training (2 days).

Target audience Advanced VBA Excel training

The target group for this training is he/she who already uses Microsoft Visual Basic for Applications (VBA) and wants to work more effectively & efficiently with Visual Basic for Applications (VBA).

Advanced VBA Excel training Prerequisites

The starting level for this training is advanced Microsoft Excel knowledge and the knowledge Basic VBA Excel training (2 days) you must master and the level is MBO+.

Advanced VBA Excel training training duration

As indicated, the training lasts 2 days with an optional third day.

Advanced VBA Excel training exam

An exam is available on request to test your knowledge of VBA Excel.

Free implementation workshop / implementation session with Advanced VBA Excel training incompany training

If you register your company for an Advanced VBA Excel training via D-ICT Solutions, you can always have one of our trainers/consultants visit you (or virtually) for an implementation session Advanced VBA Excel training. During this afternoon or morning you will receive advice from an experienced consultant with regard to optimizing or setting up VBA Excel within your organization.

More information about Microsoft Visual Basic can be found at Microsoft find.

Do you have a question about: Advanced VBA Excel training 2 days

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

Advanced VBA Excel training 2 days video lesson
Advanced 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