Excel VBA applications in enterprises I 2400-ZEWW606

This course is dedicated to people who want to learn the world of macro commands and those who know the basics of the VBA programming language and want to systematize and deepen their knowledge. There are no IT skills prerequisites, but very good knowledge of Excel is required. The aim of the Work Automation in MS Excel using VBA language course is to automate everyday work in Excel using macro commands. The entire course is devoted to learning the Visual Basic for Applications (VBA) programming language.

The course consists of 2 parts.

Part 1 (Automation of work in MS Excel with the use of VBA):
1. Introduction to VBA
2. VBA objects
3. Functions and formulas in VBA
4. Conditional statements
5. VBA loops
6. File operations
Part 2 (Working efficiently in VBA in MS Excel):
1. Efficient programming methods
2. Procedure types (Sub and Function)
3. Pivot tables
4. Charts
5. Event handling
6. Shapes (handling form controls)

Note 1: hybrid form of classes - students can participate in classes in a stationary or remote form (to choose from).

Note 2: the course is part of the educational path "Business applications in Microsoft Excel using the VBA programming language", upon completion of which participants receive a certificate. Details on the WNE UW website (Student> Educational Paths).

Note 3: the classes are held in blocks of 4 teaching hours. The entire course is 60 hours long.

Note 4: the course requires a lot of students' own work and is dedicated to people who want to learn to program well in VBA. Classes are conducted at the advanced level and are devoted to programming in VBA.

Note 5: The software version in the course is Microsoft Office 2021 or later (language version: Polish, operating system: Windows). Using an earlier version is possible, but it may cause some difficulties. The English language version is not a major problem, but the course a different operating system is (e.g. MacOS) due to the limitations of the Office suite (possible lack of necessary software components). The University of Warsaw does not provide participants with the necessary computer hardware or software.