🤔🤔⭕️⭕️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
⭕️⭕️Let us discuss 'Formats' option of paste special command.
Forwarded from M.S. Office, Excel, PowerPoint, Word
⭕️⭕️This will help in a situation where you want to copy the formatting of one cell to other cells. Please use below steps: -
Forwarded from M.S. Office, Excel, PowerPoint, Word
Forwarded from M.S. Office, Excel, PowerPoint, Word
⏯Step 1: - Use Copy command on the range (Column H and Column I) of cells by using below shortcut keys: -
Ctrl + C: - Copy
⏯Step 2: - Come to “Column K” and Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
⏯Step 3: - Select “Formats” option and Press “OK”, other options should not be changed.
Ctrl + C: - Copy
⏯Step 2: - Come to “Column K” and Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
⏯Step 3: - Select “Formats” option and Press “OK”, other options should not be changed.
Forwarded from M.S. Office, Excel, PowerPoint, Word
Forwarded from M.S. Office, Excel, PowerPoint, Word
🎥🎥For Video trial please click on below link: -
https://youtu.be/BXyGREk6ICk
https://youtu.be/BXyGREk6ICk
Forwarded from M.S. Office, Excel, PowerPoint, Word
Dear Friends,
Please share your valuable suggestions and share this channel with your friends and please subscribe.
Thank you
Please share your valuable suggestions and share this channel with your friends and please subscribe.
Thank you
Good News!!!!
In the coming days I will try to share content on Vlookup and then Hlookup.
Please do practice as much as you can and ask your doubts.
Thank You
In the coming days I will try to share content on Vlookup and then Hlookup.
Please do practice as much as you can and ask your doubts.
Thank You