Track Income, Expenses & Savings in Excel | Excel से बनाएं अपना Personal Expense & Income Tracker

इस वीडियो में आप सीखेंगे कि कैसे Excel की मदद से एक fully automated Personal Expense & Income Tracker बनाया जाता है।

इसमें दो शीट हैं –
1⃣ Transactions – जहाँ आप अपने Income और Expenses की entry करेंगे।
2⃣ Dashboard – जो आपकी entries के आधार पर Month-wise Income, Expenses और Savings को automatically दिखाएगा।

Main Highlights:

Simple functions से बनाया गया है (कोई complex formula या VBA नहीं)

Dashboard auto-updated है, manual update की जरूरत नहीं

Excel के लगभग सभी versions में काम करेगा

YTD Income, Expenses और Savings की summary भी दिखाई गई है

Income & Expenses category-wise भी visualize होंगे

यह tracker आपके personal budget management को easy और professional बना देगा।

वीडियो अच्छा लगे तो Like, Share और Channel को Subscribe जरूर करें!
नीचे Comment करके बताएं आपको कैसा लगा और कौन-सा टॉपिक आप आगे देखना चाहते हैं।

#ExcelTracker #IncomeExpenseTracker #PersonalFinanceInExcel #ExcelDashboard #PowerExByJitendra

For more videos please subscribe our channel:
https://youtube.com/c/PowerExbyJitendra

Free Practice File:
==============================
https://bit.ly/3Zi4zdJ
==============================
Links of some improtant videos:
https://youtu.be/a2xUK6jLIPY
https://youtu.be/tP5MdZojMOg
https://youtu.be/oAkbqLB2YLw

Playlists of our top videos:
1. Stock Management System in Excel
https://youtube.com/playlist?list=PLBy4kMPmMt7QWl0YvOQumw4A730f36qAV

2. Advanced Excel Formulas
https://youtube.com/playlist?list=PLBy4kMPmMt7TI0y3zNNVYqc-y0JfFjwgg

3. Awesome MS Word Videos
https://youtube.com/playlist?list=PLBy4kMPmMt7SYFXHhY2tWTSL3uYG5dRG-

4. Conditional Formatting in Excel
https://youtube.com/playlist?list=PLBy4kMPmMt7Q8udcHSUO4va9eE_mL1aBL

5. Data Entry Form
https://youtube.com/playlist?list=PLBy4kMPmMt7TyCiEa2z_j2Hh3pCJrARjT

6. Custom Number Formatting Tricks
https://youtube.com/playlist?list=PLBy4kMPmMt7TJknWcSfKA17oiaRZDnI0H

7. Recent Uploads
https://youtube.com/playlist?list=PLBy4kMPmMt7RIG4EhjmidQOsB5uuLX5QF

8. Best Excel Shortcut Keys
https://youtube.com/playlist?list=PLBy4kMPmMt7Qpqc7rr8GrRYj70_m5Lulm

9. Power Query Tutorials
https://youtube.com/playlist?list=PLBy4kMPmMt7Qp0F_gR5GLLYD5jBoNjv3b

10. MIS Report in Excel
https://youtube.com/playlist?list=PLBy4kMPmMt7TTHMnzfqIP5vWeLKpK5nOY

11. Excel PivotTable
https://www.youtube.com/playlist?list=PLBy4kMPmMt7SM15JjjcmlXBBQiGKftLrw

12. Task Tracker or To-Do List
https://www.youtube.com/playlist?list=PLBy4kMPmMt7RpxCvzNPcP7APowZZWa_qG

13. Excel for Accounting
https://www.youtube.com/playlist?list=PLBy4kMPmMt7TZmLrSrx3k8KBznKQ62a1c

14. Excel Lookup Functions
https://www.youtube.com/playlist?list=PLBy4kMPmMt7TT2Xp7Jjs1hb3KxzK4dIWV

15. Filter
https://www.youtube.com/playlist?list=PLBy4kMPmMt7SZmCx_0w9qmO2t86gdeV8K
-------------------------------------------------------------------
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.

Subscribe on Telegram:
https://t.me/powerexbyjitendra

Contact Us:
Instagram: https://instagram.com/kumarjitendra11?igshid=zd7v216sfxr7

Facebook : https://www.facebook.com/PowerEx-by-Jitendra-108422660912839/

Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.

Fair use is a permitted by copyright statute that might otherwise be infringing.

Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks