Inf_lab_zaj_11 Konrad Kotulski.xlsx ❲Trusted❳

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

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

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

Developed [Macros/VBA scripts] to streamline repetitive calculation tasks. 3. Methodology & Solutions The primary goal of this exercise was to

Set up drop-down menus and input constraints to ensure data integrity.

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

Designed dashboards using Clustered Column Charts and Trend Lines to make the results interpretable at a glance. 4. Conclusions