Відео

Hi Aditya. I may take some time to come up with this topic as I am traveling but for sure I will come up with Part 3.

Thank you so much Suman 😊😊😊

Thank you so much Ganesh 😊

Thank you so much, video ko like karne ke liye. Stock management ka Video main soch raha thi banaun but aapne bola toh iss topic ko main prior basis par rakh leta hun 😊😊😊

Thank you so much 😊😊😊

Thank you so much Suman 😊😊😊

Zarur Amit. Jald hi aapka format bhi banane wala hun

Please drop me a mail on vijaymuukh@gmail.com . Also share your phone number. I will connect you

Thank you so much Harish ☺️☺️☺️

2021 aur Ms Office 365

Zarur. Jald hi

Thank you so much, appreciate karne ke liye. Main sure hun ki aap kuch seekh bhi rahe honge

Most welcome Aditya. Part 3 will be very interesting and Advanced. By the time you can practice Part 1 and 2

Next Video will be conditional formatting Part 2. Noted your request Aditya

Channel Membership join karna hoga aapko, file download karne ke liye. Aapke morning wale comment par already comment kiya tha maine

Hi Himanshu, Please drop me a mail on vijaymuukh@gmail.com with the name of the formats you are looking for

Hi Himanshu, I haven't got any mail yet. Please send me a mail and I will share the file

I share Excel sheet on mail so please drop me a mail on vijaymuukh@gmail.com

A35 aur A36 me kya liya hai aapne ? Aur agar aap start date insert kar rahe ho toh, A35 aur A36 cell reference kaise ho sakta hai ? Kyun ki ye Cell number toh kaafi neeche hai

@@OfficeFreak ji hum fir se formula lagaye hai 👉 DATEVALUE("1"&K2&M2) farst day insert karne ke liye, humne Cell Nambar N12 me formula lagaye hai, K2 me Month ka Drop-down hai Aur M2 me Year ka Drop-down hai, Es tarah se formula lagaye hai 👉 =DATEVALUE("1"&K2&M2) Enter karne ke baad, Es tarah se baata Raha hai 👉 #VALUE! Aur me Apne Android phone 📱 me Google sheet use karta hun. Es problem ka solve kaise karen kripya bataiye. Thank you 🙏

Dropdown se Month & Year select kiya kya ? Agar select nahin karoge toh #value error show karega

@@OfficeFreak Haa kiye hai

vijaymuukh@gmail.com Mail karo format. Dekh leta hun

Jald hi

No doubt, Ctrl E is an awesome feature. It's my personal favorite 😊😊😊

Very soon 😊

Thank you so much for loving the video. Stay connected 😊

Formulas can be adjusted as per requirements

Dashboard with Pivot table par already video hai mere Channel par. Lekin phir bhi aapke liye jald hi video banaunga iss topic par

Go to your settings on top in UA-cam and change the quality to high. All my Videos are in 4k quality. So not clear is really not possible. Once you will change the quality, Video will be sharp

Thank you so much. Conditional formatting is an awesome feature and really a vast topic. It's just the part 1

Thank you so much Prem for loving the video and getting connected with the Channel

Thank you so much for loving the video and getting connected with the Channel. Must watch my other videos. I am sure, you will learn a lot

List is quite long but I will try my level best to come up with the formats you have asked for

Thank you so much Amit. Aapke kehne par hi maine ye topic cover kiya. I am sure ki ye video dekhne ke baad aapko Conditional Formatting ka basics ,acche se samajh aa gaya hoga. Jab aap Excel par practice karenge toh saare doubts ekdum clear ho jayenge

Helper column insert kar sakte ho aap. Aur helper ko Lookup Value le lo. Items chahe kitni baar hi repeat kyun na jo jaye, woh baar baar show karega.

Thank you so much Umesh. I tried my best to cover all the things, keeping the format simple

Aap language ki baat kar rahe hain ya font ki ?

@@OfficeFreak Mujhe sir Hindi me typing karna hai kaise kare ms exel me ...?

@gulfam_siddiquee Macbook use kar rahen hain aap ya windows?

@@OfficeFreak MacBook

Go to System Settings On the left hand side , go to keyboard, Text input, Input sources, Click on edit, New window will open, In the bottom, click on + sign Add your Desired language now Click on Done On top righ hand side of your laptop, you will see, English, click over there. As soon as you will click on that, you will see the new language which you recently added. Select that. Now open your excel file and start typing

It's urgent bro Or should I put in comments what I need to male so u make ?

Abhi toh MacBook me kaafi hindi fonts inbuilt hain. Aap fontbook me ja kar check kar sakte ho.

Formula kya type kiya ? Please bhejiye

vijaymuukh@gmail.com Aap apna format mail kar den, main dekh lunga

My pleasure and thank you so much for loving the video and getting connected with the Channel 😊😊😊

Fuel record for which industry? Every industry will have different tracking way and purpose. If you will specify your requirements, I will try creating the format

@@OfficeFreak it's for our own fleets of trucks and have our own tank of fuel. Which we receive. Now want to keep records for fuel balance qty remain as in litters

@@OfficeFreak bhai I'm waiting

@salmankhanworld6 It will take time. I have many things lined up, so I can't change that. A video takes nearly 2 days to be ready. So i will try to come up with the format, you have asked for, after 20th October

@@OfficeFreak understood but do you give online lessons as in we pay something and u teach monthly??

Thank you Qasim. I try to create all types of Excel Formats on my Channel so that everyone can create them easily

I haven't got your point 😕

Sure Umesh. Soon

Mac me inbuit kaafi fonts hain. Aap Google se aaram se download kar sakte ho. Phir bhi issue aata hai toh aap mujhe batayen, link share kar dunga

=IF(E$4<EOMONTH($E$4,0),E4+1,"EOM") This is the formula for 2nd and rest of the dates. Please check once E4 is 1st Date

i cannot fix the formula for the summary sheet (4th sheet) error showing too many arguments for this function, please help me.

@88devashish vijaymuukh@gmail.com Mail me the format

Thanks

Most welcome Devashish 😊😊😊

Thank you so much for loving the video and getting connected with the Channel 😊