How to create Day Book Report in Excel in Hindi step by step

[@DeepakEduWorld]

*Download Day Book Templete* : deepakeduworld.com/day-book-in-excel/ *My New Channel :* bit.ly/3qFrbl5 *Complete Microsoft Word Tutorial :* kzbin.info/www/bejne/jpzUYWCujaadapo *Complete Powerpoint Tutorial :* kzbin.info/www/bejne/hZbOo3Weg96VhpI *Xlookup Complete Tutorial :* kzbin.info/www/bejne/Zn3Nl4WMeZymqLc *Vlookup Complete Tutorial* : bit.ly/2K0C1Sb *Excel All Formulas :* kzbin.info/www/bejne/eWrcZmacmsmiZpY

[@knowledgejunction3246]

[e-mail] Please send me this formula this mail

[@shankarmaheshwarinawal1210]

[e-mail]

[@shashikantbanshiwal1524]

Sir 4 entry se jyda ku ni l rha hai

[@sandeepupadhyay1767]

Hello sir... mai aapke sare videos dekhta hun... please send me day book on me mail id [e-mail]

[@pankajchawla5353]

kya is cash book se ledger ban skta hai

[@pateldhaval8425]

Thanks you sir... Really best lesson.... Wish you all the best for new trick and trips....

[@hakvlogs3119]

kzbin.info/door/bPWd4LetHC7v1wkT91fAVg

[@sonichoudhary8685]

Great Teacher...you made me excel very comfortable...🙏🙏

[@LM-mq3cv]

Your too good.....just love the way you explain in detail. Very simple ,clear and easy to understand 💯

[@madan30in]

Thanks!

[@md.mahmudulhasan9351]

That was really useful dear. Thank you for your effort. I am grateful to you.

[@DeepakEduWorld]

😊😊😊😊

[@ganeshamirineni2836]

explain the formula

[@MunnaSingh-fq4di]

[e-mail] Sir tabl send kardijiye

[@amirstudio8088]

Hi I am amir from Pakistan , can I send me this file. On [e-mail]

[@ਖੁੱਲੇਸ਼ੇਰ]

@@DeepakEduWorld sir please karva do mera hall

[@rahitechworld589]

Wow! Amazing, having watched your videos I am feeling very comfortable in excel .thanks sir

[@hakvlogs3119]

kzbin.info/door/bPWd4LetHC7v1wkT91fAVg

[@diagnocarelab9901]

Peace upon you and your family Deepak, you are creating everyone expert in their businesses thank you

[@hakvlogs3119]

kzbin.info/door/bPWd4LetHC7v1wkT91fAVg

[@amitkumarsundesha]

धन्यवाद!

[@srikanthkarney7311]

Great work Deepak ji keep going something new today

[@DeepakEduWorld]

😊🤗🤗

[@aijazali7664]

Sir ye

[@aijazali7664]

[e-mail]

[@aijazali7664]

[e-mail]

[@aijazali7664]

Sir ye email kar de geian mujhy chahe

[@twinklejaiswal7486]

Sir love you 💞💝🎁🎁💚💜💜💙💕✨👍👍👍👍👍

[@fanuser3053]

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.

[@hakvlogs3119]

kzbin.info/door/bPWd4LetHC7v1wkT91fAVg

[@anillamathing]

It is beneficial

[@rohitvlogs4202]

Bhut hi accha video hai Thanks 10 saal pahle sikha tha but aaj sab kaam a raha hai thanks bhai

[@venkatiyer4667]

That was really good job, Thanks a lot

[@hakvlogs3119]

kzbin.info/door/bPWd4LetHC7v1wkT91fAVg

[@superintendenttalala5623]

Deepakji!!! How to add Opening Balance on Dt.01-04-2019 in this format plz reply sirji

[@VikramBhatilovekodial]

Add it in reciepts

[@shiningstars2573]

Simply add opening Bal in some date that will be counted as entry of a date.

[@VIJAYPATEL-zz6cx]

Thanks this daybook excel sheet is really helpful...Thanks again Sir....👍👍🤷‍♂🤷‍♂😊😊😊😊 i am very happy..

[@VIJAYPATEL-zz6cx]

Thank You Sir..👍👍

[@abdulquddus3873]

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

[@DeepakEduWorld]

In next day book video... 👍 As soon as possible i ll publish video

[@09shirish]

@@DeepakEduWorld I also appreciate Abdul bhai to know more about bank transactions ! Thanks !

[@illjani1]

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]

Filter all data having value 1000... Delete the filtered data ( rows ).. . After that.. clear filter👍👍👍👍

[@illjani1]

Good, I tried it, once I done and second time I couldn't. But afterwards I do as it,

[@illjani1]

Thank you for your reply and your time. I liked your way of work and sincerety.

[@v.p.thapliyal8510]

@@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 [e-mail]. Thanks

[@riajuddinraju1353]

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 :)

[@anjanacomputers]

Thank u sir

[@manjulsharma805]

Yeah same issue ...How did you solved it ? Thanks

[@anandbodhid.k.4140]

मैं भी दीपक कुमार हूँ (आनंद बोधि) देने से ही रोशनी का आनंद का बोध होता है । धन्यबाद

[@psivaramadatta8969]

Hi, If i want to get total monthly income, in the sense if i give "may" i should get may month Balance

[@hakvlogs3119]

kzbin.info/door/bPWd4LetHC7v1wkT91fAVg

[@manoharpatil7246]

But. If vendor payment fails then how to make a debit note

[@Ankitganga_kinaare.]

Did get the answer

[@sureshpai2469]

Individual Expenses or Income ledger - how we can get?

[@DeepakEduWorld]

I ll Publish video as soon as possible 👍

[@azharfarooq5957]

@@DeepakEduWorld sand me please [e-mail]

[@inocentkiran8712]

Sir mujjy ye format ap mail kr skaty hain plz

[@purushottamt2820]

Sir apki he video se me excel expert bn rha hu Thank you so much sir 🙏☺️

[@kollipararameshchandra2839]

When I click double click at date, the dates aren't coming for the remaining 365 days

[@meghsoftnet]

double click on the right bottom corner of cell where you can see small size box

[@wildkitchen7563]

It was nice...I got lots of knowledge about day book. And it helped a lot. But I need it in my mail... [e-mail]

[@খাবারমানেইদুর্বলতা]

[e-mail]

[@naturebeautywithhasima5530]

It's was nice. I got lost of knowledge about daybook .And it helped a lot.But I need it in my mail... [e-mail] 9252592158

[@nishantpal4675]

🙏🙏🙏🙏सर जी नमस्ते आपसे एक चीज पूछनी थी आपने जो सेल इनवॉइस बनाए थे यूट्यूब पर मैने उसको डाउनलोड किया और उसमे काम करके देखा उसमे एक चीज नहीं हो पा रही है

[@Yuvasakti849]

Kay nahi ho paraha hain

[@subashchander8979]

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 [e-mail]

[@keharsingh8735]

[e-mail]

[@SunnyKumar-xk4pw]

Mujhe formula chahiye sir ji [e-mail]

[@ankitsaini-xo8ty]

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

[@kjchauhan11]

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 👍😁

[@sunilkushwaha4826]

Sir your all videos are very knowledgeful. Thank you so much.

[@gampasathvik3475]

Deepak ji your are telling is simple language and easily understand. Thankyou

[@AkashSharma-go4mj]

Great work sir 🙏🏻🙏🏻🙏🏻 Love from Kanpur 😘😘

[@rjsbatteryworld27]

Very use sir me 2 hour ur video seeing and iam work sheet banaaya thank u bro

[@bilolitimesnews3268]

बहोत बढीया सरजी मुझे सिखनेकु आसान हो गया आपका व्हिडीओ देखके thanks sir

[@rameshwarimestry]

Thank u so much for taught us this easy and excellent method.🙏

[@popatraut685]

आभारी सर मी तुमचा व्हीडीओ डाऊनलोड करून सेम तूमच्या सारखच टेबल बनवले व मला न चुकता आले सर मला 2 तास लागले पन आता हेड बदलून मी दुसर्या कामासाठी वापरले परत एकदा आभारी आहे सर.

[@naseerawan]

❤❤ thanks a lot brother I really appreciate you 👍 With the help of, you made my work easy

[@TheVivaanPro]

Very good I Understand Very good Thank U sir God Bless u Vivaan From Mumbai

[@mohdnadeem5811]

Thank you very much to help us and wish be happy always and be successful always

[@sjstringz]

amazing bro.. seriously amazing.... itna bhtt ek ek normal shopkeeper ko apna account rkhne k liye

[@venkat_1956]

Dear Deepak Really you have done a wonderful job.

[@mehargaming9895]

this kind is very very very helpful for me i am also searching over one year butt now i reach my right way.. thanks

[@Newsalive24]

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....

[@saratchandranayak5287]

You have the best video among all the videos related to excel

[@rpideahealthknowledge9225]

Apka content bahut hi helpful hai

[@BilalAhmed-wc4nl]

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.

[@mutumrajib4886]

👍 👍 👍 very helpfull video.. This is helpfull for daily personal Expenditure.. Account

[@shafqatpervezkhan]

Deepak Thanks a lot for informative video

[@ratna798]

Very Nice and Useful video...

[@GudduMourya-eo9sx]

Aapke samjhne ka tarika bahut aaccha hai sir ji....nice video

[@mukeshjangid1985]

superb bro thanks for supporting all peoples for business

[@Ryuzaki.Lawlite]

Thank You Bro Have a Good Day ✌😊

[@ghulamullahkhan597]

Really you are the best one father of excel .

[@constructionmaster9622]

Sir zabardast the way u teach superb. Impressive detail sir zabardast

[@RajuPawar-j8z]

Sir Bahot achese samjhaya... Thank you.😊

[@parveensangar]

your teaching method is too good Thanks sharing your knowledge

[@Roji-876]

Watching from nepal🤗❤

[@asimraza49]

Sir I'm very impressed for your this video And i get lot of knowledge about this video

[@goodluckenterprise8832]

that's really helpful for beginner like me thanks a lot

[@anandvlogs1725]

Nice video sir 😮😮😊😊😊

[@n.r.murughan7651]

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.

[@TheMujeebmuhammed]

awesome, you have explained very well, very much informative, thank you Deepak.. all the best... prayers

[@m.twoodwork779]

Thanks Sir Very Helpful Video

[@raj28san]

Hello Sir, Thank you very much. You have taught me so stepby step. My God Bless you and keep going sir, I liked it.

[@mdazizulislam5052]

So Good. Thank you From @Bangladesh

[@mandeepsinghshahu4884]

Thank you so much 🙏🏼 Really helpful 🫶🏼

[@Naaz-eMazhar]

Hi sir building maintenance collection entry sheet ka automatic ban sakta hai ? Jis me room's ke monthly maintenance ki entry ho aur balance bhi pata chale 4:36

[@krishnapariyar8043]

Very Informative video Sir ❣️❣️

[@thinkandquestion1305]

Deepak, you are just amazing! Thank you so much. And, Happy New Year 2023. I am watching your video on Jan 1st, 2023 at 12:35 AM.

[@DeepakEduWorld]

Thank you so much 😀and very happy new year!

[@prasenjitpandit2803]

thank you so much sir. app all dowlod ka optin de rakha he..upoer wala apko or vi accha noleze de

[@syedmuzaffar8987]

Very nice sir ...good explanation

[@ahmesaddique9665]

Wonderful Presentation and Work done by my brother. Thanks

[@brownmunde5164]

Thank you very much sir salute h aapko ❤❤ Se

[@virendrarajput3194]

Very nice education given by you regarding daybook......Thanks

[@DKW2Do]

such a interesting and helpful video you worked really hard should deserves 10 million subscribers

[@vickeysss]

Respect and thank you so much from PAKISTAN

[@manishbhawara8372]

Suprbb bro... U hve solved my problem thanx a lot

[@nagendrasingh408]

Great job brother. I hope this will help me in my business.

[@sukrajjadhav1985]

very well explained sir 👌👌👌

[@poonamvidya.mhaske2339]

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 😊😊😊

[@XzenderMonitor]

very greatfull and helpfull video nice good

[@masumbadsha5684]

Excellent job dear brother..it help me more and more.. thanks a lot

[@mukeshsinha529]

Nice sir👍 its useful for us

[@atuldoshi1642]

Fantastic explanation, very impressive and very slowly beautifully narrated thanks a lot sir

[@neerajjindal2895]

Ur teaching experience is very good... Helpful video for business.. Great work

[@sunainakathuria]

Hii if we want to add credit column in receipt method but same should not be added in receipt amt on daybook sheet. What is the formula

[@sameenarafiq1339]

Very nice --- You are awesome... Thank you so much

[@tamilbusiness9846]

Simple and good explanation for easy understanding.

[@hakvlogs3119]

kzbin.info/door/bPWd4LetHC7v1wkT91fAVg

[@maheshtalagursreekanthaia2599]

Thank you sir, this is Mahesh T S from Bangalore,

[@rahuldubey7125]

धन्यवाद सर... 🙏

[@ralphshrock6272]

Form are very difficult complex. Thank you very much helping us.

[@kanaiyalaltandel9259]

It was realy good job sir, thanks lot

[@sazalsarkar2130]

The More I watch the more I learn. Just Excellent May God Bless You My Dear Boss/ Dada.

[@DeepakEduWorld]

🤗🤗🙂🙂

[@sumitverma8762]

Sir send me hum ek apna coaching institute chalaate students ki fees EMI m dete haai use remind or fees kaise maintain kare [e-mail]

[@vishalsheel4488]

Thank you sir for your information 🙂

[@ॐशिवॐ]

आप का बहुत बहुत धन्यवाद जी

[@happylearning2005]

Informative and useful video deepak sir

[@satishmandlik9724]

Deepak sir, aap ke har video interesting hote hai. Isi video ko VBA Excel me bhi banaiye. Thanks...

[@hibafanclub]

Very good.. keep it up..👍

[@geartech6152]

Really helpful- Great 🤟

[@shaikhkhairuzzaman4516]

Dear Sir, Your video is educational and inspired me. Request to upload new videos (Inventory/Production accounting related). Thank you.

[@arundulal2841]

Its a very helpful video Sir Thank you for making this

[@hakvlogs3119]

kzbin.info/door/bPWd4LetHC7v1wkT91fAVg