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
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 . INF_LAB_ZAJ_11 Konrad Kotulski.xlsx
In the file INF_LAB_ZAJ_11 Konrad Kotulski.xlsx , the following tasks were performed: The primary goal of this exercise was to
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 Scope of Work Since I don't have access
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.
Set up drop-down menus and input constraints to ensure data integrity.