Monthly Shift Scheduling & Spreadsheet Audit
Developed and reviewed a monthly employee shift schedule using spreadsheets for real retail pharmacy operations.
The project involved:
Organizing morning and evening shifts based on staffing requirements.
Balancing shift assignments fairly among employees.
Managing planned leave days and individual scheduling preferences.
Checking daily staffing coverage to maintain operational continuity.
Identifying and avoiding exhausting three-day shift patterns, such as morning–evening–morning and evening–morning–evening.
Auditing the final schedule for shift totals, leave allocation, and scheduling conflicts.
Tools: Microsoft Excel, Spreadsheet Analysis, Workforce Scheduling.
Real project. Portfolio preview reconstructed using anonymized example data to protect employee information.
0
49
Google Forms & Sheets Cashbook Automation
Developed an automated cashbook system using Google Forms, Google Sheets, and Google Apps Script to simplify financial transaction recording.
The project involved:
Creating a Google Form for recording income and expenses.
Automatically transferring form submissions into a structured transaction ledger.
Implementing automatic date and time recording with optional manual overrides.
Organizing transaction categories, amounts, and payment sources.
Generating financial summaries to monitor income, expenses, and balances.
Supporting continuous cash balance tracking across reporting periods.
Tools: Google Forms, Google Sheets, Google Apps Script.
Real project. Portfolio preview reconstructed using anonymized example data to protect private financial information.
0
51
Inventory & Purchase Order Reconciliation
Developed an Excel-based inventory and purchasing workbook for real retail pharmacy operations.
The project involved:
Consolidating inventory, sales, purchase order, and receiving data.
Matching product records using SKU codes.
Tracking purchase orders and identifying outstanding or partially received quantities.
Performing stock reconciliation and identifying discrepancies.
Supporting purchasing decisions through sales trends, stock levels, and Pareto analysis.
Tools: Microsoft Excel, Data Cleaning, Data Reconciliation, Inventory Analysis.
Real project. Portfolio preview reconstructed using anonymized example data to protect confidential business information.
0
64
Excel Data Cleaning — Before & After
A demonstration of how messy spreadsheet data can be transformed into clean, consistent, and organized records.
This example shows duplicate removal, standardized date formats, consistent text formatting, and improved data readability.
Sample project using fictional data for demonstration purposes.
0
64