Effective data analysis in MS Excel (elearning course) 2400-ZEWW846-OG
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.
Course coordinators
Type of course
Learning outcomes
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.
Assessment criteria
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!
Bibliography
own materials