Excel VBA applications in enterprises II 2400-ZEWW682
This course is a continuation of courses "Excel VBA applications in enterprises I" and " VBA tools in economic data analysis".
The course consists of 3 parts.
Part 1 (user interface):
• Active X controls
• built-in dialog boxes, UserForms
• advanced UserForm examples
• change shortcut menus
• ribbons editing
• Excel Add-In;
Part 2 (work on external objects):
• folders and files
• text editors
• mail editors
• presentations editors
• Visual Basic components
• Windows API functions
• class modules
Part 3 (developing applications):
• design Excel applications
• application examples
• presentation student projects
Notes:
1. Classes are conducted using the Flipped Classroom method, in accordance with the methodology recommended and used by, among others, Columbia University and the University of Washington. Live, remote sessions include an introduction to each thematic section and a presentation of final projects. All course materials are available in an e-learning format on the https://elearning.wne.uw.edu.pl platform (complete course materials, including solutions and pre-recorded instructional videos explaining the topics covered). You can work through them at your own pace. Any questions can be discussed with the instructor during individual online consultations.
2. The course is part of the educational track titled “Business Applications in Microsoft Excel Using the VBA Programming Language,” upon completion of which participants receive a certificate. Details are available on the WNE UW website (Student > Educational Tracks).
3. The entire course is 60 hours long and is divided into 4-hour thematic blocks.
4. The course requires a significant amount of independent study from students and is designed for those who want to learn how to program effectively in VBA. Classes are taught at an advanced level and focus on VBA programming.
5. The required software version for the course is Microsoft Office 2021 or newer (language version: Polish; operating system: Windows). Using an earlier version is possible but may present some difficulties. The English language version is not a problem, but a different operating system (e.g., Mac) may cause some difficulties (different Ribbon layout, different behavior of certain Excel tools, different keyboard shortcuts). The University of Warsaw does not provide participants with the necessary computer hardware or software.
6. Attendance at the final project presentations is mandatory.
Estimated student workload: 6ECTS x 25h = 150h
(C) - contact hours (I) - independent study hours
- preparation for class: 0h (C) 6h (I)
- classes: 40h (C) 0h (I)
- review of class material: 0h (C) 18h (I)
- preparation of homework assignments and final projects: 0h (C) 66h (I)
- consultations: 12h (C) 0h (I)
- presentation of final projects: 8h (C) 0h (I)
Total: 60h (C) + 90h (I) = 150h
|
Term 2025L:
This course is a continuation of courses "Excel VBA applications in enterprises I" and " VBA tools in economic data analysis". The course consists of 3 parts. Part 1 (user interface): Part 2 (work on external objects): Part 3 (developing applications): Note 1: elearning form of classes on the platform: https://elearning.wne.uw.edu.pl (complete class materials with solutions and instructional videos explaining the issues discussed - no live classes). 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. Szacunkowy nakład pracy studenta: |
Course coordinators
Type of course
Learning outcomes
The student will be able to apply advanced programming methods in VBA, create a user interface based on: control forms, ActiveX forms, built-in dialog boxes and custom UserForm dialog boxes, as well as write custom Excel add-ins. The student will also learn what features a professional Excel application should have, and will learn methods for creating applications that reference other programs (including Windows folders and files, text files, text editors, mail programs, and presentation programs), as well as how to create their own object classes. The student will gain the ability to create advanced Excel add-ins, modify the ribbon and pop-up menus, and be able to create professional utility applications.
Students who complete the Economic Data Analysis pathway in Microsoft Excel and the VBA programming language with at least Very Good grades will receive special certificates confirming the acquired knowledge and skills. Such a certificate can be a valuable item in your CV!
Assessment criteria
The final grade consists of:
• two collective homework, each scored 50 points;
• extra points for activity.
Assessment:
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!
Bibliography
own materials