UEL-10

Automation basics - an introduction to macros

Form of participation
Form of training
Length of training
  • 1 day (1×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Trainer recommendation

Horváth Elek

Horváth Elek trainer

I can confidently say that this course reveals the boundary where spreadsheet management diverges from programmed spreadsheet management. We highlight the essential knowledge necessary for easily learning macro writing. I wholeheartedly recommend it to anyone who has yet to decide how deeply they want to delve into programming or to those who already know they want to master macros completely.

Description

Excel macros are one of the most important tools for automated work. The training will show you how to simplify and speed up your work using macros. Participants will learn techniques for creating macros and the basics of the Visual Basic programming language, while being able to algorithmise and program simple tasks.

Outline

  • Excel macros capture and capture settings
  • Basics of object-oriented programming
  • Introduction to the VBE interface
  • Basic instructions in VBA
  • Creating simpler program code (searching for data, sorting using macros)
Outline (PDF)

Prerequisites

Advanced knowledge and experience of Excel is required to successfully complete the training. Previous programming knowledge and experience would be an advantage.