Project Cost &Schedule Analysis(Mock)
IExcel workbook to track project billing, consultant performance, and service timelines using advanced formulas (SUM, IF, NOW, AVERAGE, MIN, MAX), conditional formatting, and chart customization.
Sales and Dividend Mock Report
project involved creating a comprehensive sales report for Raybridge Recruiting. The goal was to analyze sales performance, visualize trends, calculate dividends, and forecast estimates for the second half of the year using advanced Excel tools.
Inventory Management Dashboard
developed a mock inventory tracking system in Excel to simulate how warehouse stock and bin locations can be organized and monitored. This project was designed as a proof of concept — showcasing how Excel can be used to build functional tools for inventory management, restocking alerts, and real-time value tracking. System includes :
A Bin List to manage storage locations and size classification.
A Inventory Sheet
Flags low stock with a “Reorder” label
Calculates inventory value per item and total value
Includes summary stats like average, minimum, and maximum costs