(in Polish) Efektywna analiza danych w programie MS Excel

optional courses

The Effective work in MS Excel training is aimed at people working in Excel and wanting to:

- systematize Excel knowledge and learn how to do your daily work more efficiently;

- learn more effective working methods (keyboard shortcuts, tools, functions, methods);

- get to know the new functions and tools of Excel 365 and see what possibilities they offer;

- deepen your knowledge of data analysis and visualization;

- learn how to create interactive dashboards;

- be able to automate analyzes created in Excel.

The course is aimed at people who are affected by at least one of the above points. Its program has been adapted to the latest trends on the market and employers' expectations, taking into account the novelties from Excel 365.

Full description of the course

(max 65.000 characters)

Detailed subject of the course:

1. Advanced PivotTables

2. Advanced search and address functions

3. Advanced functions of conditional calculations

4. Dynamic arrays

5. Conditional formatting

6. Data validation

7. Form controls

8. The use of Excel in business

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: The course requires a lot of student work and is delivered at an advanced level (prior knowledge of Excel at least intermediate level is required).

Note 3: The software version in the course is Microsoft Office 2021 or 365 (language version: Polish, operating system: Windows). It is not possible to use an earlier version (many functions are missing). The English 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 gained the ability to efficiently and effectively use MS Excel and its advanced tools and functions. The subject of the course covered the following topics: preparing data for analysis (text, search and address functions), working with databases (creating tables, dynamic references, defining dynamic ranges), data analysis (counting and conditional functions, database and table functions, advanced pivot tables), creating automatic reports (dynamic tables and Excel 365 news), creating a user interface for reports (conditional formatting, validation, form controls). The knowledge gained during the course allows for e.g. creating advanced reports and interpreting the results obtained in them.

The final grade consists of:

• collective homework

• additional activity in discussion forums

Punctation:

Points Score

[0-50) 2

[50-60) 3

[60-70) 3.5

[70-80) 4

[80-90) 4.5

[90-100) 5

from 100 5!