Hello everyone, I am Prem Kant Pandey, a trainer & Learner by passion. It's a dedicated channel for Excel beginners and Professionals. Here I introduce about Excel and cover many things like Excel functions, Shortcut keys, etc. that will help you to prepare a dashboard, and enhance your skills in Excel. The uploaded tutorial videos are in Hindi. Please share this channel with those who want to learn and explore Excel.
दोस्तो नमस्कार, यह चैनल एक्सेल के लिए एक समर्पित चैनल है। यहां मैं एक्सेल के बारे में काफी जानकारियां देता हूं और एक्सेल फंक्शंस, शॉर्टकट कीज इत्यादि जैसी कई चीजें शामिल करता हूं जो आपको डैशबोर्ड बनाने, एक्सेल में अपने कौशल को बढ़ाने में मदद करेंगे। अपलोड किए गए ट्यूटोरियल वीडियो हिंदी में हैं। कृपया इस चैनल को उन लोगों के साथ साझा करें जो स्वयं एक्सेल सीखना और एक्सप्लोर करना चाहते हैं।
by inserting the dollar $ sign in cell reference or range. to freeze any range you need to press function key F4. Checkout the link below to know why need to freeze columns ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xz2G2BkW0qg.html
Function key F4 Cell referencing ke bare me or jyada jankari ke liye click on the link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xz2G2BkW0qg.html
Great sir maja aa gaya shuru me babut problem aai fir comment pad kr solution mil gaya usme funda f4 press krne ka hai. Please aap ek video me f4 ko acche se clear kr dijiye.
Thanks for your valuable feedback, Cell referencing ke bare me or jyada jankari ke liye click on the link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xz2G2BkW0qg.html
It works in all direction like left to right or right to left also top to bottom. Checkout the link below ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dSmUGx0_2eA.html
Bhai main yahi chahta hun mujhe yah batao main dusre ke downloaded data Ko jab fix karta hun Apne personal data mein to usmein mujhe date ka format change ho jata hai mujhe vah format change nahin karna hai sem format chahie Jo mere pass mere Excel sheet mein hai vah kaise hoga
Excel me default date format System ke acording hota hai, aap apne system ke seting me ja kar date ka format change kar lijiye. Is video me jo bataya gaya hai wo sirf waise case me work karega jaha aapko lage ke pehle month hona chahiye jabki system use date samajh raha ho. Jyada Jankari ke liye mujhe whatsapp Kar sakte hai @ 9708153000
Entering Column number manually is not a dynamic solution if you are trying to fetch data from the table based on the header, one thing you can do here is apply the VLOOKUP formula on a single cell and copy-paste.