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
☝️🟢Step 1: - Click on Cell ‘J8’ and press ‘=’ this will activate the cell to use function, and start typing ‘Vlookup’.
🤟✌️🟣Step 5: - After selecting Table array please put koma (,) and the third field will reflect ‘Col_Index_Num’ which means from which column you want to find the results, Type number 2 here.
(Explanation: - In this problem we have only two columns in which data is exist, and we want to find the Price based on Product and Price is lying in second column that is why we typed 2 here)
(Explanation: - In this problem we have only two columns in which data is exist, and we want to find the Price based on Product and Price is lying in second column that is why we typed 2 here)
Dear Friends,
Please like and subscribe my youtube channel so that I can come up with Lookup and Vlookup videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Please like and subscribe my youtube channel so that I can come up with Lookup and Vlookup videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA