Page 1 / 2

Use the side arrows or keep scrolling near the end of the page.

Close reader

Use the side arrows or keep scrolling near the end of the page.

Page 1

VBA programming

Active courses: 1 2 pages
VBA programming

Category overview

.NET programming, C ++

For those who want to learn how to program or improve their programming, we have prepared some interesting courses with which you can start or move your career as a programmer.

We choose from the menu for you:

Introduction to programming - The Introduction to Programming course is for anyone who wants to learn how to program in any programming language.

. NET Framework - basics of programming - basics of programming is intended for beginning programmers, or for programmers who want to start programming on the .NET platform Framework (VB.NET or C #).

Visual C / C ++ object-oriented programming - Visual C / C ++ object-oriented programming training is focused on mastering specific properties of C ++, the basics of object-oriented programming .

Programming in Windows API - The Windows API is a set of libraries, procedures, functions, interfaces, and constants for applications to interact with the operating system. Such API access is practically the most efficient (and therefore the fastest) way to work with windows, files, registry, graphics, printers, as well as the Internet, audio, and video.

You will find training curricula for each individual course.

The advantage of database training in Macrosoft s.r.o. there are usually smaller groups of trainees. Experienced lecturers are a guarantee of thorough adoption of the curriculum with emphasis on the needs of clients. Of course, there is also room during the training for questions that interest clients in practice.

Other benefits that our clients appreciate include comfortable, bright and spacious training rooms, as well as refreshments during breaks. Upon completion of the course, which takes place in a relaxed atmosphere, each participant will receive a Macrosoft training graduate certificate. Macrosoft certifications are widely accepted by employers, including large organizations and companies.

Contents

Active courses: 1

Open course

Price incl. VAT

239.85 €

Current VAT 23%

Course overview

Excel macro training and an introduction to VBA is intended for those who already have more advanced experience with Excel and want to learn how to create and debug macros - program.

Minimum input knowledge

Bežné ovládanie PC, skúsenosti s Microsoft Windows. Pokročilá úroveň ovládania Excel, najmä práce so vzorcami a funkciami.

Output knowledge

Zvládnutie tvorby jednoduchých programov a makier v Exceli. Vďaka týmto vedomostiam budú absolventi tohto kurzu schopní zefektívniť svoju prácu.

Training syllabus

Úvod, popis vývojového prostredia VB

úvod do problematiky popis vývojového prostredia VB (projekt explorer, toolbox, okno na prezeranie grafického vzhľadu objektov, okno s kódom, properties window) nastavenie niektorých vlastností IDE, dockovanie okien história, verzie

Základy makier

vysvetlenie pojmu makro, zabezpečenie, možnosti tvorby makra automatizovaná tvorba makra – výhody a nevýhody, úprava makra programovanie makra - zoznámenie sa s Visual Basic For Aplication (VBA) zošit osobných makier

Dátove typy, premenné, konštanty a operátory

deklarácia premenných, základné dátové typy, rozsah platnosti premenných konverzia dátových typov, konštanty, operátory (+, -, / .... AND, OR...)

Riadenie toku a vetvenie

podmienené a nepodmienené skoky cykly (For each, Do, While, With) riadenie toku programu – príkazy IF a SELECT

Polia a kolekcie

práca s poliami, statické a dynamické polia

Prostredie MS Excel

možnosť využitia štandardných funkcií Excelu pri programovaní napojenie VBA kódu na prostredie Excelu, prístup k bunkám, rôzne možnosti odkazovania, offset, získanie a zmena hodnoty, zmena vzhľadu

Procedúry, funkcie, moduly

vytváranie a používanie odovzdávanie parametrov odkazom a hodnotou (ByRef, ByVal) moduly ochrana kódu - jeho uzamknutie heslom

Základné ovládacie prvky

charakteristika, základné vlastnosti diskusia záver