Inf_lab_zaj_11 Konrad Kotulski.xlsx May 2026

Implemented VLOOKUP / XLOOKUP and nested IF statements to categorize data automatically.

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

Used SUMIFS and COUNTIFS to extract specific metrics from the master data sheet. Implemented VLOOKUP / XLOOKUP and nested IF statements

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 . handled missing values

Organized raw input data, handled missing values, and applied conditional formatting to highlight key trends.