ONLINE COURSE: EXCEL MACRO VBA
Why Excel Macro?
Excel Macro – also called VBA – stands for Visual Basic for Applications. It’s Excel’s programming language. With the online course in Excel Macro, you learn to program Excel to perform tasks automatically – e.g. automate data processing and data analysis.
What does the course consist of?
The Excel Macro online course consists of small video tutorials, where a feature is shown and explained, followed by a small assignment, you have to try yourself in Excel. All example files from the course can be downloaded. See duration and language options below.
Are you new to Excel? Then we also have the right course for you: Basic Excel.
Why online courses?
Without on-going learning and development, the skills of your employees are quickly outdated. And with outdated skills you risk losing your competitive advantage. With Grape Micro Learning you can quickly build knowledge and grow skills in your organisation.
THE PROGRAM INCLUDES
-
Duration: 60 min.
-
Language: Danish
Excel Macro
The program consist of 5 modules, where you learn to automate your work with macro programming in Excel. The course is for experienced Excel users and requires advanced experience with Excel.
MODULE 1 - INTRODUCTION
Introduction to Excel Macro. Walk-through of course modules and prerequisites.
MODULE 2 - YOUR FIRST MACRO
The module provides a thorough introduction to macros. Learn what a macro is, how to use it, and create the first macro.
MODULE 3 - MACRO RECORDER
The module shows you how to create an entry sheet, fetch and copy data from other workbooks and import data.
MODULE 4 - UNDERSTAND & ADJUST YOUR MACROS
The module provides an insight into the intuitive understanding of your macro, as well as how you, among other things, can edit, customize and delete a macro.
MODULE 5 - TIPS & TRICKS
In the last part of the course you will get tips and tricks in the form of shortcut keys and a quick guide, which can be downloaded and retrieved the next time you work with Excel Macros.
The program has been developed in collaboration with Officekursus.dk, who are specialists within all Microsoft Office programs.
Their skilled Office consultants have developed a range of courses that cater to all levels of learning and development.
How it works
STEP 1
Choose one or more topics
STEP 2
Get matched with a designer
STEP 3
Adapt the course together
STEP 4
Play in your own LMS
