Excel में कोई भी Function कैसे लिखें
ฝัง
- เผยแพร่เมื่อ 1 ต.ค. 2024
- 👉 FREE Excel Webinar. REGISTER NOW
event.webinarj...
How to write any function in Excel.
In this video, we will be understanding how to write a function in Excel. Understanding of Syntax & arguments.
For more such videos subscribe to our channel: / @learnwithlokeshlalwani
Follow me on Instagram: www.instagram....
![10 Important Basic Formulas of EXCEL || Transpose, GCD, Product, Power, SQRT, Roman etc || [Hindi]](/img/n.gif)
Learn Excel from my in-depth course: hi.switchy.io/ExcelMasterclass 🔥🔥
you are committed it will be free of cost but actuary you have wasted our productive time
Sir in my Excel no function is coming after pressing= I have to get function from insert. Function and as I press = name range show function how to change this ??
Plzz help
iciw
Nice sir...bohot acha smjhaya... bt jb lengthy value put krni hoti h to mujhe smjh ni ata comma kha aagya bracket kha lgega 😅...plz is pr knowledge share kijiye 😄
Lokesh ji, I must say that you are best in Excel and you have a great way of teaching which helps us with a new one. We want just upload your all Excel course on TH-cam.
Isase Jyada acche tarike se pure TH-cam mein koi bhi nahin Sikha Sakta
You r one of the best trainers of Excel. U make things so simple to understand.
🙌🙌
Sir एक ऐसा फार्मूला बताए , जिसमे की कोई भी date लिखे तो वह date अपने next, wednesday या saturday की date में convert हो जाए
VLOOKUP Ka syntax sikhao usme bahut confusion h like table array, index, lookup value, range etc..Plz reply
Sir g इसे ओर डिटेल से बताइये प्लीज
जिसमें 2 या उससे अधिक फंक्शन यूज़ होते हों जैसे if and या if or etc
Sir,
While preparing a salary sheet it's means entering the working days. The employees are DEPT. Wise and Emp id also DEPT. Wise not in a serial wise also. Here how I am bring it all DEPT Emp id In a serial wise like attendance register.
Guide me sir
MUZGH step by step excel sikhni hai Mai JHARKHND DHANBAD se hoon sir plz help me.
Sir, when I try any formula but even if the formula is correct, the answer is not correct every time, why does it happen and how can I solve it
very nice video sir 🙏👍😊
Why you Stop making videos on excel and other Sir
Sir,
How to highlight colour and row while selecting or searching an Emp id or name in a excel sheet.
Guide me sir
I apply for ccc+ Exams ,SPIPA so send me this type video
Dinesh Fefar
Thank you so much information dene ke liye sir Excel ke bare mein Hamen aur samjhaie❤
Sir mere liye kya aap IF condition ka ek video bana sakte Hai Kya mujhe thoda problem hota usse samje ne main
quality hy sir ...*
Thanku so much sa y r so great teacher 🙏🏻😇💐
It's my pleasure
Thank you sir
आपका समझाने का तरीका बहुत ही सर्वश्रेष्ठ है ।इसका और भी पार्ट देने का कष्ट करें ।
Please sir ji "making the video to pivot Table " Thanks! Good Day "
how did you get the sum of the amount , with rupees sign in each cell ? kindly reply.
Sir mujhe ek excel formula ready krna h aap help krenge.....plzz
Very good explaining the difference between active argument and optional argument 👏 👍 👌
Glad you liked it
Loved it Sir, ek ek word aapne sahi kaha about our learning knowledge of excel. This basic video was very much informative and gave answers to my questions. A big thank you.
Hello genious, abusolity I like it, clear my logic, thanks.
What is different between TH-cam video and paid class?
Very good, I never knew difference between use of tab and enter. Very well explained 👏 👌 👍.
Sir pls suggest best book for advance excel . I required for job purpose . I have basic knowledge doing from last 10 years but required knowledge for next level jobs .. pls suggest ..
If you are really serious about learning Advanced Excel then you can enroll for my Premium course. It will make you a master in Excel. I have put in my 10 years of experience in this course. learn-with-lokesh-lalwani.thinkific.com/courses/Excel-Masterclass
Sir ACCRINT & ACCRINTM ka video chahiye
Business me Stock ko manage krne pe koi video bnae Bhai plz
Sir, I have a problem
Can you help me to understand how to complete a complex formula. When I use index match formula, I am never sure how to complete that.Hoe many brackets to put or will it requires anything else.
Sir power point aur word pa ek full video banya please.
Love You Brother❤ From Bangladesh🟩
Sir,
How to understand and remember the excel function to apply.
And also how to use as per the situation a function in excel
Guide me sir
I'd be more than happy to guide you through this process and help you become proficient in Excel functions.
Understanding Excel Functions:
Excel functions can seem overwhelming at first, but with practice and proper guidance, you can master them. Here are some steps to help you understand and remember Excel functions:
1. Start with the Basics: Begin by familiarizing yourself with common functions like SUM, AVERAGE, MAX, MIN, and COUNT. These foundational functions will lay the groundwork for more complex ones.
2. Explore Function Categories: Excel functions are organized into categories like Text, Date & Time, Logical, Lookup & Reference, and many more. Take some time to explore the functions within these categories and understand their purpose.
3. Function Syntax: Pay attention to the syntax of each function. It consists of the function name, followed by arguments enclosed in parentheses. Understanding the correct syntax is crucial for using functions effectively.
4. Online Tutorials and Courses: There are numerous online tutorials and courses available that offer step-by-step guidance on Excel functions. Consider enrolling in one to gain a structured learning experience.
5. Practice, Practice, Practice: The key to remembering Excel functions is regular practice. Create sample datasets and experiment with different functions to reinforce your understanding.
Using Functions as per the Situation:
Knowing which function to apply in a given situation comes with experience and a deeper understanding of your data analysis needs. Here are some tips to help you choose the right function for specific scenarios:
1. Define Your Objective: Clearly outline what you want to achieve with your Excel data analysis. Are you looking to perform calculations, manipulate text, or extract specific information?
2. Explore Function Library: As you become more familiar with Excel functions, you'll build a library of functions that you're comfortable using. Refer to this library to identify potential functions for your current task.
3. Contextual Help: Excel provides helpful contextual help for each function. Press "F1" when you have a function selected to access the Excel Help window, which provides detailed information and examples.
4. Online Resources: When in doubt, don't hesitate to search for Excel function guides or ask for help in online Excel communities. Many Excel experts are willing to share their knowledge and provide assistance.
5. Combine Functions: Often, you'll find that using multiple functions together can yield the desired result. Don't be afraid to combine functions to achieve complex calculations or data manipulations.
I hope these tips help you on your journey to mastering Excel functions. Remember that practice and persistence are key to becoming proficient. If you have any specific questions or need further guidance on any function, feel free to reach out to me. I'm here to support you.
Happy Excel-ing!
Awesome Communication, Please upload a video about "Conditional Formatting "new rule".
Thanks.
I already have a video posted on my channel on the same: th-cam.com/video/0TmiGkCYqPA/w-d-xo.html
Sir how to rite formula to convert active voice to passive voice
Muje abhi tho yaad ho gaya lekin kaam karte vakt bhul jata hu
sir square bracket ka bhi use karke dikhaana chahiye tha isme
Appropriate formula exactly what sir
Very simple and excellent explanation... 👌👌
Bahut shukriya aapka sir very nice video
too good for basic understanding
Very informative. Bht Acha smjhaya apnay. The way you teach is impressive.
Thanks for liking
In my system, no symbol can be pasted in custom formating. Why? Pl help.
Hi Ranjit, you need to post your query on the Microsoft forum to check you system compatibility.
Thanks sir, very useful video.
Bohot accha laga video sir
Sir ek hi arguement mai control press karke koi cell refrence enter karke nai karsakte uske liye bhi mujhe alag arguement select karna parga kya?
Yes Siddhique, different argument hi karna padega.
🙏
Bahut hi must required info video. Thank you so much Lalwani ji. Your work and effort is much appreciated
i need to a very special video from you .how i do in excell sheet use any excel furmula,in which like a maks sheet total amount's cell after put any changes of amount value,so other cell "in word" amount automatically changed.please make a video.& share on your channel.
लोकेश सर! आप बहुत स्मार्ट हैं आपकी ओर से एक्सेल सीखना और समझना हमारे लिए बहुत उपयोगी होगा।
I have no words explain your beauty of explanation , thanks a lot Sir 🙏🙏
Very very useful video because mai bhi MIS ki class kar rha hu lekin function ka real concept aj tak aisa nhi samjhaya kisi ne thank you so much for this video
Good job sir g keep it up..i have subscribe your channel.
Plz help.how can I start..
Salam sir from Pakistan 🇵🇰
Sir kya power bi course join Karne se pahle Hume Excel ma expert Hona compulsory ha kya,please rey Thanks.
You need to have a basic knowledge of Excel
@@learnwithlokeshlalwani thanks sir
Ever green TH-cam channel.
Nice explain and understand
Want More videos on this basics
Your voice is very clear ,I understand esaliy
Thanks you sir for this helpful video
I never found any channel in you tube like your i was trying more a good channel got it thanks 🙏🙏🙏
Really nice video instead of watching a lot of videos on TH-cam just understand the concept of formulas I'm CA students I work in excel I m facing problem in index, match & index match please tech me 3 formulas thank you
Really sir great but I have some doubts sir when we will be use like that symble " space ( , and more symble please sir reply or make a video on topic
Lokesh ji aapka Padhane ka technique bahut badhiya hai.
Thank you so much for your comment.
You are best teacher i ever learnt from thankyou sooo much
Glad to hear that
Nice sir teaching method
Bahut badhiya sir
Tremendous. Kia bat hai ap ke style ki. Itna shandar way of teaching. Great.
Very Informative Sir
Ye sb koi ni btata🙏🙏🙏
Very nice vedio sirji
small but knowledgable
Excellent! PLEASE upload the Work with Various formula and also I want to know that What is the meaning of 1 2 3 4 in excel formula watching many times.
Thanks lot dear
Please make a video on work progress report and work schedule in Construction project
Dear sir make a video l
Loop condition in macro in excell
Sure, will do in future.
Sir aap great ho ji 🙏😊
Excellent video because mostly people make videos on functions but not the concepts.
How to calculate net income with 0 decimals
Calulate profit % with 2decimals
I m biggner
Sir, Please show video for Index and Match function
Bhout useful banya sir thanks pivot table and vlookup
Basic of PowerPoint
Hi Lalwani Sir please solve one problem, I know the EMI, interest rate and tenure, then how can I calculate Principal in excel.
Way of feeding is very nice, like your explanations, thanks
Please make video on how to put formula in a formulated sheet
Your way of understanding is much better, that is why it feels good to listen and understand and it also comes quickly.
Thank you for your kind words. I'm glad that my approach to understanding is helpful and efficient.
Very very well explanation sir☺👍
Thanks and welcome
वाह सर मजे आ गए आज तो आपकी ये वीडियो देखकर। कितना अच्छे से समझते हो आप। आज सिंटेक्स और आर्गुमेंट बिल्कुल अच्छे से समझा दिया । Thank you so much
Thank you !!!
Aap bahot achchhi Tarah explain karte hain. thank you sir
Very beautiful video yes more video
Keep Watching
Advance Excel
Really great.
Great Sir Ji
Very nice 👍👌
Awesome! Just bought your book. Hope it helps.
Very good sir