How to create Day Book Report in Excel in Hindi step by step
ฝัง
- เผยแพร่เมื่อ 30 ก.ย. 2019
- in this video of Microsoft excel 2022
Learn How to create Day Book Report in Excel in Hindi step by step automatically. create receipt voucher || payment voucher || day book report in Microsoft excel 2007/2010 2013 2016 2019 in Hindi || cash book in excel
Download Training File : deepakeduworld.com/day-book-i...
New Date to Date Attendance Sheet video : • How To Maintain Attend...
Plz Also Subscribe My New Channel DEEPAK TECHWORLD : / @deepaktechworld
Sumif formula : • SUMIF formula in excel...
if formula • IF Logical Function in...
iferror formula • How to use IFERROR for...
Attendance sheet Video : • How to Maintain Attend...
Fully Automatic Cashbook Video : • Fully Automatic | Cash...
thanks for watching deepak eduworld. i hope you like the video and subscribe the channel.
have a nice day my friends
Playlists:
Advanced Excel : ► goo.gl/A6LdZA
Advanced Excel Formulas : ► goo.gl/bbHYu2
Excel Tips & Tricks : ► goo.gl/wAj1jh
MS Word Tutorial : ► goo.gl/B4TeSA
HTML5 and CSS3 : ► goo.gl/2PFgs8
Computer Technology : ► goo.gl/paZmpn
Automatic Invoices in excel : ► goo.gl/dFhg54
Subscribe DEEPAK EDUWORLD : ► / deepakeduworld
Follow On Instagram : ► / deepakeduworld
Facebook Page : ► / deepakeduworld
Facebook Group : ► / deepakeduworld
LinkedIn : ► / deepakeduworld
Tags : how to create day book report in excel in hindi step by step,cash book in excel,how to create petty cash account with excel,accounts in excel,account entry in excel,advanced excel in hindi,day book in excel,how do you make a book in excel,how do i create a ledger in excel,learn excel,microsoft excel,deepak eduworld,deepak nehra,excel tricks,excel tutorial,ms excel,daybook in excel
*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
Your too good.....just love the way you explain in detail. Very simple ,clear and easy to understand 💯
Great Teacher...you made me excel very comfortable...🙏🙏
Sir Bahot achese samjhaya... Thank you.😊
Deepak ji your are telling is simple language and easily understand. Thankyou
Thanks you sir... Really best lesson.... Wish you all the best for new trick and trips....
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
Wow! Amazing, having watched your videos I am feeling very comfortable in excel .thanks sir
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
बहोत बढीया सरजी मुझे सिखनेकु आसान हो गया आपका व्हिडीओ देखके thanks sir
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 video is very excellent video. And very good job this video is very useful. So again thanks
Peace upon you and your family Deepak, you are creating everyone expert in their businesses thank you
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
मैं भी दीपक कुमार हूँ (आनंद बोधि) देने से ही रोशनी का आनंद का बोध होता है । धन्यबाद
thank you so much sir. app all dowlod ka optin de rakha he..upoer wala apko or vi accha noleze de
That was really good job, Thanks a lot
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
My friend Many many Thanks. Really good Man. I have benefited a lot from getting your demo. God bless you. I hope you can give such a good video. Thank you very much Depok friend.
😊😊😊
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
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
आभारी सर मी तुमचा व्हीडीओ डाऊनलोड करून सेम तूमच्या सारखच टेबल बनवले व मला न चुकता आले सर मला 2 तास लागले पन आता हेड बदलून मी दुसर्या कामासाठी वापरले परत एकदा आभारी आहे सर.
Superb video sir , you are the great teacher......
😊🤗🤗
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
I've seen your automatic attendance sheet. it is very useful and has many things to learn. I made it. Thanks
Bhut hi accha video hai Thanks 10 saal pahle sikha tha but aaj sab kaam a raha hai thanks bhai
Sir love you 💞💝🎁🎁💚💜💜💙💕✨👍👍👍👍👍
Excellent video sir thanks. Kindly create a mis complete video. I request
As soon as possible 😊
amazing bro.. seriously amazing.... itna bhtt ek ek normal shopkeeper ko apna account rkhne k liye
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.
U r the best Teacher , 🙏
🤗😊
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
Very good I Understand Very good
Thank U sir
God Bless u
Vivaan
From Mumbai
Apka content bahut hi helpful hai
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
Sir, u r an unique & superb teacher..pls tell how to separate cash & card amount in balance column ?
I ll publish another video for day book.. shortly 😊
I can understand easily thank you.
Thanks for your good tutorial. I am from Bangladesh.
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
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.
this kind is very very very helpful for me i am also searching over one year butt now i reach my right way.. thanks
Respect and thank you so much from PAKISTAN
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 !
Sir - Aise new trick mujhe like hai
😊
can you send me this formula
ezatullah.safi2244@gmail.com
your teaching method is too good Thanks sharing your knowledge
Fantastic explanation, very impressive and very slowly beautifully narrated thanks a lot sir
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
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
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.
Am very grateful to your tutorial you have helped me to create my own daybook for my business . I salute you
Hi, King of Excel, May I know Where is came ideas into your creative mind., go ahead!
😊
Sir I hats off you, kindly one video for students certificates record years wise,photos and acknowledgement
@@DeepakEduWorld plz
But. If vendor payment fails then how to make a debit note
Did get the answer
❤❤ thanks a lot brother
I really appreciate you 👍
With the help of, you made my work easy
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....
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
NYC😗😎😎😍😍😀🙂
😊😊😊
Thank u so much for taught us this easy and excellent method.🙏
Thank you very much to help us and wish be happy always and be successful always
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
superb bro thanks for supporting all peoples for business
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 nice education given by you regarding daybook......Thanks
Ur teaching experience is very good... Helpful video for business.. Great work
Wonderful Presentation and Work done by my brother. Thanks
Deepak Thanks a lot for informative video
Sir I'm very impressed for your this video
And i get lot of knowledge about this video
Dear Sir, Your video is educational and inspired me. Request to upload new videos (Inventory/Production accounting related). Thank you.
Very helpful video and can be used to maintain daily records.Thank you Deepakji. Can we also make a list of payment method for a full year on day to day basis using dates. Could you also upload a tutorial about preparing a huge data set/bank in excel .
Would also be obliged to receive a template from you.
God Bless.
👍 👍 👍 very helpfull video..
This is helpfull for daily personal Expenditure.. Account
that's really helpful for beginner like me thanks a lot
Simple and good explanation for easy understanding.
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
So Good. Thank you From @Bangladesh
such a interesting and helpful video you worked really hard should deserves 10 million subscribers
Good Work, It helped, pl also mention how to freeze formula cells to protect sheet formatting
Thank you very much sir salute h aapko
❤❤ Se
Amazing sir, you have given very knowledgeable demo in Excel. Thank you very very much. Dhanyawad 🙏
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
Very use sir me 2 hour ur video seeing and iam work sheet banaaya thank u bro
Thanks this daybook excel sheet is really helpful...Thanks again Sir....👍👍🤷♂🤷♂😊😊😊😊 i am very happy..
Thank You Sir..👍👍
Very good Lesson. Thank you.. wish to have this template..
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
Great job brother. I hope this will help me in my business.
Thank you brother. May God bless you!
Thanks Sir
Very Helpful Video
Thank you sir. Please explain how to use standard formula for totalling date-wise debit and credit columns and balance in next line, like cash book in tally.
Great work sir 🙏🏻🙏🏻🙏🏻
Love from Kanpur 😘😘
Suprbb bro... U hve solved my problem thanx a lot
zabardast!!!
Informative and useful video deepak sir
thanks deepak ji , its very helpfull for us
Form are very difficult complex. Thank you very much helping us.
awesome, you have explained very well, very much informative, thank you Deepak.. all the best... prayers
Deepak sir, aap ke har video interesting hote hai.
Isi video ko VBA Excel me bhi banaiye.
Thanks...
Thank you sir Very very helpful video
You are doing a great job, thank you so much for your valuable contribution🙏
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
Excellent Job. God Bless you.
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
bahut saandaar bhai... frm uttarakhand
Excellent job dear brother..it help me more and more.. thanks a lot
Its a very helpful video Sir Thank you for making this
th-cam.com/channels/bPWd4LetHC7v1wkT91fAVg.html
Really you are the best one father of excel .
Hi Deepak sir, stock ko volume ya sqft me kesy mantain kren gy.
Thanks a lot Mr.Deepak
आप का बहुत बहुत धन्यवाद जी
Very nice --- You are awesome... Thank you so much
Thank you so much 🙏🏼
Really helpful 🫶🏼