दोस्तों एक्सेल में बिल्कुल आसान और सिंपल ऑटोमेटेड एक्सपेंस ट्रैकर ( Automated Expense Tracker ) कैसे बनाएं । जिसमें हम पर्सनल बिजनेस या कंपनी के एक्सपेंस आसानी से मेंटेन कर पाए । अगर आपका यही सवाल है तो आपने बिल्कुल सही पोस्ट पर क्लिक किया है ।
Expense Tracker in Excel
तो यह इंप्रेसिव सा Automated Expense Tracker एक्सेल में मैंने बना दिया है जिसके लिए किसी एडवांस स्किल की जरूरत नहीं है । और ना ही इसमें हमने कोई Vba कोड यूज़ किया है So कोई भी एक्सेल बिगनर यह एक्सपेंस ट्रैकर बड़ी आसानी से बना सकता है नीचे इमेज में आप इसका प्रीव्यू देख सकते हैं ।
इस एक्सपेंस ट्रैकर को बनाने के लिए हमने 2 Sheet ली है एक सीट पर हम एक्सपेंसेस की एंट्रीज करते रहेंगे और दूसरी सीट पर एक्सपेंस ट्रैकर अपना काम ऑटोमेटिक करता रहेगा । इस एक्सपेंस ट्रैकर को बनाने का पूरा प्रोसेस वीडियो में स्टेप बाय स्टेप बताया गया है So अगर आप यह एक्सपेंस ट्रैकर बनाना सीखना चाहते हैं तो नीचे वीडियो दिया है आप वीडियो देख लीजिए । और यह एक्सपेंस ट्रैकर टेंप्लेट डाउनलोड करने के लिए नीचे डाउनलोड टेंप्लेट बटन पर क्लिक कीजिए
Expense Tracker Video Tutorial
Formula Used
इस एक्सपेंस ट्रैकर में हमने 2 डेट्स के बीच में अमाउंट का सम करने के लिए SUMIFS फार्मूला यूज़ किया है So अगर आपको फार्मूला नहीं आता तो आप यहां से Sumifs Excel Formula फार्मूला सीख सकते हैं इसके अलावा इसमें कोई फार्मूला यूज़ नहीं किया गया है बस Icons एंड Shapes का यूज करके थोड़ा सा स्मार्ट वर्क किया गया है
इसके अलावा आप यह पोस्ट भी एक बार जरूर पढ़ें
एक्सेल में Invoice And Inventory Management In Excel के लिए यह पोस्ट पढ़ें
एक्सेल में Fully Automated DATA ENTRY Software In Excel – Data Entry User Form के लिए यह पोस्ट पढ़ें
QUICK AND WORTHY VIDEOS AND EXPLAINATION
THANKS ALOT DEEPAK
Can u help me in making a tracker for Inhoud and outbound Logo ativ
Regards
Navin
navinmudgil@gmail.com
You made a number of good points there. I did a search on the topic and found mainly people will agree with your blog.
i need attendance sheet full automatic can u send it
I need daily updates, day book sheet full automatic can u send it
Reply
I absolutely love your blog and find a lot of your post’s to be just what I’m looking for. can you offer guest writers to write content available for you? I wouldn’t mind publishing a post or elaborating on many of the subjects you write in relation to here. Again, awesome web site!
I too conceive therefore, perfectly composed post! .
I like the efforts you have put in this, thanks for all the great content.
I was just searching for this info for a while. After 6 hours of continuous Googleing, finally I got it in your web site. I wonder what is the lack of Google strategy that do not rank this kind of informative websites in top of the list. Generally the top websites are full of garbage.
Hey There. I found your blog the use of msn. That is a really smartly written article. I’ll be sure to bookmark it and return to read extra of your useful info. Thank you for the post. I’ll definitely comeback.
Pretty! This was a really wonderful post. Thank you for your provided information.
Great work! This is the type of info that are meant to be shared across the net. Disgrace on the seek engines for not positioning this post higher! Come on over and talk over with my web site . Thanks =)
impressed
Imressed. stay blessed and keep impressing us. thanks
लिखने के लिये
I have been reading out some of your posts and it’s pretty good stuff. I will definitely bookmark your website.
Howdy! This post could not be written any better! Reading through this post reminds me of my old room mate! He always kept talking about this. I will forward this post to him. Pretty sure he will have a good read. Many thanks for sharing!
I learned a lot, and now I’m curious about what else you could teach me. The intelligence is as captivating as The prose.
What a refreshing take on this subject. I completely agree with The points!
Your writing is powerful and uplifting — fantastic job!
This post is absolutely glowing with passion!
You always deliver top-tier writing.
This gave me such a boost of motivation — thank you!
Wow, this article was incredibly well put together. Great job!
I can’t believe how much I loved this — fantastic job!
I genuinely learned something new today. Fantastic post!
Your enthusiasm transforms every topic — incredible writing!
This is one of the best explanations I’ve come across on this topic.
Just WOW. This exceeded every expectation!
Your blog is becoming one of my favorite places to learn!
I’m honestly amazed at how fun this was to read!
This is insanely good — bookmarking immediately!
You consistently create content that stands out.
Your writing is pure inspiration — so beautifully enthusiastic!
You communicate ideas better than almost anyone else I follow.
You always leave readers better informed — thank you!
You’ve made this topic far more approachable.
I learned so much from this one article.
I’m walking away energized — thank you for this amazing content!
This is the kind of post that sticks with you — amazing!
The quality of your writing is outstanding.
You’ve mastered enthusiastic writing — seriously brilliant!
I feel smarter after reading this — seriously great content.
You’ve got serious talent — this is spectacular!
I love how clear and comprehensive your posts are.
This post delivered SO MUCH VALUE — incredible!
Absolutely stellar writing — I’m blown away!
You communicate ideas with so much ease and clarity.
Your enthusiasm transforms every topic — incredible writing!
I can’t praise this enough — outstanding work!
You’re bringing big, amazing energy — keep it up!
finish because the clarity, structure, and passion in your writing
This is very interesting, You are a very skilled blogger.
I’ve joined your feed and look forward to seeking more
of your fantastic post. Also, I’ve shared your web site in my social networks!
Your passion makes every paragraph shine — beautiful work!
I always look forward to your next article.
I’m so glad I found this — what an exciting read!
Your ability to explain things is truly impressive.
This was such an energizing read — loved it!
I’m consistently impressed by the quality of your work.
Your blog is truly becoming a go-to resource.
This post shines with passion and energy — fantastic!
Your energy is a breath of fresh air — fantastic post!
This was such an enlightening read — thank you for sharing your expertise!
Hands down one of the best things I’ve read all week!
You’ve articulated this topic better than anyone else.
I genuinely learned something new today. Fantastic post!
I appreciate the depth and thoughtfulness in this post.
Your vibrant approach is absolutely refreshing — great work!
How are you?
This post absolutely SPARKLES with enthusiasm!
This content shines so brightly — incredible effort!
This was so enjoyable to read. Thank you for sharing it!
Your content is always a breath of fresh air.
Your writing never fails to impress me.
You’ve got a gift — this is stellar!
This post is overflowing with high-energy brilliance!
You’ve beautifully expressed ideas many struggle to articulate.
This article brought so much clarity to the topic.
Your passion brings this content to life — excellent work!
This is exactly the kind of excitement I love to read!
I appreciate the positive energy you bring to your posts.
This post gave me exactly the clarity I needed. Thank you!
I always look forward to your next article.
You have an incredible ability to inspire and excite!
This article bursts with life and inspiration — beautiful!
You always bring a unique and valuable perspective.
What a wonderfully written and informative post.
You always deliver such valuable information — thank you!
Your enthusiasm makes learning fun — brilliant job!
This post is a perfect example of quality content.
This is one of the most exciting posts I’ve read in a long time!
I’m honestly speechless — this is THAT good!
You consistently offer such high-quality information.
Your writing is polished, thoughtful, and impactful.
Your enthusiasm is magnetic — I love it!
Such an uplifting and electrifying read!
You make complicated concepts feel effortless.
A really good blog and me back again.
Your blog consistently impresses me. Great work!