Sample project: crypto portfolio tracker in Excel. Holdings, average cost, unrealized and realized profit or loss and allocation are calculated from the trade history. Type current prices and everything updates. Sample data.
Sample project: monthly budget and cash flow tracker in Excel. Budget vs actual by category with automatic over-budget highlighting, savings rate, running cash balance and charts. Pick a month and everything updates. Sample data.
Sample project: Excel sales dashboard. KPIs, monthly revenue vs last year, channel split and top products, all built with SUMIFS and INDEX MATCH. Paste new sales rows and everything updates. Sample data.
Analyzed a dataset of 100 students using Microsoft Excel to evaluate revenue collection, outstanding payments, and instructor-wise performance. Created charts and a dashboard to visualize key findings and provide actionable recommendations for improving payment recovery.