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 .
In the file INF_LAB_ZAJ_11 Konrad Kotulski.xlsx , the following tasks were performed: INF_LAB_ZAJ_11 Konrad Kotulski.xlsx
Set up drop-down menus and input constraints to ensure data integrity.
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. Implemented VLOOKUP / XLOOKUP and nested IF statements
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 .
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 Since I don't have access to your local
Developed [Macros/VBA scripts] to streamline repetitive calculation tasks. 3. Methodology & Solutions