Excel Gelir Gider Tablosu New May 2026

The traditional income-expense sheet was simple: Column A for dates, Column B for descriptions, Column C for income, and Column D for expenses. Then came the formula =SUM(C:C)-SUM(D:D) at the bottom. It worked, but it was fragile. You had to manually extend ranges, check for double entries, and create separate pivot tables for reports.

The "New" Excel Gelir Gider Tablosu solves these problems using modern features available in Excel 365 and Excel 2024. excel gelir gider tablosu new

Use the "new" visual rules to spot problems instantly: The traditional income-expense sheet was simple: Column A

| Eski Hata | Yeni Çözüm | |-----------|-------------| | Toplamlar için =TOPLA(A:A) kullanmak | Akıllı Tablo yapısında =TOPLA(Tablo1[Gelir]) | | Ayları manuel yazmak | METNEÇEVİR(Tarih;"aaaa-aa") ile otomatik ay etiketi | | Gider türlerini karıştırmak | Veri doğrulama + AÇILIR LİSTE | | Grafiklerin veri aralığını unutmak | Grafik kaynağını =DOLAYLI ile dinamik hale getirme | | Yedek almamak | Excel’in Otomatik Kaydet ve Sürüm Geçmişi (OneDrive) | What makes the “New” tablosu technically superior

What makes the “New” tablosu technically superior?

| Classic Excel | New Excel Gelir Gider Tablosu | |---------------|--------------------------------| | =SUM(B2:B100) | =SUM(FILTER(Table1[Tutar], Table1[Kategori]=”Gıda”)) | | Static charts | Dynamic arrays + Sparklines | | Manual exchange rates | Live =STOCKHISTORY(“USD/TRY”) | | No error handling | =IFERROR(VLOOKUP(...), “Yeni Kategori”) | | Single sheet | Modular workbook: Dashboard, Data, Import, Settings, Reports |

The new version also uses Excel Tables (LISTOBJECT) instead of raw ranges. This means formulas are self-expanding and structured references are readable: =[@Tutar]*[@Kur] instead of =C2*F2.