Inf_lab_zaj_11 Konrad Kotulski.xlsx – Fresh & Deluxe

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

Used SUMIFS and COUNTIFS to extract specific metrics from the master data sheet.

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. INF_LAB_ZAJ_11 Konrad Kotulski.xlsx

Konrad Kotulski Topic: Advanced Data Processing and Analysis in MS Excel 1. Objective of the Lab

Implemented VLOOKUP / XLOOKUP and nested IF statements to categorize data automatically. Organized raw input data, handled missing values, and

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

Developed [Macros/VBA scripts] to streamline repetitive calculation tasks. 3. Methodology & Solutions Objective of the Lab Implemented VLOOKUP / XLOOKUP

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