Economic data analysis in MS Excel with VBA

nieobowiązkowe

This is e-learning course, conducted on educational platform https://moodle.wne.uw.edu.pl.

Macros in VBA allow you to automate most of the daily activities performed in Excel (as well as in other MS Office programs), thanks to which our work becomes more efficient and error-free. VBA courses follow the motto "do not waste your precious time on routine, repeated daily activities". It is better to create an application that will automatically import data from the Internet to a spreadsheet, prepare a graphical and statistical report, and then print the results or send them by e-mail to the Supervisor / Client, than to perform the same activities repeatedly. The possibilities of the VBA language are enormous, and their use is really only limited by human imagination.

This course is dedicated to people who want to learn the world of macro commands and those who know the basics of the VBA programming language and want to systematize and deepen their knowledge. There are no IT skills prerequisites, but very good knowledge of Excel is required. The aim of the Work Automation in MS Excel using VBA language course is to automate everyday work in Excel using macro commands. The entire course is devoted to learning the Visual Basic for Applications (VBA) programming language.

Detailed subject of the course:

1. Introduction to VBA

2. VBA objects

3. Functions and formulas in VBA

4. Conditional statements

5. VBA loops

6. File operations

Note 1: the course is part of the educational path "Economic data analysis in Microsoft Excel and the VBA programming language", upon completion of which participants receive a certificate. Details on the WNE UW website (Student> Educational Paths).

Note 2: classes are held in the form of e-learning (full class materials with solutions and pre-prepared instructional videos explaining the issues discussed - no live classes) on the platform: https://moodle.wne.uw.edu.pl.

Note 3: materials are published once a week in blocks of 5 teaching hours. The course ends in December.

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 devoted to programming in VBA.

Note 5: The software version in the course is Microsoft Office 2021 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.

own materials

The student will acquire the ability to automate work in MS Excel with Visual Basic for Applications (VBA) programming language. Subject matter consistes of the following: introduction to VBA, recording macros, editing code, its’ structure and optimization, defining variables: numeric, text, array, objective, constructions: With … End With, For Each … Next, conditional statements: If…Then…Else, Select Case, loops: Do While… Loop, Do Until… Loop, For… Next, instruction: GoTo, dialog boxes: MsgBox and InputBox. You will be able to automate e.g. importing data from many files, creating consolidated databases, dynamically setting ranges, editing and formatting ranges as well as whole worksheets, preparing periodic sales reports, printing selected ranges and exporting results to separate Excel and PDF files.

The final grade consists of:

• collective homework (in the form of a final project)

• additional activity in discussion forums

Punctation:

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!