Welcome to my RU-vid channel dedicated to Office Productivity and Technical skills. This channel features comprehensive tutorials and tips on Microsoft Excel, PowerPoint, Word, Google Sheets, MacBook, Video Editing, designed to help you master these tools and improve your productivity.
Whether you're a student, a professional, or just someone who wants to enhance their technical skills, my videos provide step-by-step guidance and practical insights to help you get the most out of these tools. I cover everything from basic features to advanced functions, and the content is suitable for beginners and experienced users
So, if you want to become an expert in Microsoft Excel, PowerPoint, Word, Google Sheets, MacBook, and video editing, be sure to subscribe to my channel and hit the notification bell to stay updated with latest content.
It's perfectly fine. This Attendance sheet is for 1 year. Means all the entries will be done in a Single Sheet. So when the months will be changed from the dropdown, Range of Start date, month and year will change automatically. Jan 24 - Dec 24 Feb 24 - Jan 25 March 24 - Feb 25 April 24 - March 25 In case you still have some confusion, please let me know. Thanks for watching the video with so much attention. Really appreciate
Hi Naren, Thanks for the appreciation. I have mailed you 2 Formats of Daily Sales Report. Please check your mail. In case you are not able to see my mail, please check spam once. I mailed you the formats an hour back
In this for highlight holidays you are using the formula in conditional formatting=COUNTIF(Holidays, cell value) and then choosing the colour. Cell value means first date of the month. Here I can't understand. Please help
Ashish, Why are you confused ? I haven't used any Countif in the conditional formatting. Can you please tell me at which minute in the Video you saw this formula ? Please send me your contact number
Over there I have used Countif because in the Settings Sheet, I have given Holidays a name through Name Manager. In recent formats I stopped using Countif
dont understand why you added a holiday column , there could be more than one holiday impacting the delivery date and only one is appearing in the cell. what does top sheet do? and weekly ,, monthly tabs are supposed to do what/
Dont understand why you added a holiday column , there could be more than one holiday impacting the delivery date and only one is appearing in the cell ➡️ Holidays and weekends are for PLANNING and not for delivery dates. What does top sheet do ➡️ Instead of working in boring Excel Formats, it makes format more interesting. It totally depends on person to person what he or she wants to put in the format. and weekly ,, monthly tabs are supposed to do what ➡️ Some people plan for Daily, some plan for Weekly and some plan for Monthly. Even some plannings are done Yearly and 5 yearly. Again it totally depends on your preferences and need of hour. Thank God, you haven't asked Why I used Bright Colours ? Why I used specific fonts Why I used only those functions and formulas and not others ? Why haven't I created this in Ms Word or PPT ? List of your queries may me long. Many things may be useless for you in the format but for many people it's beneficial. Seems you haven't liked anything in the format, only reason no appreciation came and list of negative highlights were quite long. Thanks for the comments. Stay smiling 😊😊😊
If you want the format to pick-up all the things automatically then you will have to do the entry in 2nd Sheet. In case you want to do the entry manually, just delete all the formulas in paid days and all the entries can be done manually
@shivamtiwari-sr9po below is the link to join the Channel Membership. Once you join the Channel Membership drop a mail on vijaymuukh@gmail.com ru-vid.com/show-UCBz4_fNn1dN4IiS3KWleoKQjoin
@@Office-Monk Thank you for quick response however I am getting error for both countA and sum .. error is there are more circular references where a formula refers to its own cell either directly or indirectly
@@Office-Monk It got resolved.. thank you so much ... I have one more question.. please in holiday I have calendar for 3 different region where some holidays are common eg. New year and for some dates are common but different holiday how include in the list
@Indianlucknawi New year, 2nd holiday, 3rd Holiday You can do this. The other way is to create filtered list as per region. When you will change the region, all the holidays will change
Many many thanks to you for the creating the useful video. This video is very useful to me and others. I hope you create a multi-sheet data calculation and sum calculation formula is easily taken.
Bro meny aik bnai h lekin jb bhi me dopdown list se month change krta hn to previous month ka data bhi os me aa jata h means me jo January me entries krta hn wohi entries poori sheet me aa jati h plz mjhy kch btay es baary me plz bro
Drop downs se months Change karne se data delete nahin hoga. Drop down create karne ka basic reason ye hai ki aapko Months ke name baar baar type na karna padey. Agar aapne Video gaur se dekha hoga toh maine ye kahin nahin bola hai ki Drop Down se months change karne par saara purana data erase ho jayega. 12 months ke liye 12 sheets create karne padenge aapko
@@Office-Monk nhi bro meny kisi aor k channel se d3kh kr bnai h, data delete nhi hota, data khud ba khud doosri sheet pe copy ho jata h means k jab me aik employee ka name January wali sheet me likhta hn aor os k baad jb os ki present and absents lgata hn to wo entries saari khud ba khud January se February march... December wali sheet pe copy ho jati h aor jb en se ye data erase krta hn to pehly wali sheet se bhi data erase ho jata h plz aap mjhy btay es baary me agr aap ki koi video h es pe fully automatic attendance sheet pe kindly plz mjhy send kry video ka link mjhy bohat zaroori chaiyeh plz bro
@@Office-Monk bro data delete nhi hota balky khud ba khud all sheets par copy ho jata h agr January me kisi employee ki present lgaon to wo bkaya month me b present lag jati h
@@Office-Monk meny aik dost se aap ka channel liya h os ne mjhy aap ka link dya h channel k yaha se aap ko information mil jaygi jo aap ko chaiyeh to plz bro mjhy video ka link send kry jo aap ne fully automatic attendance sheet bnai ho
Thank you so much for the appreciation. As you asked, why the format is shared if one can't download ? I have shared Video too and in the video I have described in detail, how to create the format from scratch. Now my question from you, why can't you create the format by watching the video ? Why you need to download the file ? Take some pain and put your effort In the description box of the video, from where you tried to download the file, I have clearly mentioned that file download option is only for Channel Members and you will have to join the Channel Membership to download the file. You even didn't take the pain to read what was written over there. Really awesome. You can create your own format by watching the video and in case you face challenges with the formulas, I am always ready to help and for that I will not ask you to join the Channel Membership. Thanks
You are teaching in English, You should teach in Hindi to get more popular and your subscribers will definitely increase! Your teaching style is appreciatable😊😊
ru-vid.com/show-UCBz4_fNn1dN4IiS3KWleoKQjoin Click on the link and you will be diverted to join the Channel Membership. In Channel Membership Levels, you will get a level of PPM Tracker Download. Join that level and drop me mail on vijaymuukh@gmail.com I will share the Excel file
I applied this now function in the check in time cell but the value of time will be changed if I run another cell of check in time or check out time , how can we find the actual time for this situation
Go to File Tab, on the left hand side you will get the option of Formulas. Click on Formulas, now come to right hand side, enable iterative calculation. Do Maximum iterations as 100
Dear Sir, I have a Question, i have preapred along with you seeing this youtube. When i enter the leaves, PL, WO in my excel for my employees, it is not showing any updates. Please suggest where my mistake will be, how to correct it. Waiting for your help. Thanking You in advance.
my company works in 3 shifts(US, AUS, UK) and when an employee starts his/her shift , entry is made using ctrl+; & ctrl+shift+; , and similar thing is done when he/she takes break (2 times 30minutes in one day/shift) & also when completing day(8 hours). so doing 7:30 work in a continuous will make one day. (here us(night) shift person logs in @ 8 pm on a day and leaves @4 am next day. Anything above 7:30 is counted as Overtime and added in salary at overtime rate which is specified. Can you please make video showing how to make such dashbaord or calculation sheet.PLEASE PLEASE
my company works in 3 shifts(US, AUS, UK) and when an employee starts his/her shift , entry is made using ctrl+; & ctrl+shift+; , and similar thing is done when he/she takes break (2 times 30minutes in one day/shift) & also when completing day(8 hours). so doing 7:30 work in a continuous will make one day. (here us(night) shift person logs in @ 8 pm on a day and leaves @4 am next day. Anything above 7:30 is counted as Overtime and added in salary at overtime rate which is specified. Can you please make video showing how to make such dashbaord or calculation sheet.PLEASE PLEASE
Can be possible client wise auto update loan amotozation table? Also if possible interest rate change so auto update automatic in excel Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment already showing in your video ,Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest
Can be possible client wise auto update loan amotozation table? Also if possible interest rate change so auto update automatic in excel Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment already showing in your video ,Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest
your videos are so very helpfull! and easy to follow, if have time can you give me an insight of how can I create a simple leave planner for employees annually and can overlap from 2024 to 2025 if an employee has decided to take a leave from dec 2024 to jan-2025. just I need to know if the employees leave would cross over the submission dates. thanks in advance