Programming with Visual Basic (VBA) in MS Excel

After finishing this course student has the ability to:

  • Excel security options for using macros
  • Recording and run macros
  • Visual Basic basics:
    • functions and subroutines
    • Excel objects
    • variables
  • Writing macros (to get input data from users, filling tables and arranging data …)
    • Creating Excel function (user defined)
    • Input and output functions (MsgBox ja InputBox)
    • Reading and writing worksheet data
    • Using forms to insert data
    • Conditions (IF, CASE)
    • Different loops (FOR-NEXT, DO-WHILE, DO-UNTIL)
    • Using Excel built-in functions for data analysis
    • Executing subroutine or function from other subroutine
    • Executing subroutine step by step, debugging
  • Creating and using forms

Learning methods: Practical exercise, independent work.

Assesment methods: Execution of independent work.

Assesment form: Independent practical tasks on relevant topics.

FOR REGISTRATION PLEASE FILL THIS FORM HERE: REGISTRATION FORM

Tähelepanu! Teie veebilehtiseja ei vasta kodulehe külastamiseks vajalikele nõuetele. Palun vahetage veebilehitsejat või seadet, millega te veebilehte sirvite.

Attention! Teie veebilehtiseja ei vasta kodulehe külastamiseks vajalikele nõuetele. Palun vahetage veebilehitsejat või seadet, millega te veebilehte sirvite.

Внимание! Teie veebilehtiseja ei vasta kodulehe külastamiseks vajalikele nõuetele. Palun vahetage veebilehitsejat või seadet, millega te veebilehte sirvite.