Inf_lab_zaj_11 Konrad - Kotulski.xlsx
Developed [Macros/VBA scripts] to streamline repetitive calculation tasks. 3. Methodology & Solutions
Since I don't have access to your local files or the specific university portal where this spreadsheet was submitted, I cannot see the exact data inside .
Used SUMIFS and COUNTIFS to extract specific metrics from the master data sheet. INF_LAB_ZAJ_11 Konrad Kotulski.xlsx
The exercises demonstrated how advanced spreadsheet tools reduce manual error in data management. The implemented formulas allow for real-time updates—if the source data changes, the entire analysis refreshes automatically. This lab successfully met the requirements for automated data processing as outlined in the course syllabus.
Below is a professional write-up template you can adapt based on what you actually did in the file. Lab Report: INF_LAB_ZAJ_11 Used SUMIFS and COUNTIFS to extract specific metrics
Organized raw input data, handled missing values, and applied conditional formatting to highlight key trends.
However, based on common Polish university curricula for Lab 11 ( ZAJ_11 ), this lab usually covers Advanced Excel Data Analysis or Introduction to Macros/VBA . This lab successfully met the requirements for automated
The primary goal of this exercise was to utilize advanced Excel functions to automate data analysis and visualize complex datasets. The focus was on improving efficiency through logical functions, pivot tables, and [mention if you used VBA/Macros]. 2. Scope of Work