اکسل: تحلیل دادههای مالی
ساخت مدلی مالی در سطح تراکنش برای بررسی الگوی هزینه، جریان نقد و عملکرد مالی.
متن کامل این یادداشت فعلاً به زبان اصلی، انگلیسی، در دسترس است.
I built this project as a small transaction-level financial model in Excel. The workbook starts with a structured transaction table and turns it into a financial summary covering income, expenses, net balance, spending by category, transaction counts, average expense, and the largest expense. The goal was to practice moving from raw financial data to calculations and then to a clearer view of financial performance.
The project also gave me a chance to practice Excel formulas in a real, connected model rather than as isolated exercises. The summary calculations use criteria-based functions and lookups against the transaction table, while charts make some of the results easier to interpret.