Everything is good. Except balance column. Balance is showing continuesly till end of the year. It suppose to be if date is entered then show the balance.
I have seen many video's for excel formulas but only 1st time I enjoyed, I learned completely, very understanding, and successful I made daybook.......thanks 👍😁
Thank you for your amazing video. It was very helpful. I am facing some peculiar problems: 1. While typing a formula, you have used comma, for example: =IF([@Date]="","",text([@Date];"ddd")) But here in my excel, if I use comma, the formula does not use. Afterwards I found that I need to use semicolon (;). Don't know why I am having this problem. 2. While going from Date to Day, I need to type (ddd), which in your video, day will appear acccording to dates. But in my case, the day does not appear, rather it is always showd ddd. If I type DDDD in the formula, it shows DDDD, whatever the date is. Could you please inform me, what the actual problem is, and how to solve these 2 issues? Thank you again :)
Great efforts, Thank you I've a question, if you answer, I'll be thankful to you. I've a list of thousand entries and I want to delete the similar entries such as amounting Rs.1,000/- I want delete all entries having amount Rs.1,000/-. What formula can be used here?
@@DeepakEduWorld it's really great I am big fan of yours. Can you make a video on chitfund society accounts maintain in Excel like:- S.No. Members name, monthly share, Total share value, Total Loan, New loan, Loan repay, Interest on Loan, Bal. Loan & Remarks. Actually I want to get any of members' full record in a single click. You can reply through make a video on this topic or nonydev@gmail.com. Thanks
Sir bhut bhut Dhyanyabad, Sir app ki video se bhut hi jyeda clarification ho jata h. Jo ki off line cochings me bhi ni mila bo muje app ki in video me dekhne aur sheekne ko mila. Thanks Sir. I am Ankit Saini
Sir I am very much glad to hear and see this video but I want to know is it possible to create in the day book one more coloum of bank, supposed we got cash and deposit into the bank then we can see the both balances. So I request to you please make the for both coloums
आभारी सर मी तुमचा व्हीडीओ डाऊनलोड करून सेम तूमच्या सारखच टेबल बनवले व मला न चुकता आले सर मला 2 तास लागले पन आता हेड बदलून मी दुसर्या कामासाठी वापरले परत एकदा आभारी आहे सर.
Good evening sir Mein ap kay vedio sa bhuot kuch seekhta hou aur chanal ko subscribe bi karta hou mujay yeh sun mail bi karo sir Mail Id subashchanderjksrlm@gmail.com
Good is been long time i learned excel but forgotten not even know how to merge the cell but now watching your video help me alot if not works I just download it and work on it thanks brother....
Ohh no 😱This is not fear muze aapki technique achha lagi but aapne last mai jo bola i really disappointed 🥺🥺because maine video start rakhale all sheets complete kr di itna efforts lagate or muze urgent chahiye thi agar aap pehle bata dete starting mai aap ye template on mail de doge to mere ko jaldi mil jata Koi ni but sir it's really helpful for me thank you so much and keeping it up sir 😊😊😊
Seriously Great Work.... Thank you Mr. Deepak. Personally I learn a lot from your Videos .I Have already subscribed your channel. love from PAKISTAN. Be Blessed.
Bhai aap itna achha containt banate hai aap se ek request hai hum jaise kuchh bank BC jo kai tarah se multiple accounts ka use karte unke liye day book banane ka sahi tarika bataye bahut meharbani hogi
*Download Day Book Templete* : deepakeduworld.com/day-book-in-excel/
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* th-cam.com/video/Xkq0-xXAj48/w-d-xo.html
*Complete Powerpoint Tutorial :* th-cam.com/video/OekrBhNybP0/w-d-xo.html
*Xlookup Complete Tutorial :* th-cam.com/video/0LjfRVD7srU/w-d-xo.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* th-cam.com/video/C9y53fedo04/w-d-xo.html
amanmalhi38@gmail.com
Please send me this formula this mail
Scnawal@gmail.com
Sir 4 entry se jyda ku ni l rha hai
Hello sir... mai aapke sare videos dekhta hun... please send me day book on me mail id
upadhayay.sandeep@gmail.com
kya is cash book se ledger ban skta hai
Great Teacher...you made me excel very comfortable...🙏🙏
Peace upon you and your family Deepak, you are creating everyone expert in their businesses thank you
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
Your too good.....just love the way you explain in detail. Very simple ,clear and easy to understand 💯
मैं भी दीपक कुमार हूँ (आनंद बोधि) देने से ही रोशनी का आनंद का बोध होता है । धन्यबाद
Thanks you sir... Really best lesson.... Wish you all the best for new trick and trips....
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
Sir love you 💞💝🎁🎁💚💜💜💙💕✨👍👍👍👍👍
Wow! Amazing, having watched your videos I am feeling very comfortable in excel .thanks sir
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
Bhut hi accha video hai Thanks 10 saal pahle sikha tha but aaj sab kaam a raha hai thanks bhai
Great work Deepak ji keep going something new today
😊🤗🤗
Sir ye
Aijazali962@gmail.com
Aijazali962@gmail.com
Sir ye email kar de geian mujhy chahe
That was really useful dear. Thank you for your effort. I am grateful to you.
😊😊😊😊
explain the formula
Vishvanath.buxar@gmail.com
Sir tabl send kardijiye
Hi I am amir from Pakistan , can I send me this file. On amirstudioo@gmail.com
Everything is good. Except balance column. Balance is showing continuesly till end of the year. It suppose to be if date is entered then show the balance.
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
It is beneficial
I have seen many video's for excel formulas but only 1st time I enjoyed, I learned completely, very understanding, and successful I made daybook.......thanks 👍😁
That was really good job, Thanks a lot
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
Thank you for your amazing video. It was very helpful. I am facing some peculiar problems:
1. While typing a formula, you have used comma, for example: =IF([@Date]="","",text([@Date];"ddd"))
But here in my excel, if I use comma, the formula does not use. Afterwards I found that I need to use semicolon (;). Don't know why I am having this problem.
2. While going from Date to Day, I need to type (ddd), which in your video, day will appear acccording to dates. But in my case, the day does not appear, rather it is always showd ddd. If I type DDDD in the formula, it shows DDDD, whatever the date is. Could you please inform me, what the actual problem is, and how to solve these 2 issues? Thank you again :)
Thank u sir
Yeah same issue ...How did you solved it ?
Thanks
Great efforts, Thank you
I've a question, if you answer, I'll be thankful to you.
I've a list of thousand entries and I want to delete the similar entries such as amounting Rs.1,000/-
I want delete all entries having amount Rs.1,000/-.
What formula can be used here?
Filter all data having value 1000... Delete the filtered data ( rows ).. . After that.. clear filter👍👍👍👍
Good, I tried it, once I done and second time I couldn't.
But afterwards I do as it,
Thank you for your reply and your time.
I liked your way of work and sincerety.
@@DeepakEduWorld it's really great I am big fan of yours. Can you make a video on chitfund society accounts maintain in Excel like:- S.No. Members name, monthly share, Total share value, Total Loan, New loan, Loan repay, Interest on Loan, Bal. Loan & Remarks.
Actually I want to get any of members' full record in a single click. You can reply through make a video on this topic or nonydev@gmail.com.
Thanks
Sir bhut bhut Dhyanyabad,
Sir app ki video se bhut hi jyeda clarification ho jata h. Jo ki off line cochings me bhi ni mila bo muje app ki in video me dekhne aur sheekne ko mila.
Thanks Sir.
I am Ankit Saini
Sir I am very much glad to hear and see this video but I want to know is it possible to create in the day book one more coloum of bank, supposed we got cash and deposit into the bank then we can see the both balances. So I request to you please make the for both coloums
In next day book video... 👍 As soon as possible i ll publish video
@@DeepakEduWorld I also appreciate Abdul bhai to know more about bank transactions ! Thanks !
Deepakji!!! How to add Opening Balance on Dt.01-04-2019 in this format plz reply sirji
Add it in reciepts
Simply add opening Bal in some date that will be counted as entry of a date.
आभारी सर मी तुमचा व्हीडीओ डाऊनलोड करून सेम तूमच्या सारखच टेबल बनवले व मला न चुकता आले सर मला 2 तास लागले पन आता हेड बदलून मी दुसर्या कामासाठी वापरले परत एकदा आभारी आहे सर.
Hi,
If i want to get total monthly income, in the sense if i give "may" i should get may month Balance
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
But. If vendor payment fails then how to make a debit note
Did get the answer
Individual Expenses or Income ledger - how we can get?
I ll Publish video as soon as possible 👍
@@DeepakEduWorld sand me please azharpk45@gmail.com
Sir mujjy ye format ap mail kr skaty hain plz
Deepak ji your are telling is simple language and easily understand. Thankyou
When I click double click at date, the dates aren't coming for the remaining 365 days
double click on the right bottom corner of cell where you can see small size box
It was nice...I got lots of knowledge about day book. And it helped a lot. But I need it in my mail...
prafullparhi@gmal.com
mizanurrufinance@gmail.com
It's was nice. I got lost of knowledge about daybook .And it helped a lot.But I need it in my mail...
habibkhan15896@gmail.com
9252592158
🙏🙏🙏🙏सर जी नमस्ते आपसे एक चीज पूछनी थी आपने जो सेल इनवॉइस बनाए थे यूट्यूब पर मैने उसको डाउनलोड किया और उसमे काम करके देखा उसमे एक चीज नहीं हो पा रही है
Kay nahi ho paraha hain
Good evening sir
Mein ap kay vedio sa bhuot kuch seekhta hou aur chanal ko subscribe bi karta hou mujay yeh sun mail bi karo sir
Mail Id
subashchanderjksrlm@gmail.com
kehars824@gmail.com
Mujhe formula chahiye sir ji
sks754939@gmail.com
बहोत बढीया सरजी मुझे सिखनेकु आसान हो गया आपका व्हिडीओ देखके thanks sir
Very use sir me 2 hour ur video seeing and iam work sheet banaaya thank u bro
You have the best video among all the videos related to excel
Thanks this daybook excel sheet is really helpful...Thanks again Sir....👍👍🤷♂🤷♂😊😊😊😊 i am very happy..
Thank You Sir..👍👍
this kind is very very very helpful for me i am also searching over one year butt now i reach my right way.. thanks
amazing bro.. seriously amazing.... itna bhtt ek ek normal shopkeeper ko apna account rkhne k liye
Good is been long time i learned excel but forgotten not even know how to merge the cell but now watching your video help me alot if not works I just download it and work on it thanks brother....
Ohh no 😱This is not fear muze aapki technique achha lagi but aapne last mai jo bola i really disappointed 🥺🥺because maine video start rakhale all sheets complete kr di itna efforts lagate or muze urgent chahiye thi agar aap pehle bata dete starting mai aap ye template on mail de doge to mere ko jaldi mil jata
Koi ni but sir it's really helpful for me thank you so much and keeping it up sir 😊😊😊
Aapke samjhne ka tarika bahut aaccha hai sir ji....nice video
Very good I Understand Very good
Thank U sir
God Bless u
Vivaan
From Mumbai
superb bro thanks for supporting all peoples for business
Thank you very much to help us and wish be happy always and be successful always
Really you are the best one father of excel .
Very Nice and Useful video...
Thanks Sir
Very Helpful Video
Mind blowing class.
thank you so much sir. app all dowlod ka optin de rakha he..upoer wala apko or vi accha noleze de
Thank u so much for taught us this easy and excellent method.🙏
your teaching method is too good Thanks sharing your knowledge
Respect and thank you so much from PAKISTAN
Dear Deepak
Really you have done a wonderful job.
Great work sir 🙏🏻🙏🏻🙏🏻
Love from Kanpur 😘😘
Apka content bahut hi helpful hai
Deepak Thanks a lot for informative video
Sir Bahot achese samjhaya... Thank you.😊
I find this excel calculation is very useful for the business people, like me, to keep on record in a simple manner to understand. Thank you.
Thank you sir, this is Mahesh T S from Bangalore,
आप का बहुत बहुत धन्यवाद जी
that's really helpful for beginner like me thanks a lot
👍 👍 👍 very helpfull video..
This is helpfull for daily personal Expenditure.. Account
Deepak sir, aap ke har video interesting hote hai.
Isi video ko VBA Excel me bhi banaiye.
Thanks...
So Good. Thank you From @Bangladesh
Very nice education given by you regarding daybook......Thanks
Seriously Great Work.... Thank you Mr. Deepak. Personally I learn a lot from your Videos .I Have already subscribed your channel. love from PAKISTAN. Be Blessed.
Very nice sir ...good explanation
Wah puri dekhi baad me mene banai sheet
Vow! Excellent tech teaching
❤❤ thanks a lot brother
I really appreciate you 👍
With the help of, you made my work easy
Wonderful Presentation and Work done by my brother. Thanks
such a interesting and helpful video you worked really hard should deserves 10 million subscribers
nice explaination superb.
Sir I'm very impressed for your this video
And i get lot of knowledge about this video
Hello Sir, Thank you very much. You have taught me so stepby step. My God Bless you and keep going sir, I liked it.
Very Informative video Sir ❣️❣️
Thank you so much love from Pakistan
thanks deepak ji , its very helpfull for us
Form are very difficult complex. Thank you very much helping us.
Am very grateful to your tutorial you have helped me to create my own daybook for my business . I salute you
Fantastic explanation, very impressive and very slowly beautifully narrated thanks a lot sir
Very nice and useful video.
Ur teaching experience is very good... Helpful video for business.. Great work
Bhai aap itna achha containt banate hai aap se ek request hai hum jaise kuchh bank BC jo kai tarah se multiple accounts ka use karte unke liye day book banane ka sahi tarika bataye bahut meharbani hogi
Suprbb bro... U hve solved my problem thanx a lot
Informative and useful video deepak sir
Simple and good explanation for easy understanding.
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
Thank You Bro Have a Good Day ✌😊
Watching from nepal🤗❤
Very use full video🎥
Good maja aa gaya sir
EXCELLENT CLASS SIR
Thank you brother. May God bless you!
Thank you very much sir salute h aapko
❤❤ Se
Great job brother. I hope this will help me in my business.
Sir zabardast the way u teach superb. Impressive detail sir zabardast
The More I watch the more I learn. Just Excellent May God Bless You My Dear Boss/ Dada.
🤗🤗🙂🙂
Sir send me hum ek apna coaching institute chalaate students ki fees EMI m dete haai use remind or fees kaise maintain kare akkverma18@gmail.com
Nice video sir 😮😮😊😊😊
Thanks a lot of Assam sir
Thanks a lot Mr.Deepak
I can understand easily thank you.
Thank you sir for your information 🙂
Very Helpful Video !!! Thank YOu !!
VERY VERY HELPFUL THANKS SIR
very good ur tutorial
Really a good lesson, thanks