Advanced Excel – VBA Programming II 2400-INTER-EXVBA2-OG
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.
Course coordinators
Type of course
Prerequisites (description)
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 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!
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.