University of Warsaw - Central Authentication System
Strona główna

Advanced Excel – VBA Programming II

General data

Course ID: 2400-INTER-EXVBA2-OG
Erasmus code / ISCED: 14.3 Kod klasyfikacyjny przedmiotu składa się z trzech do pięciu cyfr, przy czym trzy pierwsze oznaczają klasyfikację dziedziny wg. Listy kodów dziedzin obowiązującej w programie Socrates/Erasmus, czwarta (dotąd na ogół 0) – ewentualne uszczegółowienie informacji o dyscyplinie, piąta – stopień zaawansowania przedmiotu ustalony na podstawie roku studiów, dla którego przedmiot jest przeznaczony. / (0311) Economics The ISCED (International Standard Classification of Education) code has been designed by UNESCO.
Course title: Advanced Excel – VBA Programming II
Name in Polish: Excel dla zaawansowanych- programowanie w VBA cz. 2
Organizational unit: Faculty of Economic Sciences
Course groups: General university courses
General university courses in Faculty of Economics
General university courses in the social sciences
On-line general university courses
ECTS credit allocation (and other scores): 3.00 Basic information on ECTS credits allocation principles:
  • the annual hourly workload of the student’s work required to achieve the expected learning outcomes for a given stage is 1500-1800h, corresponding to 60 ECTS;
  • the student’s weekly hourly workload is 45 h;
  • 1 ECTS point corresponds to 25-30 hours of student work needed to achieve the assumed learning outcomes;
  • weekly student workload necessary to achieve the assumed learning outcomes allows to obtain 1.5 ECTS;
  • work required to pass the course, which has been assigned 3 ECTS, constitutes 10% of the semester student load.
view allocation of credits
Language: Polish
Type of course:

general courses
Prerequisites (description):

(in Polish) Naturalnymi kandydatami są osoby, które ukończyły kurs pt. "Excel dla zaawansowanych – programowanie w VBA cz.1”.
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.

Classes are held in the form of e-learning on the platform: https://moodle.wne.uw.edu.pl (no live classes).
Full description:

Detailed list of topics:

Part 1 (effective work in VBA):

• array variables;

• Sub procedures;

• Function procedure;

• advanced pivot tables;

• advanced charts.

Part 2 (user interface):

• events;

• shapes, form controls and Active X controls;

• built-in dialog boxes, UserForms;

• advanced UserForm.

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 2011,

- 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:

• Finale project (100 pts.): a cumulative homework.

• Questions and answers on the Discussion Forums: maximum 3 points for each post.

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
Selected timetable range:
Navigate to timetable
Type of class:
E-learning course, 30 hours, 25 places more information
Coordinators: Przemysław Kusztelak
Group instructors: Przemysław Kusztelak
Students list: (inaccessible to you)
Examination: Course - Grading
E-learning course - Grading
Course descriptions are protected by copyright.
Copyright by University of Warsaw.
Krakowskie Przedmieście 26/28
00-927 Warszawa tel: +48 22 55 20 000 https://uw.edu.pl/ contact accessibility statement USOSweb 7.0.3.0 (2024-03-22)