Logistics Monitoring Report

Created and maintained a comprehensive Logistics Monitoring Report to track the flow and usage of goods across departments, serving as a critical tool in planning the annual logistics budget. Leveraged Microsoft Excel with VBA macros to develop a simple yet effective input form that streamlined the recording of inbound and outbound goods. This automation reduced manual errors, improved data consistency, and enhanced visibility for decision-makers. The tool significantly contributed to more accurate forecasting and efficient inventory planning.

Employee Attendance Tracker

This template is designed to automatically calculate employee attendance based on their daily shift input. Key features include:

1. Auto-counting total days present, leave, sick days, permission (izin), and late arrivals.

2. Auto-highlighting weekends and public holidays using conditional formatting — making non-working days instantly visible.

3. Dynamic month selector: easily change the working month through a dropdown, and all dates, weekdays, and highlights adjust automatically.

This tool helps administrative teams save time on manual tracking, improves accuracy in monthly reporting, and adds clarity through its clean visual indicators.

Excel Training Module – Pivot Table

This module focused on mastering Pivot Tables, one of Excel’s most powerful data analysis tools. Participants learned how to summarize, categorize, and interpret large sets of data efficiently. The training covered:

1. How to create and customize Pivot Tables

2. Sorting and filtering data within Pivot Tables

3. Grouping data (by dates, categories, etc.)

4. Using calculated fields

5. Best practices for real-time data reporting

By the end of this session, participants were able to transform raw data into dynamic reports, gaining insights that support better decision-making in administrative and operational tasks.

Excel Training Module – Logical Functions

This module focused on building strong logical reasoning in Excel through powerful conditional formulas that automate decision-making processes in spreadsheets. Covered topics included:

1. IF Function

2. Nested IF

3. IF AND / IF OR / IF NOT

4. IFERROR

5. COUNTIF / SUMIF / AVERAGEIF

Through interactive exercises and applied examples, participants learned how to write efficient formulas, reduce repetitive tasks, and increase the accuracy of data analysis in administrative and reporting work.