Efe Dogan's Work | ContraWork by Efe DoganEfe Dogan
Excel automation, VBA macros and dashboards
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: cleaning a messy customer export in Excel with formulas only. Names, emails, mixed date formats, cities and US or European amounts are standardized, duplicates and rows needing review are flagged. 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.