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.
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 .
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
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
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 . Used SUMIFS and COUNTIFS to extract specific metrics
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 This lab successfully met the requirements for automated