Used SUMIFS and COUNTIFS to extract specific metrics from the master data sheet.
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
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 INF_LAB_ZAJ_11 Konrad Kotulski.xlsx
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 .
Implemented VLOOKUP / XLOOKUP and nested IF statements to categorize data automatically. 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 . The focus was on improving efficiency through logical
Created dynamic summaries to analyze [insert what your data was about, e.g., sales, technical specs, or statistics].
