Excel IV - Macros

In this course we will show you what a macro is, where you could use it and what are the basic principles of macros in excel.
You will learn the basic syntax of properties and methods and understand how to substitute values and the ubiquitous use of the With and End With statements. 
You will learn how to make part of the statements repeated, create various conditions in the code that cannot be loaded, and learn about popular syntaxes.

Excel user knowledge. To fully utilize all features, we recommend accessing the full version of Excel.

For everyone who wants to broaden their horizons and make their work easier thanks to excel and macros.

Where to find macros

• Developer tab
• Excel in developer mode

How to upload a macro

• rules for names and keyboard shortcuts
• Personal.xlsb

How to run a macro

• buttons on the Quick Access panel
• custom buttons in a worksheet
• macro options

Visual Basic for Application (VBA)

• introduction to the environment
• projects, properties, modules

Object model

• Properties
• methods

Macro debugging

• break mode
• stepping macro

Program branching and cycles

• If… then… else
• For i… next i
• Do until / while… loop

Error handling

• On error…

The course includes trainings materials and excersices.

• Naučit se vytvářet makra.
• Znát pravidla pro názvy a klávesové zkratky, Personal.xlsb
• Spuštění a možnosti maker.
• Edit macros in VBA code
• Be able to set some commands to repeat

What is a macro in Excel and what is it used for?
A macro is a recorded sequence of steps or commands in Excel that can be saved and run again with a single click. It's used to automate repetitive tasks — such as formatting tables, cleaning data, or generating reports — so you don't have to perform them manually every time.

What knowledge do I need before taking the macros course?
The course page lists "user-level knowledge of Excel" as the requirement — meaning general experience working in Excel, not specific programming skills. To make full use of all the features covered in the course, access to the full version of Excel is recommended.

What is VBA?
VBA (Visual Basic for Applications) is a programming language built into Excel used to create and edit macros. While a simple macro can be recorded without writing any code, VBA lets you go further — adding conditions, loops, and error handling to build more sophisticated and flexible automations.

Do I need to know programming to learn macros?
No, not to get started. You can record basic macros just by clicking through the Record Macro feature, without writing a single line of code. The course then walks you step by step through the basics of VBA (syntax, conditions, loops), so even without prior programming experience you'll learn not just to record macros, but also to edit them.

How do I record a macro in Excel?
Open the Developer tab and click Record Macro. Enter a macro name (no spaces) and, if you like, a keyboard shortcut, then confirm with OK. Perform the steps in the workbook you want to record — Excel will capture them in the background. Finally, click Stop Recording. You can then run the macro again at any time and the steps will repeat automatically.

How do I enable the Developer tab in Excel?
Go to File → Options → Customize Ribbon. In the list of main tabs on the right, check the Developer box and confirm with OK. The tab will then appear on the ribbon and stay there permanently until you turn it off yourself.