Excel VBA in Enterprises
General data
Course ID: | 2400-ZEWW682 |
Erasmus code / ISCED: |
14.3
|
Course title: | Excel VBA in Enterprises |
Name in Polish: | Aplikacje Excela w przedsiębiorstwie z wykorzystaniem języka VBA cz. II |
Organizational unit: | Faculty of Economic Sciences |
Course groups: |
(in Polish) Przedmioty kierunkowe do wyboru - studia II stopnia EP - grupa 4 (1*30h) (in Polish) Przedmioty kierunkowe do wyboru - studia II stopnia FR - grupa 2 (2*30h) (in Polish) Przedmioty kierunkowe do wyboru - studia II stopnia IE - grupa 2 (2*30h) (in Polish) Przedmioty kierunkowe do wyboru- studia I stopnia EP (in Polish) Przedmioty wyboru kierunkowego dla studiów licencjackich EM (in Polish) Przedmioty wyboru kierunkowego dla studiów licencjackich FIR (in Polish) Przedmioty wyboru kierunkowego dla studiów licencjackich IE (in Polish) Przedmioty wyboru kierunkowego dla studiów licencjackich MSEM (in Polish) Przedmioty wyboru kierunkowego dla studiów licencjackich MSEMen |
ECTS credit allocation (and other scores): |
6.00
|
Language: | Polish |
Type of course: | optional courses |
Short description: |
This is the second part of the course in VBA programming and application development in Excel. Students learn advanced programming techniques, which they will use to write your own applications in spreadsheets. |
Full description: |
This course is a continuation of courses "Excel VBA applications in enterprises II" and " VBA tools in economic data analysis". Detailed list of topics: 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. Note 1: classes are held in the form of e-learning on the platform: https://moodle.wne.uw.edu.pl (no live classes). Note 2: The software version in the course is Microsoft Office 2019 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. |
Bibliography: |
- materiały własne; - Walkenbach J., Excel 2013 PL. Programowanie w VBA. Vademecum Walkenbacha, Helion 2013; - Green J., Bullen S., Bovey R., Alexander M., Excel 2007 VBA Programmer's Reference, Wiley Publishing, Inc. 2007; - Bovey R., Wallentin D., Bullen S., Green J., Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Addison-Wesley 2009; - Flanczewski S., Excel. Tworzenie zaawansowanych aplikacji, Helion 2012; - Jackson M., Staunton M., Zaawansowane modelowanie finansowe z wykorzystaniem Excela i VBA, Helion 2004; - Jelen B., Syrstand T., Microsoft Excel 2010 PL. Język VBA i makra. Akademia Excela, Helion. |
Learning outcomes: |
After completing the course the student obtains the ability to efficiently use Excel and VBA. They will be able to use, build and modify VBA procedures to customize it to your needs, including: array variables, Sub and Function procedure, advanced pivot tables, advanced charts, events, shapes, form controls and Active X controls, built-in dialog boxes, UserForms and advanced UserForm. Students will also know how to create professional applications in Excel using VBA. |
Assessment methods and assessment criteria: |
The final evaluation consists of: • two cumulative homework each scored 50 points; • additional points. Scoring: Points Mark (0 - 50) 2 (50 - 60) 3 (60 - 70) 3,5 (70 - 80) 4 (80 - 90) 4,5 (90 - 100) 5 100+ 5! |
Classes in period "Summer semester 2023/24" (in progress)
Time span: | 2024-02-19 - 2024-06-16 |
Navigate to timetable
MO TU W TH FR |
Type of class: |
Seminar, 60 hours
|
|
Coordinators: | Przemysław Kusztelak | |
Group instructors: | Przemysław Kusztelak | |
Students list: | (inaccessible to you) | |
Examination: |
Course -
Grading
Seminar - Grading |
Copyright by University of Warsaw.