Excel VBA basic course
Excel VBA Basic Course - conducted in English
This Excel VBA course teaches you to automate your work with Excel’s built-in programming tool called Visual Basic for Application. You will learn to create macros in Excel and it give you a good basic understanding of VBA programming language.
You will learn to automate different routines with VBA using Excel objects, how to handle basic user input/output, and how to use the built-in programming structures such as loops and conditions.
The overall objective of this course is for you to be able to create simple tools to save time when dealing with repetitive tasks in Excel.
Requirements
To take full advantage of the course, we recommend that you are an experienced user of Excel or have knowledge corresponding to our advanced course.
You can attend this course regardless of the Excel version you are using.
Duration
2 days at 09: 00-16: 00
- 2 dage kl. 9:00 - 16:00
- 8.500 kr. ex. moms
-
Kurset tilbydes også som
solo- eller firmakursus
Excel VBA Basic2 dage
Excel VBA Basic2 dage
Excel VBA Basic2 dage
Excel VBA Basic2 dage
Course content
Macro recording
- Where are macros stored
- Relative and absolute recorded macros
- Shortcuts and buttons for macros
- Using the Visual Basic Editor to modify macros
Intro to Visual Basic Editor
- Settings
- Views
- Creation of procedure and functions
Using Dialogs
- Input box
- Message box
- Design of data entry forms
Data Types and Variables
- Declaration of a variable
- Constants
- Standard variable naming conventions
Programming structures
- If-Then-Else
- Select Case
- Do-Loop
- Do-While
- For-Next
Excel Objects properties and metodes
- Application
- Workbook , ThisWorkbook, ActiveWorkbook ,
ActiveSheet, Worksheet - Range
- Select
- Cells, Rows, Columns
- Address
- Offset
Events
- Workbook_Open/_Deactivate/_Activate
- Workbook_BeforeSave/_BeforeClose
Other topics
- Integration with other Office programs
- Error Handling
What you get from the course
Breakfast, lunch,
coffee, tea, cake.
The material can be used as a reference in the future.
After completing the course, you will receive a course certificate.
Even after the course is over, you can always get help.
How we teach
In our courses, the teaching will alternate between theory and practice. We place a high value on active learning in our teaching. This means that even during a review of new topics, you will be actively engaged on the keyboard along with the instructor, followed by a series of tasks you need to complete.
Meet the course instructors.
Related courses
After this course, we recommend that you take a view on our Power BI Course.
You can see the entire Excel course overview here.
Also, check out our Excel courses in Excel Courses in Copenhagen and Aarhus
