M.S. Office, Excel, PowerPoint, Word pinned «Dear Team,
On the regular demand from the group members, I have decided to start the live class. Those who are interested please select one option.»
On the regular demand from the group members, I have decided to start the live class. Those who are interested please select one option.»
Question of the day.
What is transpose in Excel, where it is exist and how it is working?
Please write your answer in comments.
What is transpose in Excel, where it is exist and how it is working?
Please write your answer in comments.
Answer;-
Transpose is the function which helps you to convert table from vertical to horizontal and horizontal to vertical form.
It is exist in Paste Special box in Home tab.
Working:-
1. Select the table and copy it.
2. Press shortcut on keyboard Alt+E+S and select transpose from here.
Thank You
Transpose is the function which helps you to convert table from vertical to horizontal and horizontal to vertical form.
It is exist in Paste Special box in Home tab.
Working:-
1. Select the table and copy it.
2. Press shortcut on keyboard Alt+E+S and select transpose from here.
Thank You
Dear All,
Thank you for your reply with correct answers.
Looking forward to have more detailed answers with example from your side on the questions which will be provided in the group
Thank you for your reply with correct answers.
Looking forward to have more detailed answers with example from your side on the questions which will be provided in the group
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.
Some shortcut keys of MS Excel
Ctrl+Tab - In a workbook: activate next workbook
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl++ - Insert
Ctrl+- - Delete
Ctrl+Tab - In a workbook: activate next workbook
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl++ - Insert
Ctrl+- - Delete
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
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
M.S. Office, Excel, PowerPoint, Word pinned «⭕️⭕️Let us discuss 'Formats' option of paste special command.»
Forwarded from M.S. Office, Excel, PowerPoint, Word
After having discussion on Lookup and Vlookup, let us now discuss one of the best function of Lookup Family ‘Hlookup’ with Approximate Match.
Syntax
=Hlookup(lookup_value, table_array, row_index_num, [range_lookup])
Important Note: -
1. ‘H’ stands for Horizontal lookup
2. Only works towards extracting data from the downside of the table.
Syntax
=Hlookup(lookup_value, table_array, row_index_num, [range_lookup])
Important Note: -
1. ‘H’ stands for Horizontal lookup
2. Only works towards extracting data from the downside of the table.
Forwarded from M.S. Office, Excel, PowerPoint, Word
♦️♦️In the screenshot you can see one problem is given in Table A and we need to find the Discount Percentage in Table B. We will solve this problem with the help of ‘Hlookup’ function. Please follow below steps: -
Forwarded from M.S. Office, Excel, PowerPoint, Word
☝️🟢Step 1: - Click on Cell ‘C13’ and press ‘=’ this will activate the cell to use function, and start typing ‘Hlookup’.
Forwarded from M.S. Office, Excel, PowerPoint, Word
✌️🟢Step 2: - After Typing ‘Hlookup’ 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.
Forwarded from M.S. Office, Excel, PowerPoint, Word
🤟🟣Step 3: - Select ‘Lookup Value in Cell C12’ as given in the syntax.
(Lookup Value is the value for which you want to find the result and based on this you can find the result from Table Array).
(Lookup Value is the value for which you want to find the result and based on this you can find the result from Table Array).