Inf_lab_zaj_11 Konrad Kotulski.xlsx [2024]

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

Used SUMIFS and COUNTIFS to extract specific metrics from the master data sheet. 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 Designed dashboards using Clustered Column

Developed [Macros/VBA scripts] to streamline repetitive calculation tasks. 3. Methodology & Solutions

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

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.