Inf_lab_zaj_11 Konrad Kotulski.xlsx Direct
Used SUMIFS and COUNTIFS to extract specific metrics from the master data sheet.
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 . INF_LAB_ZAJ_11 Konrad Kotulski.xlsx
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. handled missing values
Set up drop-down menus and input constraints to ensure data integrity.
Designed dashboards using Clustered Column Charts and Trend Lines to make the results interpretable at a glance. 4. Conclusions