- Inter-faculty Studies in Bioinformatics and Systems Biology
- Bachelor's degree, first cycle programme, Computer Science
- Bachelor's degree, first cycle programme, Mathematics
- Master's degree, second cycle programme, Bioinformatics and Systems Biology
- Master's degree, second cycle programme, Computer Science
- Master's degree, second cycle programme, Mathematics
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.
Type of course
Course coordinators
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
Additional information
Information on level of this course, year of study and semester when the course unit is delivered, types and amount of class hours - can be found in course structure diagrams of apropriate study programmes. This course is related to the following study programmes:
- Inter-faculty Studies in Bioinformatics and Systems Biology
- Bachelor's degree, first cycle programme, Computer Science
- Bachelor's degree, first cycle programme, Mathematics
- Master's degree, second cycle programme, Bioinformatics and Systems Biology
- Master's degree, second cycle programme, Computer Science
- Master's degree, second cycle programme, Mathematics
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: