Skip to main content

ONLINE COURSE: EXCEL MACROS

Online Excel course – a world of opportunities

Why Excel Macro/VBA?

Excel Macro – also known as VBA – stands for Visual Basic for Applications. It is Excel’s programming language. With the Excel Macro online course, you will learn how 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 short videos where a function is first shown and explained, followed by a small task for you to solve. 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 it can be used and create your 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 and how to 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.