Advanced Excel – VBA Programming I
General data
Course ID: | 2400-INTER-EXVBA-OG |
Erasmus code / ISCED: |
14.3
|
Course title: | Advanced Excel – VBA Programming I |
Name in Polish: | Excel dla zaawansowanych- programowanie w VBA cz.1 |
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
|
Language: | Polish |
Type of course: | general courses |
Prerequisites (description): | (in Polish) Niniejszy kurs dedykowany jest wszystkim studentom, którzy znają program MS Excel (m.in. umieją robić wykresy i formatować tabele, potrafią używać funkcji logicznych, tekstowych, czy wyszukiwania i adresu w Excelu, posługują się tabelami przestawnymi) i chcieliby nauczyć się pisania makropoleceń, czyli języka VBA. |
Short description: |
Many people every day working in the spreadsheet uses only the very basic functions of treating it as a more powerful calculator. The course aims to teach participants how they can automate your daily work in MS Excel with Macros - VBA (Visual Basic for Applications) programming. Effective use of the spreadsheet is automation our work to save time, that is wasted on routine tasks. The course applies the motto Learnig by Doing. For each classes, students have to solve a new task, designed in such a way as to preserve their existing skills and learn new subjects. Numerous application examples discussed in class which facilitates their use in their work. |
Full description: |
Detailed list of topics: • Introduction to VBA Part 1 - record macros, design and code optimization; VBE – Visual Basic Editor. • Introduction to VBA Part 2 - edit the code; objects - properties and methods; structures: With ... End With and For Each ... Next. • Functions and formulas in VBA; dialog boxes: MsgBox and InputBox. • Statement GoTo, Dir and structure If ... Then. • For ... Next loop, Do ... Until and Do ... While. • Example an application that imports data for sales reports from multiple stores to Excel, consolidates all accounts, create reports for individual product groups and stores them in separate files. Note 1: classes are held in the form of e-learning on the platform: https://elearning.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, - Jelen B., Syrstand T., Microsoft Excel 2010 PL. Język VBA i makra. Akademia Excela, Helion, - Alexander M., Walkenbach J., Excel 101 makr gotowych do użycia, Helion 2013. |
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 macros, write and edit the VBA code to customize it to your needs, including define variables, conditional statements (If ... Then ... Else), loops (Do ... Loop), instructions (For ... Next), use dialog boxes. |
Assessment methods and assessment criteria: |
The final evaluation consists of: • Homework (60 pts.): two cumulative homework each scored 30 points. • Questions and answers on the Discussion Forums: maximum 3 points for each post. Scoring: Points Mark (0-30) 2 (30-36) 3 (36-42) 3,5 (42-48) 4 (48-54) 4,5 (54-60) 5 60+ 5! |
Classes in period "Winter semester 2023/24" (past)
Time span: | 2023-10-01 - 2024-01-28 |
Navigate to timetable
MO TU W TH FR |
Type of class: |
E-learning course, 30 hours, 30 places
|
|
Coordinators: | Przemysław Kusztelak | |
Group instructors: | Przemysław Kusztelak, Adam Wawrzyniak | |
Students list: | (inaccessible to you) | |
Examination: |
Course -
Grading
E-learning course - Grading |
Copyright by University of Warsaw.