- 72
- 244 336
Excel With Ravi
India
เข้าร่วมเมื่อ 14 มิ.ย. 2014
हेलो दोस्तो,
Excel World में आप का स्वागत है।
मैंने यह Channel Microsoft Excel की Knowledge को उन सभी को शेयर करने के लिए बनाया है जो Excel को जल्दी ओर आसान तरीके से सीखना चाहते है । में इस चैनल पर हिंदी में वीडियो पोस्ट करता हूँ ताकि आप सभी को आसानी से समझ मे आ सके।
अगर इस channel की Video आपको अच्छी लगी हो तो Channel को Subscribe करे और Videos को अपने दोस्तों से शेयर करे ।
Channel Content
Basic Excel
Advance Excel
Excel Tricks and Tips
All Function and Formula
Short Keys
In case of any simple or complicated EXCEL Query, You can join our WhatsApp group for instant solution.
Click on below link for join WhatsApp group.
chat.whatsapp.com/BymUIDEt3ME9yd1ScCRXkL
Channel पर Visit करने के लिए आपका बहुत बहुत धन्यवाद।
Excel World में आप का स्वागत है।
मैंने यह Channel Microsoft Excel की Knowledge को उन सभी को शेयर करने के लिए बनाया है जो Excel को जल्दी ओर आसान तरीके से सीखना चाहते है । में इस चैनल पर हिंदी में वीडियो पोस्ट करता हूँ ताकि आप सभी को आसानी से समझ मे आ सके।
अगर इस channel की Video आपको अच्छी लगी हो तो Channel को Subscribe करे और Videos को अपने दोस्तों से शेयर करे ।
Channel Content
Basic Excel
Advance Excel
Excel Tricks and Tips
All Function and Formula
Short Keys
In case of any simple or complicated EXCEL Query, You can join our WhatsApp group for instant solution.
Click on below link for join WhatsApp group.
chat.whatsapp.com/BymUIDEt3ME9yd1ScCRXkL
Channel पर Visit करने के लिए आपका बहुत बहुत धन्यवाद।
Simple Steps for Vertical to Horizontal Lookups in Excel
Unlock the power of Excel with our latest tutorial, "Simple Steps for Vertical to Horizontal Lookups in Excel"! Whether you're a beginner or looking to enhance your excel skills, this video guides you through the essential steps needed to transform vertical data into a horizontal format using lookup functions.
In this video, you'll learn:
How to efficiently use the HLOOKUP and TRANSPOSE functions,Tips for organizing your data for optimal results, Real-life examples to solidify your understanding, Common pitfalls to avoid when performing lookups
Join us as we simplify the lookup process and help you become more proficient in Excel. Don’t forget to like, subscribe, and hit the notification bell for more Excel tips and tricks!
#ExcelTutorial #DataManagement #ExcelTips #VerticalToHorizontal #HLOOKUP #VLOOKUP
In this video, you'll learn:
How to efficiently use the HLOOKUP and TRANSPOSE functions,Tips for organizing your data for optimal results, Real-life examples to solidify your understanding, Common pitfalls to avoid when performing lookups
Join us as we simplify the lookup process and help you become more proficient in Excel. Don’t forget to like, subscribe, and hit the notification bell for more Excel tips and tricks!
#ExcelTutorial #DataManagement #ExcelTips #VerticalToHorizontal #HLOOKUP #VLOOKUP
มุมมอง: 144
วีดีโอ
How to translate text in Excel
มุมมอง 72หลายเดือนก่อน
Unlock the secrets of Excel in this game-changing video! Are you looking to "translate text in Excel" effortlessly? Whether it’s for work, school, or personal projects, mastering Excel’s translate features is essential in today's global landscape. Join us as we guide you step-by-step on how to harness powerful translation tools right from your spreadsheet! Say goodbye to language barriers and h...
Pivot Table Options
มุมมอง 602 หลายเดือนก่อน
This video serves as a detailed guide to understanding all the options available for pivot tables, delivered in Hindi. It aims to equip viewers with the necessary skills to effectively utilize pivot tables for data summarization and analysis. Whether you are a beginner or looking to refine your skills, this tutorial provides valuable insights into the world of pivot tables. #Excel #DataVisualiz...
Pivot Table in Excel
มุมมอง 1663 หลายเดือนก่อน
Unlock the power of data analysis with our latest tutorial on Pivot Tables! This video will guide you through the essentials of creating a pivot table and mastering the classic view in pivot for better visualization. Whether you're a beginner or looking to brush up on your skills, we'll show you how to analyze and break down quarter wise data in pivot effortlessly. Boost your productivity and b...
Basic Pivot Table in Excel
มุมมอง 783 หลายเดือนก่อน
In this informative video, we will learn the fundamentals of creating a basic pivot table in Excel. You will learn how to organize and summarize your data effectively, enabling you to gain valuable insights with ease. Whether you are a beginner or looking to refresh your skills, this tutorial will guide you step-by-step through the process of building and customizing pivot tables. Join us to en...
How to Next Round Zero Number in Excel
มุมมอง 734 หลายเดือนก่อน
Discover the capabilities of the Ceiling function in Excel in this comprehensive tutorial. This function is essential for rounding numbers up to a designated multiple or decimal place, making it invaluable for various applications in data management and analysis. We will guide you through the process with clear explanations and real-world examples, ensuring you gain a solid understanding of how...
How to Jump on Specific Cell
มุมมอง 484 หลายเดือนก่อน
Learn the quick and easy way to jump to a specific cell in Excel by using the "Name Box" feature in this step-by-step tutorial! Whether you're a beginner or an Excel pro, this video will show you the efficient method to smoothly navigate to your desired cell with precision. Say goodbye to endless scrolling or repetitive clicking and hello to a smarter way of spreadsheet navigation. Mastering th...
How to Convert Text to Number in Excel #Shorts #ShortVideo
มุมมอง 3603 ปีที่แล้ว
How to Convert Text to Number in Excel #Shorts #ShortVideo
NETWORKDAYS.INTL Function in Excel in Hindi
มุมมอง 2.1K3 ปีที่แล้ว
NETWORKDAYS.INTL Function in Excel in Hindi
Lookup With Duplicate Lookup Value in Excel
มุมมอง 4134 ปีที่แล้ว
Lookup With Duplicate Lookup Value in Excel
Lookup on Each Duplicate Value in Excel
มุมมอง 5914 ปีที่แล้ว
Lookup on Each Duplicate Value in Excel
Find Email from Mix Data using Index Formula
มุมมอง 1944 ปีที่แล้ว
Find Email from Mix Data using Index Formula
Use index+match or advance sumproduct formula instead of using the same formula 3 times..
Bhai agar minimum number biche main hua to fir mid start number kaha se karega
Thanks sir for such imp learning 🤝
Thanks for watching brother.
Thanks sir
Thanks for watching
Thanks Sir for the Knowledge 🎉
Thanks brother. I'm getting motivation after reading your comments. 🫂
Horizontal to vertical which function is used in excel
@@SheelgandhChandankhede Hlookup function. Will upload video on this soon.
Video acha laga but concept samajh nahi aya. B3 ke baad &"0123456789" kyun lagaya ? Is ke peeche kya logic hai?
Aap formula ko evaluate kr ke dekho, concept clear ho jayega.
@@ExcelWorldmis Ok. I will try.
like
@@amirferasat3281 thank you
Hame b sikha do Bhai😊
Bhai m bhi sikh hu rha hu
Wasting your time bro. Highlight the cell, go to data, then go to from table/range this will bring power query editor. Then go to split column then go to by non digit to digit. Then go to close and load. This guy method is old and long.
Thanks for the feedback....but if you use VBA then no use of your method also. I have shared video for those who searching job for MIS. If you are in interview then your choice and your method not help to get job. You have to answer as per interviewers requirements.
Can you pls explain for Vertical to Horizontal format.
Sure....will upload a video shortly.
awesome dude i was searching it for 1 hour
Thank you!
Very good explanations! Easily understood everything clearly.
Thank you so much brother 🙏
Thanks for the knowledge 🤝
Thanks for watching brother.
Thank you Ravi Sir
Super hit video sir thank you so much
Thank you
I'd agar bracket k ander ho to keyse kare?
Tb to or bhi easy h ...Left or find function use karke nikal sakte ho.
Nice, & help full
thanks bro Good Luck
Thank you sir
Bahut jyada accha
Thankyou
It not showing in 2007 Excel
Please check again...you can use teanspose in 2007
Thanku so much for that kind of solution.
Thanks 🙏🙏
Fantastic👍
Nice trick sir ji
Very hectic
This Formula only works when the number starts from "1", for any other number it does not work
Sir number chahe kisi bhi digit se start ho formula sahi kam krega. .aap please ek bar fir se formula check kijiye.
Alt kb use karte hai aur control kab use karte hai Alt aur ctrl me kya difference hota hai? Please guide us 🙏
Very nice 👌
Drag krne pr id nhi ari mere me Android mobile me
Sir formula ek bar fir se check kijiye ho jayega.
Very helpful
Acha lga apka video par ek confusion hai like Vijay 793 alok 699 Rakesh 600 pritam 999 jese value ek cell me hai or muje ye value alag alag cell me chaiye kese kre
Will this work in more than one cell?
Yes sir you can use....if any issue please share data with me
Hi sir just iska opp ka example bataye where array is vertical and data need in horizontal
With 2 match conditions
Will share video on this soon
Sure ..will share video
Thank you so much ❤️❤️❤️
Jab minimum le rhe hai to zero aana chahiye n.? 1 kyu aa rha?
Sir minimum function number ki position k liye lgaya h na ki number k liye. Aap ek bar fir se try kijiye. Agr fir bhi koi issue ho to btana.
rahul tyagi -- tyagi is a last name ..last name me kar k dikha..
Jarur sir will upload video on this topic shortly
@@ExcelWorldmis kyu aata nahi hai kya?
mai sikha du?
Nobody is perfect sir...you can share formula. Everyone will see here
very very nice bro...
Thank You Sir for watching
Thanks. How do you do the reverse action? Bottom list to the top list pls?
Did you get answer?? Pls share
th-cam.com/video/OMcwM8BxRlA/w-d-xo.htmlsi=0iVzHdTDwPlzCJ8C
Hats off to you Sir 🫡
Getting anergy after reading this type of comments. Thank You so much for watching 🙏
but my question would be, why'd anyone combine name and ID# in the same field?
Sir this is only an example data...some time when we export data from l website or ERP we find combined data , like you will get pin, zip code with address.
Since I didn't hear English, I turned the sound off, but got the idea.
Thank You so much for watching 🙏
Can you help me with this one?, how can you extract these, its driving me crazy, they have different length and kindly provide me a formula, i would appreciate all the help coming from you. here's the Data.. i only need the Last name and the FIrst name.. GONZALGO PIFAMY, JUAN TAGALOG S 235656 JOHN AVILA, MARIA KAREN K 85621 PABABA PATAAS, PAMELA 222222 ANG BATO, DARNA 54321
Sir, how to seperate negative sign from no. for eg. A B C -100 to - 100 600 600 -700 - 700 800 800 Please Reply.
If you want several Only negative sign then you can use FIND function with LEN.
❤❤❤❤ great job
Thank you
Ajay varma vs Ram deshmane to.... Ajay /Ram hona chahiye.
thank you man, clever decision
Thank You 🙏
It showing. #value!
Ctr+shift+enter kijiye
U can easily get numbers by using Right formula. Your process is very long
Sir right formula tabhi kam krega jb number digit same hogi.
Bhai itana jarurte nahi btane ke CtrlE kar do ho jayega
Sir hr condition me ctrl e kam nhi krta or interview me formula se krna pdega.