Courses with lecturer

Term

Language

Place

Form

Price without VAT

10. - 11. 2. 2025

Language

Place

online

Form

virtual classroom

Code of the course: PU22010064-0014

Price without VAT

6 700 Kč

Order

10. - 11. 2. 2025

Language

Place

Praha

Form

classroom

Code of the course: PU22010064-0015

Price without VAT

6 700 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: PU22010064-0001

Price without VAT

6 700 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: PU22010064-0002

Price without VAT

6 700 Kč

Order

Expressions of participants

Petr Klusák
Glenmark Pharmacuticals Distribution s.r.o.

"It was amazing, very practical, the lecturer was absolutely fantastic!"

Petr Látal
Glenmark Pharmacuticals Distribution s.r.o.

"The lecturer is very good at explaining and passionate about the subject. She explains very well."

Lucie S.
ČD - Telematika

"An amazing lecturer who knows what she is doing and can pass on her knowledge. Great satisfaction."

Zuzana Fousková
DNS

"Absolutely great, Jana is a pro. She excels in Excel, and on top of that, the energy, liveliness and humor. BRAVO."

Jana P.
Activity agency s.r.o.

"I am extremely satisfied, the course was excellent in all respects. The course was conducted very well by the lecturer. I liked the content. I will definitely use the new information in practice.
The pace of the interpretation was just right. The lecturer always responded flexibly to questions and explained clearly."

Ivan H.
ČD - Telematika

"Excellent lecturer, the course was very beneficial."

Jana M.

"I have no negative comments, the course and the teacher are absolutely great. The online form is perfectly suitable for this topic."

Sylvie Z.

"I really enjoyed doing the course. The lecturer responded perfectly to questions, professionalism at the maximum level."

Monika V.

"Greatly organized training and I learned a lot beyond expectations. "

Ivo K.

"Absolute satisfaction. The best instructor I know."

Course description

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.

Required knowledge

Excel user knowledge.

Target audience

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

Course content

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…

Materials

The course includes trainings materials and excersices.

Objectives

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

Do you want this tailor-made course for your company?

News with the course

Microsoft 365 7. 3. 2024

Microsoft 365 Adoption

Microsoft 365 adoption represents the process of a company's digital transformation. It assists employees in acclimating to new technology, establishing usage rules, and fostering collaboration. Mere tool installation is not sufficient.

More news