Dear Friends,
Please share this channel with your friends and family members. Please also like and subscribe my youtube channel so that I can come up with new videos of Excel.
Thank you
Please share this channel with your friends and family members. Please also like and subscribe my youtube channel so that I can come up with new videos of Excel.
Thank you
Please rate the content provided in the group, is it understandable to you.
Final Results
27%
1
18%
2
29%
3
12%
4
45%
5
M.S. Office, Excel, PowerPoint, Word pinned «⭕️⭕️⭕️In continuation of topics going on, now we are coming with a new topic which is called “Lookup”. This will help you in a situation where you want to find the data based on some lookup value. let us go through the syntax of ‘Lookup’: - ➡️➡️Syntax =LOOKUP…»
⭕️⭕️⭕️After discussion on “Lookup” first condition in which the lookup value is same as mentioned in the Table Array, let us discuss the second condition if the lookup value is different and not in the Table Array, then how lookup function will work.
➡️➡️SSyntax
=LOOKUP (lookup value, Array)
➡️➡️SSyntax
=LOOKUP (lookup value, Array)
☝️🟢Step 1: -
Click on Cell ‘K7’ and press ‘=’ this will activate to cell to use function, and start typing ‘Lookup’.
Click on Cell ‘K7’ and press ‘=’ this will activate to cell to use function, and start typing ‘Lookup’.
✌️🔵Step 2: - After Typing ‘Lookup’ start the function by using any one from below two sub-steps: -
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
🤔🤔⭕️⭕️Question: -Why 0% is coming in front of 50 why not 5%?
🟢🟢Answer: - In the second condition, the sale value which we are trying to find is not available in the Table Array, we know that excel is very smart and, in this situation, excel will show you the discount of near lower value of that sale value.
♦️♦️Example,
➡️Sale value 50, Discount is 0% which is of 0 Sale Value.
➡️Sale value 150, Discount is 5% which is of 100 sale value
➡️Sale value 360, Discount is 15% which is of 300 sale value
➡️Sale value 985, Discount is 45% which is of 900 sale value
♦️♦️Example,
➡️Sale value 50, Discount is 0% which is of 0 Sale Value.
➡️Sale value 150, Discount is 5% which is of 100 sale value
➡️Sale value 360, Discount is 15% which is of 300 sale value
➡️Sale value 985, Discount is 45% which is of 900 sale value
Dear Friends,
I know this function is difficult but If you understand this you will feel comfortable while doing Vlookup and Hlookup.
If you have any doubt you can ask me
Thank you
I know this function is difficult but If you understand this you will feel comfortable while doing Vlookup and Hlookup.
If you have any doubt you can ask me
Thank you
Dear Friends,
Please share this channel with your friends and family members. Please also like and subscribe my youtube channel so that I can come up with new videos of Excel.
Thank you
https://youtu.be/ajXVo6MM258
Please share this channel with your friends and family members. Please also like and subscribe my youtube channel so that I can come up with new videos of Excel.
Thank you
https://youtu.be/ajXVo6MM258
YouTube
Paste Special option 'Column Widths' Hindi
Use of “Column Widths” option in Paste Special Command.
In continuation of last topic of “Paste Special”. Let us discuss Sixth Option “Column Widths”.
This will help in a situation where you want to make similar width of every column. Please use below steps:…
In continuation of last topic of “Paste Special”. Let us discuss Sixth Option “Column Widths”.
This will help in a situation where you want to make similar width of every column. Please use below steps:…
Some shortcut keys of MS Excel
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
These shortcuts are related to formatting only.
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
These shortcuts are related to formatting only.
Forwarded from M.S. Office, Excel, PowerPoint, Word
Question:-
What is Function in Excel.
Answer:-
A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
What is Function in Excel.
Answer:-
A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
Forwarded from M.S. Office, Excel, PowerPoint, Word