Dear Sneha,
I will try to conduct virtual class for doubts and upcoming topics.
My request to all please increase your participation in this channel so that I feel that you all are interested.
Thanks
I will try to conduct virtual class for doubts and upcoming topics.
My request to all please increase your participation in this channel so that I feel that you all are interested.
Thanks
Dear Friends,
Please share your valuable suggestions and share this channel with your friends.
Thank you
Please share your valuable suggestions and share this channel with your friends.
Thank you
**** Let's take a look at one more cool Excel feature that removes duplicates. You can use the Advanced Filter to extract unique rows (or unique values in a column).
The Advanced Filter dialog box appears.
2. Click Copy to another location.
3. Click in the List range box and select the range A1:A17.
4. Click in the Copy to another box and select cell F1.
5. Check Unique records only.
6. Click OK.
Result. Excel removes all duplicate last names and sends the result to column F.
2. Click Copy to another location.
3. Click in the List range box and select the range A1:A17.
4. Click in the Copy to another box and select cell F1.
5. Check Unique records only.
6. Click OK.
Result. Excel removes all duplicate last names and sends the result to column F.
Question: -
Shortcut key to remove duplicates in Excel.
Answer: -
Alt + A + Q
Shortcut key to remove duplicates in Excel.
Answer: -
Alt + A + Q
Dear Friends,
Please share your valuable suggestions and share this channel with your friends.
Thank you
Please share your valuable suggestions and share this channel with your friends.
Thank you
*Question of the day*
Question: - Which function we can use to find out the 2nd position from the bottom?
Question: - Which function we can use to find out the 2nd position from the bottom?
Anonymous Quiz
17%
Max
29%
Min
44%
Small
10%
Large
*Question of the day*
Question: - VLOOKUP help to extracts the data from which side of table?
Question: - VLOOKUP help to extracts the data from which side of table?
Anonymous Quiz
39%
Left side
36%
Right side
18%
Top side
8%
Bottom side
Some shortcut keys of MS Excel
Ctrl+K - Insert Hyperlink
Ctrl+N - New Workbook
Ctrl+O - Open
Ctrl+P - Print
Ctrl+R - Fill Right
Ctrl+S - Save
Ctrl+U - Underline
Ctrl+V - Paste
Ctrl+K - Insert Hyperlink
Ctrl+N - New Workbook
Ctrl+O - Open
Ctrl+P - Print
Ctrl+R - Fill Right
Ctrl+S - Save
Ctrl+U - Underline
Ctrl+V - Paste
Dear Friends,
Please share your valuable suggestions and share this channel with your friends.
Thank you
Please share your valuable suggestions and share this channel with your friends.
Thank you
Question: - What is Paste in Excel?
Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.
Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.
Shortcut key to do following functions in Excel.
Copy: - Ctrl + C
Cut: - Ctrl + X
Paste: - Ctrl + V
Copy: - Ctrl + C
Cut: - Ctrl + X
Paste: - Ctrl + V
Question: - What is “Paste Special in Excel?
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -
➡️Question: -
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S
❗️Note: - This “Paste Special” only works if you have copied or cut some data.
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S
❗️Note: - This “Paste Special” only works if you have copied or cut some data.
Dear Friends,
Please share your valuable suggestions and share this channel with your friends.
Thank you
Please share your valuable suggestions and share this channel with your friends.
Thank you