Economic data analysis in MS Excel with VBA 2400-ZEWW873
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.
Detailed subject of the course:
1. Introduction to VBA
2. VBA objects
3. Functions and formulas in VBA
4. Conditional statements
5. VBA loops
6. File operations
Note 1: the course is part of the educational path "Economic data analysis in Microsoft Excel and the VBA programming language", upon completion of which participants receive a certificate. Details on the WNE UW website (Student> Educational Paths).
Note 2: classes are held in the form of e-learning (full class materials with solutions and pre-prepared instructional videos explaining the issues discussed - no live classes) on the platform: https://moodle.wne.uw.edu.pl.
Note 3: materials are published once a week in blocks of 5 teaching hours. The course ends in December.
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 devoted to programming in VBA.
Note 5: The software version in the course is Microsoft Office 2021 or 365 (language version: English, operating system: Windows). Using an earlier version is possible, but it may cause some difficulties. The Polish 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.
Rodzaj przedmiotu
Koordynatorzy przedmiotu
Efekty kształcenia
The student will acquire the ability to automate work in MS Excel with Visual Basic for Applications (VBA) programming language. Subject matter consistes of the following: introduction to VBA, recording macros, editing code, its’ structure and optimization, defining variables: numeric, text, array, objective, constructions: With … End With, For Each … Next, conditional statements: If…Then…Else, Select Case, loops: Do While… Loop, Do Until… Loop, For… Next, instruction: GoTo, dialog boxes: MsgBox and InputBox. You will be able to automate e.g. importing data from many files, creating consolidated databases, dynamically setting ranges, editing and formatting ranges as well as whole worksheets, preparing periodic sales reports, printing selected ranges and exporting results to separate Excel and PDF files.
Kryteria oceniania
The final grade consists of:
• collective homework (in the form of a final project)
• additional activity in discussion forums
Punctation:
Score points
[0-50) 2
[50-60) 3
[60-70) 3.5
[70-80) 4
[80-90) 4.5
[90-100) 5
from 100 5!
Literatura
own materials
Więcej informacji
Dodatkowe informacje (np. o kalendarzu rejestracji, prowadzących zajęcia, lokalizacji i terminach zajęć) mogą być dostępne w serwisie USOSweb: